1 Reply Latest reply on Oct 27, 2018 10:55 PM by Ombir Rathee

    Average of two month

    Sujeet kumar

      This is the sample data. What I want to calculate the average collection per vehicle for June and July together.

      And want to compare it with August month in the same graph.

      This could then be averaged across another dimension (eg. venue then car type then model) when dragged into the view.

       

      So, what is the formula?

      Screen Shot 2018-10-23 at 2.43.29 PM.png