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:
valuefield which is basically the corresponding syntax passed into your query
textfield which shows the labels in your dropdown.
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 (
text) for the dropdown filter from the query below:
SELECT DISTINCT id, name FROM quicksell.cities ORDER BY 2
We have just created a dropdown filter for our report!