4 Replies Latest reply on Jun 28, 2017 10:54 AM by Matt Lutton

    Breaking profit down based on days between to dates


      Hey All,


      Looking for best method to look at a KPI performance based on the number of days between two dates.   Would like to have the user to be able to pick the days between the two dates and then show KPI performance based on all cases under that number and all cases above that number.


      I've included a workbook example to build off.   In this, lets use average profit and Profit Ratio as the KPIs.   We're trying to determine profit and profit ratio if the number of days between order date and ship date are equal to or less than the number in the filter and profit for those that have a number greater than the number input.  Also would like to see the number of records in each population.