filtering-in-dashboards

#How Does Filtering In Dashboards Work?

To apply filters in a dashboard, all reports included in the dashboard must contain the same filter.

New default behavior for Izenda dashboard filtering looks at 'fully qualified' column names for matching report filters for dashboard filtering purposes by default.

---

• I create Report A:

  Employee Table:

  Last Name

  Country

  Filter 1 : Country

  Filter 2 : Last Name

• I create Report B:

  Supplier Table:

  Supplier Name

  Country

  Filter 1 : Country

  Filter 2 : Supplier Name

• I create a dashboard from these two reports:

  Dashboard contains Filter : Country

---

AdHocSettings.UseColumnNameForDashboardCommonFilters = True;

   - Fully Qualified Name (EXample: View.ColumnName)

AdHocSettings.UseColumnNameForDashboardCommonFilters = False;

   - Use 'ColumnName' Only --------

The default behavior in classic (Pre v6.6) Izenda is to look at fully qualified column names. During v6.7 the default was to use ColumnName only. The current default value is AdHocSettings.UseColumnNameForDashboardCommonFilters = True;

dbo.suppliers.country IS NOT dbo.employees.country - though they may have many of the same values or the exact same- thus filters do not show up in dashboards at all for the above situation.

To enable datasource-specific behavior, fully qualified column names for dashboard filtering, in your deployment after upgrading:

AdHocSettings.UseColumnNameForDashboardCommonFilters = true;