Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I have an issue with the dates. I have two date fields 'Creation_Date' and 'Cancelled_Date'
I want to filter data by Year/Quarter/Months/Days using ONLY ONE FILTER.
I need two KPIs
1. Number of items created Expression: Count (Id)
2. Number of items cancelled Expression: Count(Id) where CancelStatus='Cancel'
How is this possible.
Sample data is attached
Check here
Hi Sunny
After lots of effort, I successfully implemented the concept of canonical date.
Thank You