Filter by right-clicking a table
Every table widget on your dashboard can drive the filters that already exist on that dashboard. Right-click any cell, and if a filter targets that column, you’ll get a shortcut to apply it — right there, right then. Example: right-click a cell in theStatus column where the value is Closed. If the dashboard already has a filter on Status, the context menu shows:
- Right-click any cell in a table widget.
- If the dashboard already has a filter for that cell’s column, Filter by [Column] = [value] appears in the menu.
- If other columns in that row also have filters, Filter by this row appears too — it sets every matching filter at once, in one click.
- Every widget that uses that filter updates immediately, everywhere on the dashboard.
Note: This only works with filters that already exist on the dashboard — right-clicking never creates a new one. If you don’t see a Filter by… option for a column, add a filter for it first from + Add Filter.
How the value gets applied
For a dropdown-style filter (likeStatus), clicking Filter by… replaces the current selection with the value you clicked — it doesn’t add to whatever was already selected. For a date filter, it sets a single day as the range.
When a column doesn’t match automatically
Sometimes the column name shown in a table doesn’t match its real name in your data source — for example, if the underlying query renamesstatus to s. When that happens, right-click filtering can’t tell the two are the same column. Filter Mapping lets you point it in the right direction, by hand, once.
Tip: You’ll only ever need this for renamed columns. Most tables need no setup at all — right-click filtering already works automatically whenever a column’s name matches its source.
Setting up a mapping
- Open the table widget’s Table Settings (the pencil icon on the widget), then switch to the Filter Mapping tab.
- For the column that isn’t matching, open its dropdown — real columns from your data source are listed, grouped by table.
- Pick the real column it actually comes from. Leave anything already working as
Not mapped— no need to touch it. - Click Save Changes, then save the dashboard. Right-click filtering on that column now works.
Note: Mapping is entirely manual — nothing gets guessed or auto-filled. Some columns are computed from an expression and don’t have one single real column behind them; those simply stay Not mapped, and right-clicking them just won’t offer a filter shortcut. Everything else on the table keeps working normally.
Quick answers
Does mapping a column create a new filter? No. Mapping only helps right-click filtering recognize a column that already has a matching filter elsewhere on the dashboard — it never adds a new filter by itself. What if I map a column to the wrong source? Open its dropdown any time and pick a different one, or chooseNot mapped to clear it. Nothing is permanent until you click Save Changes.
Do I need to map every column on the table? No — only the ones that are renamed and that you actually want to use with right-click filtering. Everything else is unaffected.
Does this affect Drill Through or Related Questions? No, those are separate features and work exactly as they did before.
