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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive