This content has been marked as final. Show 2 replies
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