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:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
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:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 508 Automate
- 114 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive