2 Replies Latest reply on May 17, 2016 2:26 PM by Sid Singh

    Compare Period (Month, Quarter, Year, or selected date range) to prior year as a conditional KPI.



      I've been working on this for longer than I'd like to admit and every approach never seems to pan out.


      Concept is fairly simple: I need to compare a specified time period,  such as "month" (5/13/2016 - 4/13/2016) against the same period last year (5/13/2015 - 4/13/2015). Then throw in a parameter to select period (month, quarter, year).


      Additionally, I need to display the Current Period SUM, Last Period SUM, Difference, and % Difference as a conditional KPI. My issue is the dates I'm trying to capture aren't starting or ending as I'm specifying in my calculations. Any help would be greatly appreciated.