2 Replies Latest reply: Jun 27, 2018 3:23 PM by Shahzad Ahsan RSS

    How to manage two dates in single dashboard

    Shahzad Ahsan

      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