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 (10/31/2013 - DLL v6.6.5052) looks at column names ONLY for matching report filters for dashboard filtering purposes.

---

• 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

---

The default behavior in classic Izenda is to look at fully qualified column names:

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 re-enable classic behavior, fully qualified column names for dashboard filtering, in your deployment after upgrading:

AdHocSettings.UseColumnNameForDashboardCommonFilters = false;