5 Replies Latest reply on Apr 17, 2017 10:56 AM by Jim Dehner

    Amount per day using dynamic start and end date

    Alexis White

      Please see the workbook attached.


      I have a start date and an end date along with the total amount for the duration. I would like to add filters to the dashboard allowing me to filter the range but still see all the companies within that duration. For example, company ABC has an amount of $200K with a start date of 1/3/2017 and an end date of 1/7/2017. If I filter the start date for the entire dashboard to 1/4/2017, I want the graph and table to adjust to continue to display ABC with the amount of $150K