Group bar and line chart
Can I assign each series to bars and lines as I want or will the program automatically decide? Let me know how to get this done.
I understand that I can decide how many line charts I want to see on the grouped bar chart but that doesn't seem to resolve the issue I am experiencing.
Thanks for any help with this!
Best Answer
-
Ugh! thats a good question,
I think it can be tackled 2 different ways.
1) Use the sorting box when building your chart. follow this example below
If it does not work then
2) create 3 beastmodes :
a) actuals = sum(case when 'Column ABF' = Actuals Then 'Column with values' End)
it could be count , average or any aggregation you need
b) Budget = same formula but when 'Column ABF' = Budget
c) Forecast = same as above but when it equals Forecast
That will create 3 diferent series that you can bring into the chart in the order you prefer.
Give it a try and let me know if that works for you
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Answers
-
Yes you can, in order for it to work go to the "chart properties", Then under "General" you can specify the number of lines you want to see. Just make sure to position the series containing the values in first.
Take a look at the image below , it shows exactly what I mean
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Thanks for the answer!
Let me ask you this one, if I have only one column of data, and the data is categorized by another column, then how do I assign the categories to series? For example my data is in column B and I captured there forecast, budget and actuals. When comes to visualizing, how can I tell the group bar and line chart that the forecast needs to be on a line chart, while all others on a bar chart?
Thanks again!
0 -
Ugh! thats a good question,
I think it can be tackled 2 different ways.
1) Use the sorting box when building your chart. follow this example below
If it does not work then
2) create 3 beastmodes :
a) actuals = sum(case when 'Column ABF' = Actuals Then 'Column with values' End)
it could be count , average or any aggregation you need
b) Budget = same formula but when 'Column ABF' = Budget
c) Forecast = same as above but when it equals Forecast
That will create 3 diferent series that you can bring into the chart in the order you prefer.
Give it a try and let me know if that works for you
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive