Working with time values/measures
Options
I was informed by Domo support that there is no accomodation for seconds-to-time in magic ETL. Doing this transformation in Beast Mode makes the time value a dimension, which I would not be able to perform calculations on. Is there any way around this? I am trying to make cards for call center metrics like average speed of answer, average hold times based on detail data, etc. All of the time values come from the database as seconds and I need to show them as time with trends and drilldowns. Any thoughts are appreciated.
0
Comments
-
I dont completely understand your problem but there is a way to work in seconds in Magic ETL.
Convert your DATETIME columns to decimal, the this converts time so 0 is 1/1/1970 and each unit equals 1 milisecond
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive