Count dates and sum

[AlexWest]

Hi, guys!

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'?

[rubenmarin · Accepted solution]

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.

[MarcoWedel]

maybe you could also check for

GetSelectedCount(DATE)=1