replicating Google Analytics’ Time Format in DOMO
I want to show Time on Site (and ither metrics that report in minutes and seconds) the way Google Analytics does, but it shows up in DOMO as number of seconds.
Is there a solution at the connector level and is there a solution at the beastmode level (something I could do on the fly for reports do yesterday)?
Thanks all,
Best Answer
-
If you want to display the time on site data as minutes-colon-seconds (e.g. 2:30, instead of 150) you could use a beast mode like this:
CONCAT(FLOOR(`Time_On_Site_Field` / 60), ':' , MOD(`Time_On_Site_Field`, 60))
Note, however, that this will turn the output into text for display and you will no longer be able to do math on it.
If you need to use this in a sum, you can also add that to the beast mode like this:
CONCAT(FLOOR(SUM(`Time_On_Site_Field`) / 60), ':' , MOD(SUM(`Time_On_Site_Field`), 60))
The floor function is used to round down the division of the time on site divided by 60 to get hours. The MOD function returns only the remainder after the division of the time on site divided by 60 to get minutes.
I hope that helps!
3
Answers
-
If you want to display the time on site data as minutes-colon-seconds (e.g. 2:30, instead of 150) you could use a beast mode like this:
CONCAT(FLOOR(`Time_On_Site_Field` / 60), ':' , MOD(`Time_On_Site_Field`, 60))
Note, however, that this will turn the output into text for display and you will no longer be able to do math on it.
If you need to use this in a sum, you can also add that to the beast mode like this:
CONCAT(FLOOR(SUM(`Time_On_Site_Field`) / 60), ':' , MOD(SUM(`Time_On_Site_Field`), 60))
The floor function is used to round down the division of the time on site divided by 60 to get hours. The MOD function returns only the remainder after the division of the time on site divided by 60 to get minutes.
I hope that helps!
3 -
Hey
Thanks! This is very helpful.
But after the calculation, the metric becomes a dimension.
How can I show the avg session time by month in a card?
Many thanks!
0 -
There isn't a way to graph this data as a metric after converting it to minutes-colon-seconds format. If you want to graph the average session time by month, you'd need to pick a single unit of time (seconds, minutes, or hours) as your metric and convert the data to that unit (seconds\60 = minutes). Then you're graphing average session time in minutes per month.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive