I have a daily KPI which is quite often not returning data, as in we don’t collect data for that area every day. This means that some days the KPI will return ‘No Data’. How can i replace this ‘No Data’ so that it just states ‘0’
I’ve tried setting null values to 0, but since this isn’t technically a null data value it doesn’t affect the output
Hi @HarveyB-B - Unfortunately you can’t change this. Hi @DylanM - I remembered you have some workaround solution, can you please share it.
Regards - Sanjeeb
Ok, i think a workaround is to check if the data is there in a calculated field, and if there is, return it. If there isn’t, return 0?
Although ‘No data’ is not considered as null
Therefore the above still returns ‘No data’
I will wait to see what workaround @DylanM has
Hi @HarveyB-B ,
Workaround here is to add a dummy record in data prep layer (ahead of data getting to QuickSight) with 0 measure value
and to ensure that this dummy record makes it through all filtering (by adding an OR clause; say, against a row id value)
We have a Product Feature Request in our queue for allowing customization of the ‘No data’ message. Please have your AWS account manager / account SA file a customer influence on your behalf on this PFR - Internal link
Regards,
Arun Santhosh
Pr QuickSight SA