Forum Discussion

SRK_23's avatar
SRK_23
Helper I
7 years ago
Solved

Calculate Average time

Hi, how to calculate average time by "PlaformEntityName" ?    I've got 3 calculated column which are:     Duration_Max = CALCULATE( MAX(dm_pageview_company[Date]) , F...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi SRK_23

    I'm uploading back your file here with the measure i posted earlier included.

  • AlB's avatar
    AlB
    7 years ago

    Hi SRK_23

    Yeah, it's correct. That's the same. I said earlier that the measure shows the result in minutes

    2,37 minutes is 2 mins and 22 seconds, 2:22

AlB's avatar
AlB
Community Champion
7 years ago

Hi SRK_23

I'm uploading back your file here with the measure i posted earlier included.

SRK_23's avatar
SRK_23
Helper I
7 years ago

Hi AlB , I did your calculation here and the average seems wrong, or maybe I don't understand something. In the example attached, we have a session length at 2 minutes 22 secondes, and the average on the session is 2.37 in your calculation; the average should be 2:22 as well (as we focuse on only one session). Do you know what I mean ?

(File attached)

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi SRK_23

    Yeah, it's correct. That's the same. I said earlier that the measure shows the result in minutes

    2,37 minutes is 2 mins and 22 seconds, 2:22

    • AlB's avatar
      AlB
      Community Champion
      7 years ago

      Hi SRK_23

      If you wanted the result in the format Mins:secs instead, you could do something like:

       

      AverageSessionTime_Mins_Secs = 
VAR __AverageSessionTime= 
AVERAGEX (
    VALUES ( dm_pageview_company[Duration_Calc] );
    dm_pageview_company[Duration_Calc]
)
RETURN
MINUTE(__AverageSessionTime) & ":" & SECOND(__AverageSessionTime)
      • SRK_23's avatar
        SRK_23
        Helper I
        7 years ago

        Thank you !