Displaying Average of Data with Average of Each Part of the Series
Hello!
I have two call types. Let's call them Inbound 1 and Inbound 2. I have a graph that doesn't distinguish between the two but averages both of their Handle Times into one line. I have another graph which displays their average Handle Times split into two lines, Inbound 1 and Inbound 2.
I am looking for a way to see all 3 lines (AHT for Combined, AHT for Inbound 1, and AHT for Inbound 2) on the same graph.
Is this possible?
Best Answer
-
You can use three different beast modes to handle this:
Combined:
AVG(`Handle Time`)
Inbound 1:
AVG(CASE WHEN `Call Type` = 'Inbound 1' THEN `Handle Time` END)
Inbound 2:
AVG(CASE WHEN `Call Type` = 'Inbound 2' THEN `Handle Time` END)
You can then graph all of those on the same chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
@thwartted Can you please post an example of how your data is structured?
0 -
-
You can use three different beast modes to handle this:
Combined:
AVG(`Handle Time`)
Inbound 1:
AVG(CASE WHEN `Call Type` = 'Inbound 1' THEN `Handle Time` END)
Inbound 2:
AVG(CASE WHEN `Call Type` = 'Inbound 2' THEN `Handle Time` END)
You can then graph all of those on the same chart.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@GrantSmith thank you! I kept trying to use the X, Y and Series boxes to make that work. I didn't even think to use beastmodes.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive