Average Session Duration Y/Y

jboniface · 2024-02-28T21:08:16+00:00

There was an error rendering this rich post.

jboniface

I am importing GA4 data and trying to display Y/Y in a multivalue on a dashboard. I used

SEC_TO_TIME(Avg. Session Duration)

to change the data to time format, but it's still not showing appropriately. Any ideas?

Find more posts tagged with

Cards

Dashboard

Card Builder

Beast Mode

Accepted answers

ArborRose

SEC_TO_TIME should be converting duration in seconds to a time format. It looks like the value is for the average session duration displayed with K, indicating thousands. As in average session duration of 170.85 seconds. The "0" indicates no change from the average in the current month to the same month last year.

Your data may be aggregated to a different level before calculating…such as monthly. Also check the data type.

All comments

ArborRose