1 Reply Latest reply on Jan 10, 2019 11:22 PM by Amar Wattamwar

    Getting Average Change in the last 6 months

    Wong  Tze Xiang

      Hi guys.

       

      I was wondering if anybody has a way to get the average change of the last 6 months.

      Using this as an example, i need to be able to get the average change for 6 months before each point. So for the month of july i need the average change from jan - june. Then i need to be able to change the colour of the points which increase/decrease more than the average change of the 6 months prior to that point.