How do I setup Data Filtering in an IntelliFront BI Dashboard?

This article will help you set setup data filtering in an IntelliFront BI Dashboard Visual.

Dashboard - Data/Filtering

  • You have the option to apply filtering to dashboard visuals, filter SQL queries or the entire data sources.
  • To filter Dashboard visual go to Data/Filtering in the Binding Menu.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • Select Click to set Filter Criteria.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.

Filter Editor

KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • In Filter Editor setup the conditions for your dashboard visual.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • You can click on the And to change the logical operator.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • Next to the And, click on the (+) button to add a group or condition.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • If you add a condition, you can select the values added in the binding menu.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • You can set the comparison.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • Set the type of conditions.
  • Value: You can compare the dimension and static values.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • Property: You can compare with different values added to the dashboard visual.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • Parameter: You can compare it with the Dashboard Parameter values.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.

Advanced Mode

KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.
  • The Advanced Mode allows you to custom the filter editor using SQL queries.
  • Once you finish, click OK to save.
KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.

 

KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.