Forum Discussion

Rubal_Islam's avatar
Rubal_Islam
Helper II
5 years ago

Average Call Time Per Day - Per Employee

Hi ,

 

I am trying to visualise the total time spend(time diff) on calls per day.

Ideally, on the below chart, I would like to see on 2nd August time spend was 7 hours. currently, I am getting 0.29hours.

The formula I am using
Average call time =AVERAGEX(VALUES(Table1[DateOfCall]), [Total Time Diff])
your help is appreciated.
Time Diff vs Time Diff per DayTime Diff

 

Need Help

4 Replies

  • venkrish_09's avatar
    venkrish_09
    New Member
    5 years ago

    Hi Rubal,

     

    I'm a bit confused here.

    If you are looking total time spent in a day, you should use sum instead of average.

    and if you need to find the average time spent, I would like to have a look at the sample data.

     

     

      • venkrish_09's avatar
        venkrish_09
        New Member
        5 years ago

        Hi Rubal_Islam ,

         

        If my assumption is correct the first 3 rows in the data belongs to 3 different calls  on 23/06/2021.

        The current timediff measure written by you gives the average time per call(not day) based on above assumption.

        If you need to calculate total time per day use sum instead of average in the Total timediff measure