Adding Dropdown Filters To Your Report


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:

  1. the value field which is basically the corresponding syntax passed into your query
  2. 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).

Filter dropdown citydb

Holistics will create the 2 comma-separated values (value and 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!