Adding an average bar to chart
![user060355](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
I have the following chart and I'd like to add a dynamic average bar that would change for each value on the x-axis. In other words, this "average" would be plotted for each month and should change with each month such that it represents the average of all values for that given month. The result should not be constant across all months.
Is this doable?
Best Answer
-
Append the dataset onto itself and replace the 'country' with 'Average'.
Write a beast mode,
case when country = 'average' then avg(amount) else sum(amount) end
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
Append the dataset onto itself and replace the 'country' with 'Average'.
Write a beast mode,
case when country = 'average' then avg(amount) else sum(amount) end
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
What do you mean by "append the dataset onto itself"?
0 -
@jaeW_at_Onyx is suggesting you take your data, replace the country column with the 'average' value, then append that back to the original dataset.
It'll look something like this:
Then you can utilize his beast mode to plot the average instead of the sum for the average amount.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
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
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 691 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
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive