1 2 Previous Next 17 Replies Latest reply on Apr 14, 2016 11:47 PM by Sharad Adhikari

    Create a calculated dimension

    Suraj Tripathi

      Hi All,

      I have a data set like this.

       

      ConsultantPerformance DaysSales
      645Pre 90$ 500
      645

      Pre 60

      $ 450
      645Pre 30$ 500
      645Training days$ 400
      645Post 30$ 600
      645Post 60$ 650
      645Post 90$ 900

       

      I want to calculate average sales of pre 90, pre 60 and pre 30 days.

      Also I want to create a bar chart to show the performance of consultants after training days.

      The chart I am able to create is something like this.

      Before Avg..png

       

      But i want the first bar is to be average of Pre 90, pre 60 and Pre 30 days sales

      My requirement is something like this.

       

      After Avg..png

      Pre training average sales= ($500 + $450 + $500)/3

       

      Any help would be much appreciated.

        1 2 Previous Next