Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I'm displaying the following KPIs
- sales of today
-sales of this week
and a few other things.
However, if I select a specific date of this week (through a filter) it shows me in the KPI 'sales of this week' also only the sales of this one selected day. How can I fix, that the KPI always shows 'sales of this week', no matter what date I choose?
Thank you very much 🙂
try use expression
IF(count(date)>1 then 'Sales of Week','sales of Day')& sum(sales)