Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
A random issue that I can't believe I haven't hit before now...! I have a bar chart where I'm showing the count of a simple value by a category. On the bar chart, I want to add a value as 'text as pop-up' with the count of how many products. So the calculation at the moment is simply 'count([Complaint Id])'.
To add a bit of detail to this, I want to add some text, so my expression looks like: 'Complaints: '&count([Complaint Id])
However, by adding the text, it's now showing values in the legend for categories that weren't applicable before (no records) - see attached.
Any ideas? Help is always appreciated!!
Kind Regards,
Dayna
Try to suppress null values. If that doesn't work, I usually follow the below:
'Complaints: '&Num((count([Complaint Id]) + 0.001), '0.00') and then suppress zero values.
Hope this helps.