In KPI chart I need to SUM a field, but only if there is chosen 1 day.
And if chosen more then 1 day, write 'Chose only 1 day'.
I have 3 filters with the same date field: Year(DATE), Month(DATE), DATE.
So is there any way to make my KPI chart check, if there is chosen 1 day - show the SUM, else write 'Chose only 1 day'?
Hi, in the KPI properties -> add-ons sections, you can add a calculation condition like Count(Distinct DATE)=1, when you add the condition a text box is shown allowing you to set the message.
View solution in original post
maybe you could also check for