3 Replies Latest reply on Jun 11, 2018 8:03 AM by Zhouyi Zhang

    Calculate Delta % from previous time period per customer

    Miquell Kleuters

      Hi all,

       

      As i am trying to create a view which show the difference % from previous time period for customers i got kinda stuck.

       

      Table calculation works is only relatable to the previous data in a chart and does not refer back to the customer's specific data from last time period.

       

      It might work by using a calculation of this month and a calculation from last month where you specify the customer in the calculated field.

       

      As my knowledge is not going that far I am asking you for help.

       

      To illustrate you can use my template which is attached to this discussion.

       

      The ideal outcome would be:

       

      Customer on X axis

      Delta % as value without having to show current and last months data.

       

      Thank you,

       

      Miquell