Migrated Visualizations not following filter conditions (not int filtering) until refreshed

[Daniel211]

Hi All-

We recently migrated to Platform Analytics and some visualizations are not applying their defined filter conditions until you refresh the widget on the dashboard. I've see other posts about this issue specifically tied to not honoring interactive filters, but this isn't the same. It's like the reports aren't recognizing there are any filter conditions at all on the report.

When the dashboard loads, it shows all records as if there's no filter applied. Once you refresh, it applies the filter conditions that are set on the visualization itself. Has this happened to anyone else? Anyone else figure out how to fix this?

[Vikram Reddy]

Hello @Daniel211,

Nine times out of ten this is the dashboard's data cache, not the visualization itself. On initial load the widget is served its last cached result set (which can be the full, unfiltered dataset if it was cached before the filter condition was set or migrated), and the manual refresh forces a live query that actually runs the filter condition. That matches what you're describing better than the interactive-filter bugs, since your filter conditions are static, not user-driven.

1. Open the dashboard properties and check whether data caching / scheduled refresh is enabled. Temporarily disable it and reload the dashboard cold to see if the widgets come up filtered correctly the first time.
2. Open each affected visualization in the Data Visualization designer and re-check the Filter Condition field. Migration Center has a documented history of not carrying source report filters over cleanly, sometimes the condition looks present but doesn't actually persist until you re-save the visualization.
3. If the dashboard sits idle before anyone opens it, check the "Refresh after being away for X minutes" setting, there's a known issue (KB2176271) where that setting doesn't force a fresh query on return.
4. Check the browser console on initial load for any errors, some of these turn out to be a timing issue where the widget queries before the dashboard's filter context is fully initialized.

Are these indicator-based or ad hoc table visualizations, and is caching turned on at the dashboard level? That'll narrow it down fast.

Thank you,
Vikram Karety
Octigo Solutions INC

[Tanushree Maiti]

Hi @Daniel211 

Refer:

KB0817983 Interactive filter is not working as expected 

Issues when migrating dashboards from PA to Platform Analytics 

Interactive filter won't retain the value when refreshing or reloading the Dashboard