3 Replies Latest reply on Nov 28, 2016 11:12 PM by K V

    calculations for Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg in single Axis

    K V

      The sample data attached here.

       

      I would like to develop dashboard for the below calculations for  Last completed Month(Oct),SEP,AUG,JULY,JUN,MAY, LAST 3 Months Avg, LAST 6 Months Avg.

       

      Calclations:

       

      Total count Against column D:

      Total Handled time against column D

       

       

      I also few of the other measures around (six) are avaialble, I will create those calculations. But I want show in a good visualizations for those dynamic time periods with couple of measures.

       

       

      Please help me on this.

       

       

      Thanks & Regards

      KV