Average Session Duration Y/Y
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?
Best Answer
-
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.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
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.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive