Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to calculate average time?

Hi,

 

How to do "total time" / "total users" = average time? My goal here is to get an average time per user. 

 

The Time I have is in decimal form. I created a measure and turn them into "hour" : "min".

 

Measure I have: Time = FORMAT(AVERAGE('xxx'[Time on page]),"nn:ss")

 

Then, I tried to use the measure to divide users. It won't allow me to do that.

 

Then I tried to use the decimal numbers to divide users, it returned 0.

Avg time = DIVIDE (SUM('xxx'[Time on Page]), SUM('xxx'[Users]),0)

 

 

Please help!

 

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Greg_Deckler  I am not sure how the article going to solve my issue here. Can you please tell me how can I get the average "mm:ss" instead of 0? Thanks!

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        Anonymous You can't divide using the measure because it is text. So, if you use Chelsie Eiden's Duration and keep the number as a number (don't use FORMAT) then you could use the measure.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Not very clear about your expected output... But if you want to display the same average value on each row,please try:

    Measure = CALCULATE( AVERAGE('Table'[Time on Page]),ALLSELECTED('Table'))

     

    Or please provide more details to help us clarify your scenario.

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.Hope to hear from you‌‌😀

     

    Best Regards,
    Eyelyn Qin