1 Reply Latest reply on Apr 8, 2018 12:14 PM by Santiago Sanchez

    Problem on Dual Chart and visualization

    Amit Dasgupta

      Hi,

       

      I have attached packaged workbook for your reference.

       

      I have created a Bar chart showing the number of records for each day selected via Parameters (Start_date, End_date)

       

      I have difficulty in creating another Line chart which should calculate the average of "E2E overall" for each day selected via Parameters (Start_date, End_Date).

       

      The average should be calculated for graph selected i.e 27-Feb to 26-Mar... For example, on 27-Feb, we can see 82 records.  Therefore, it should calculate the average of 82 records of "E2E overall" i.e 4.616.  Similarly for others dates in the range.

       

      Thanks

      Amit