Help With Beast Mode Calculation
I have a dataset that has the following Fields
Agent Name - Name of the agent
Agent Status= This is the state the agent was changed to . Available, Unavailable, Idle etc.
EventTime = Equals the timestamp that the agent status changed to
I need to calculate the time the agent was in that state, for example, Agent changed state to "unavailable" at 1:00 PM and then "Available" at 2:00 PM. So I should get back 1 hr as the unavailable time.
What I am struggling with is the eventtime field is all I have so I would need to subtract the time in between unavailable and available.
- 10.7K All Categories
- 13 Getting Started in the Community
- 40 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board