Convolutions are painful. Especially when you’re looking for some very specific information(often using filters). Wouldn’t you like something that’s functional and easy on the eye?
We’ll now tell you how to create a single column table that doubles as a filter, that is, a ‘single column quick filter’.
Consider the sales dashboard of a multinational company. Let us assume that the consumers of the dashboard would want to filter data based on the ‘Region’ field. Let’s create a frill-free filter to achieve this objective in 8 simple steps:
1. Drag the dimension by which you want to filter, ‘region’ in this case, to the column block.
2. A two-column table, with the second column having the “abc” place holder text, appears.
3. Create a calculated field (named as ‘BlogFilter’ for this example) with only “ “ as formula, and add it to the columns.
4. Also add BlogFilter to the text button in the Marks tab. The ‘ abc ‘ place holder text is now gone.
5. Remove the column divider, using formatting tab and hide the column labels.
6. The result will be a single column table without any header. Now drag the worksheet to the required dashboard and edit the title as per your requirement.
7. Enable filter to the column by clicking on the ‘use as filter’ options.
8. For the column to be unaffected by external quick filters, select the ‘Ignore Actions’ button.
VOILA!!! The single column quick filter is done.
Note: This type of filter can be used in combination with another filter of the same type or a quick filter. But if you are using another quick filter for the same field in the dashboard, then the filter defaults to “all”, but the filtering still happens.
Also, you don’t have the “all” option that quick filters provide for aggregation. You can work around this by selecting all the rows in the field. But, this makes it a bit tedious for fields with a large number of unique values.