Display No data available when the score of data source is 0 using pivot table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2025 02:24 AM
On Platform Analytics, I created a dashboard using a pivot table that takes three indicators as data sources — one is a formula indicator and the other two are auto indicators. When one of the auto indicators(indicator2) has all of its scores as zero(or has no value), even though the other indicators have non-zero scores, the entire dashboard displays "No data available" instead of showing the available data for each indicator separately. Why does this happen, and how can I configure it to display all the data collected for each indicator?
breakdown | indicator1 | indicator2 | indicator3 |
test1 | 1 | 0 | 1 |
test2 | 1 | 0 | 1 |
test3 | 1 | 0 | 1 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2025 04:11 AM
Reports check to see if there is data available or not. If you use 3 data sources and one gives back that it doesn't, the report sets that as 'no data'. Since it is one report, it simply shows 'no data'.
You can create 3 pivots, so you at least have the other two with data.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark