Platform Analytics Pivot Filter

[Satya Harika]

Hi everyone,

We are seeing an issue with Platform Analytics pivot table visualizations.

Our pivot table contains a combination of:

• Formula Indicators
• Table-based visualizations

We have applied a dashboard date range filter (for example, Resolved Date), but the pivot table does not appear to respect the selected date range. Other visualizations on the dashboard respond correctly to the filter.

Is this expected behavior?

[Vikram Reddy · Accepted solution]

Hi @Satya Harika,

Check whether your pivot table is actually mixing two different data source types, because that's almost certainly what's breaking the filter. ServiceNow has confirmed that mixing table-based data and indicator-based data in the same visualization isn't supported, and a single dashboard filter won't apply consistently across both when they're combined. The Resolved Date filter gets mapped per data source, and Formula Indicators in particular don't carry filter context the same way a live table query does, since an indicator is a pre-aggregated score, not a row-level record. So the table-based half of your pivot reacts to the date range while the formula indicator half just ignores it, or the totals quietly stop lining up.

There isn't a config fix for this, only workarounds. Either rebuild the pivot on one consistent source, all indicators or straight table data, or split it into two separate visualizations so each one carries its own filter mapping cleanly. If you go the all-indicator route, also check the relative date condition on the indicator itself (something like Resolved relative before X days), because that logic behaves differently on indicators than it does on table filters, and it trips people up right after they think they've fixed the first issue.

Thank you,
Vikram Karety
Octigo Solutions INC

[Satya Harika]

Thank you @Vikram Reddy  , this is helpful.