Average for Multi Line Line Graph
Best Answer

I'm assuming you have a series selected. You could probably create a BeastMode for each of the series members and then create one that contains the average. I think it would look something like this:
Brand A
SUM(CASE WHEN `Dimension` = 'Brand A' THEN `Metric Total` ELSE 0 END)
Brand B
SUM(CASE WHEN `Dimension` = 'Brand B' THEN `Metric Total` ELSE 0 END)
Avg of All Brands
AVG(`Metric Total)
Let me know if this makes sense.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers

I'm assuming you have a series selected. You could probably create a BeastMode for each of the series members and then create one that contains the average. I think it would look something like this:
Brand A
SUM(CASE WHEN `Dimension` = 'Brand A' THEN `Metric Total` ELSE 0 END)
Brand B
SUM(CASE WHEN `Dimension` = 'Brand B' THEN `Metric Total` ELSE 0 END)
Avg of All Brands
AVG(`Metric Total)
Let me know if this makes sense.
KurtF
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 
Was able to get it to work by doing the following.
Build beast mode calculation per each line using case
Example
CASE
When `Event` LIKE '%In' then 1 else 0 endCreated Beast mode to do the difference between in, out to get a net.
Switched from Multiline to single line and added each beast mode to the series section so could display in, out and net on the same graph.
Thanks Kurt!
0
Categories
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 288 Workbench
 4 Cloud Amplifier
 7 Federated
 2.8K Transform
 94 SQL DataFlows
 591 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 663 Beast Mode
 39 App Studio
 34 Variables
 641 Automate
 163 Apps
 433 APIs & Domo Developer
 42 Workflows
 3 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 378 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 5 Software Integrations
 108 Manage
 105 Governance & Security
 8 Domo University
 23 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 95 Community Announcements
 4.8K Archive