amico
March 19, 2025, 4:11pm
1
Hi,
I have a visual filtered by several filters.
In a certain combination of filter values, I get ‘No data’ result in my visual.
I want that in this situation it will return 0.
How can I set it without changing dataset structure?
Thank you,
Amihai
1 Like
duncan
March 20, 2025, 2:44pm
2
Hello @amico
I would check out this post:
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.
1 Like
amico
March 20, 2025, 3:59pm
3
Thank you, this will certainly assist.
1 Like