Add Dropdown Filters To Reports (Legacy)
Let's add a dropdown filter to let your users filter this report by City that the posting was listed.
A drop-down filter in Holistics consists of 2 comma separated values:
- the
value
field which is basically the corresponding syntax passed into your query - the
text
field which shows the labels in your dropdown.
The text
field is shown as the option on the dropdown list, but when chosen, the equivalent value
is referenced.
In this video, we will load the values of this city
drop-down filter from an existing database table (values of table shown on 0:13).
Holistics will create the 2 comma-separated values (value
and text
) for the dropdown filter from the query below:
We have just created a dropdown filter for our report!