Bar + line/symbol graphs should have an easier option for average by group


I think one of the main use cases for adding a line or symbol to a bar graph, especially a grouped bar graph, is to plot the average on top. I know how to do this by using an ETL to calculate the averages and append them as rows to the data, but this creates a less dynamic and flexible dataset for cross-filtering with other cards. Requiring that also seems at odds with what I interpret as Domo's design principle of prioritizing ease of use over customizability.
I imagine this could work the same as the "Nested Bar" card, except instead of totals, you plot averages, and instead of a big gray bar, you plot a line or symbol. Ideally you get to pick the symbol/line, and even better would be to be able to pick the summary metric (average, median, total, count, standard error, etc.)
Or maybe it could work in existing bar+symbol/line graphs, but you add options for metrics that are split into a series and metrics that are not split into a series.
One of the symbol types should be a horizontal line through the group so we can do something like this:
I don't think anything like the above is currently possible. The next two examples you could do in Domo, but it would be nice if it didn't require an ETL:
Edit: watching the Demo Slam from Grant Smith, I realized you could also do these last two by creating a beastmode per group and the aggregation using a window function. That would be better than an ETL since I think it would cross-filter with other cards better and wouldn't change the data. There would still be downsides if your series is more dynamic/changing. You'd have gaps like missing teeth if you filtered out certain groups.
Please ๐ก/๐/๐/๐ this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 667 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 146 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive