Default value for No data retieval

[duncan]

Hello @amico

I would check out this post:

Replace 'No Data' with '0'

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’ [image] I’ve tried setting null values to 0, but since this isn’t technically a null data value it doesn’t affect the output [image]

It does require some development work. This is also a feature that the QuickSight team has received feature requests for.