How Do I - Show Raw Stats + Calculated Percentages
I uploaded a (very) simple dataset that shows an example of daily raw numbers (example use case is email sends). I can then created two beast mode calculations to determine the click_rate (`total_clicks`/`total_sends`) and complaint_rate (`total_complaints`/`total_sends`).
Ideally I'd like to be able to see all of the data points. The raw stats (`total_sends`, `total_clicks`, `total_complaints`) as a bar chart (possibly with MoM), [see raw_stats.png]. However the thing I'm not able to do is show multiple rate/percentage lines [see rates.png].
Note: the goal here is to be able to see how our raw numbers are progressing over time (spot any dips/spikes) but also be able to correlate/see any dips/spikes in our corresponding rates.
I can obviously generate each of these separately. Is there any mechanism to "overlay" two graphs on top of each other as that would (more or less) also solve my use case here as well.
Best Answer
-
Hi JSuggs-
You can accomplish this with a Line + Grouped Bar card.
Under the General Chart Properties tab, you will want to specify 2 series on the Left Scale:
You will then want to graph `date` on the x axis, and your two beastmodes as the next two fields (Click Rate and Complaint Rate) One note here is that you will need to select an aggregate function for the second beastmode. Since each row of data represents one day and we are graphing by day, this won't effect your data. I chose MAX. Then you will place your other fields: SUM total_sends, SUM total_clicks, SUM total_complaints.
However, because the rates are so different, I would suggest making a separate visualization for Click rate and Complaint rate:
1
Answers
-
Hi JSuggs-
You can accomplish this with a Line + Grouped Bar card.
Under the General Chart Properties tab, you will want to specify 2 series on the Left Scale:
You will then want to graph `date` on the x axis, and your two beastmodes as the next two fields (Click Rate and Complaint Rate) One note here is that you will need to select an aggregate function for the second beastmode. Since each row of data represents one day and we are graphing by day, this won't effect your data. I chose MAX. Then you will place your other fields: SUM total_sends, SUM total_clicks, SUM total_complaints.
However, because the rates are so different, I would suggest making a separate visualization for Click rate and Complaint rate:
1
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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive