Group bar and line chart
Hi,
I want to build a card with the following scenario:
- The grouped bar shows the device type and the metric is 'traffic'
- The line chart shows the 'bounce rate'
I tried to build the card on domo but it doesn't work out. Please find the screenshot below:
Thanks in advance for the help
Comments
-
You are almost there! We will need to do two more tasks:
1) You currently have a "Device" series. You will want to build a beastmode that includes the Bounce Rate with the devices. To be clear, your new series will now show "Bounce Rate, Desktop, Mobile, Tablet, etc." Rename the series accordingly. This will be the new field that you place in the Series field in the card builder.
The Grouped Bar with Line chart type will always show the line value of the first item listed in the series. To ensure that your Bounce Rate value is always represented by the line, you'll want to build a second Beast Mode to order your new series.
2) The series order Beast Mode will look somethign like this:
CASE
WHEN `Beast Mode from task 1` = 'Bounce Rate'
THEN 1
ELSE 2 /* Unless you would like the other Series elements to be ordered as well*/
END
This series order beast mode will be placed in the Sorting field; ordered Ascending to ensure that your "Bounce Rate"
always at the top (i.e. represented with by the line).
Here is a link to a cardbuilding FAQ that may be of assistance in the future: https://dojo.domo.com/t5/Card-Building/Card-Building-Frequently-Asked-Questions/m-p/12096#U12096
Domosapien
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Could you also show how to achieve task 1 because I do not know how to merge a dimension(device) and a metric(bounce rate).
Thanks ?
Angel
0 -
You are right! Good call.
Actually, you will want to create individual beast modes for each device and drag them all into the series fields. In the end you'll have a handfull of beast modes:
1) Bounce Rate. You'll place this in the Y axis field
2) Desktop Traffic: "CASE WHEN `Device` = 'Desktop' THEN `Traffic` END". Place this in the Series and SUM the field.
3) Tablet Traffic: "CASE WHEN `Device` = 'Tablet' THEN `Traffic` END". Place this in the Series and SUM the field.
4) Mobile Traffic: "CASE WHEN `Device` = 'Mobile' THEN `Traffic` END". Place this in the Series and SUM the field.
With this strategy the task 2 beastmode from the prior response will not be necessary because you will be manually ordering the new series.
Let me know how this works!
Domosapien
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
@angelsinha, tagging you to check out marcam's latest reply.
0
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