You can customize global dashboard filters - select default value for dropdowns, apply conditions to filter the values displayed in dropdowns & sliders, use labels to rename the filters



You will see a customization form for dashboard filter.



You will see the option to customize the filter via form, or via SQL.

To customize dynamic filters visually, select 'Using Form below' option and update the form as required. Click 'Set' and save the chart



To update the SQL query of dashboard filters, select the 'SQL query' option to use an SQL query to populate dashboard filter dropdows or sliders. You will see a textbox with SQL query for your dynamic filter.

Update the query and click 'Set'. Then save the dashboard.

Please note: For dropdown menu filters, select only 1 column in your SQL query.

Please note, if a filter value is not applicable for a dashboard chart, it will not populate the chart with any data, when you select a filter value. It is advisable to select fields such that they are applicable to all charts in a dashboard.

Get Insights from your data

Business Intelligence, Dashboards or Analytics. Whatever you need, Ubiq can help

Try Ubiq for free