Display No data available when the score of data source is 0 using pivot table

zhuc
Tera Contributor

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?

breakdownindicator1indicator2indicator3
test1101
test2101
test3101
1 REPLY 1

Mark Manders
Mega Patron

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