Multiple Series for Symbol + Grouped Bar
I am attempting to build a Grouped Bar + Symbol card where there will be three bar series based off of a value in my data. (Closed, Lost, Won), as well as a symbol which would be a calculation based off of those numbers. Right now the card appears to only let me use my one category as a single series as opposed to allowing multiple series (my category and the beastmode calc). It assumes one of my categories as the symbol when I want all three as bars. I could have sworn there was a way to allow for multiple series as I have seen it in other folks examples and Im pretty sure I had done it in the past. Anything I am missing here?
My screenshot is of the card builder taking my month_status field and using two as bars and one as a symbol. I want the end product to have Open/Won/Lost as bars and then a seperate beastmode calc as the symbol.
Comments
-
Hello,
If you want to add multiple series to a chart, the series colum itself must be aggregated in some way (COUNT, AVG, SUM, etc..), otherwise it will not allow for more series to be added. In your case, it looks like to accomplish this you'll need to bucket your data into different beast mode calculations for each of the series options available in that particular series, as it is a text type value.
You could create a beast mode named "Won" with the following:
CASE WHEN `month_status`= 'Won' THEN `month_status` ENDThen, in another beast mode named "Lost":
CASE WHEN `month_status` = 'Lost' THEN `month_status` END
And again for the "Open" bucket.
If you set all of these to a COUNT, you should be able to add all of them to your chart (giving you the same result as with just one column) except now since all of your columns are aggregated, you can add additional series as long as they too are aggregated. Does that make sense? Here's an article on bucketing data, and while the example is a bit diffferent the idea is the same: http://knowledge.domo.com?cid=bucketingEnoc Mendoza
**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"1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive