Forum Discussion

usmanrafiq's avatar
usmanrafiq
Helper I
6 years ago
Solved

Concatenate Measure and String

Hello,  I want to create a measure that calculates avg session duration and attach "min" or "sec" word with it based on following condition   Avg. Session Duration = if(AVERAGE(driviology2[ga:avg...
Need Help
  • rajatanand's avatar
    rajatanand
    6 years ago

    Avg. Session Duration = if(AVERAGE(driviology2[ga:avgSessionDuration])/60 >= 1 , AVERAGE(driviology2[ga:avgSessionDuration])/60 & " mins" ,SUM(driviology2[ga:avgSessionDuration]) & " secs")

rajatanand's avatar
rajatanand
Regular Visitor
6 years ago

Avg. Session Duration = if(AVERAGE(driviology2[ga:avgSessionDuration])/60 >= 1 , AVERAGE(driviology2[ga:avgSessionDuration])/60 & " mins" ,SUM(driviology2[ga:avgSessionDuration]) & " secs")