comapare current-3 days in period over period chart
I have a use case where the data gets updated everyday, however the complate data will be available only for current-3 days. How can I display a period over period chart to compare current-3 to current-4 days?
Best Answers
-
You can use a Multi-Value Columns chart with two beast modes, one for -3 days and one for -4 days and use the last 4 days in your date range selection. You can use the -3 days beast mode as your gauge value and -4 days as your comparison value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@chetan_cricut here is what @GrantSmith is suggesting.
From the list of charts, choose Gauges and select Multi-value Columns chart.
In the date range select Previous and Last 4 Days
Create a beast mode called "Last 3 Days" that looks like this:
CASE when
date
>= DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY) THENconfirmed_total
ENDYou will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total
Create another beast mode called "Last 4 Days" that looks like this:
CASE when
date
>= DATE_SUB(CURRENT_DATE(), INTERVAL 4 DAY) THENconfirmed_total
ENDYou will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total
Drag the Last 3 Days field in the Gauge Value field and choose an aggregation type of Sum.
Drag the Last 4 Days field in the Comparison Value field and choose an aggregation type of Sum.
You can then use the Chart Properties to change the look and what values you want displayed.
Hope this helps
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
You can use a Multi-Value Columns chart with two beast modes, one for -3 days and one for -4 days and use the last 4 days in your date range selection. You can use the -3 days beast mode as your gauge value and -4 days as your comparison value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
GrantSmith How can you drag two beast mode for current -3 and current-4? Also, I did not understand which chart type you were referring to. Can you pls share a snippet?
0 -
@chetan_cricut here is what @GrantSmith is suggesting.
From the list of charts, choose Gauges and select Multi-value Columns chart.
In the date range select Previous and Last 4 Days
Create a beast mode called "Last 3 Days" that looks like this:
CASE when
date
>= DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY) THENconfirmed_total
ENDYou will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total
Create another beast mode called "Last 4 Days" that looks like this:
CASE when
date
>= DATE_SUB(CURRENT_DATE(), INTERVAL 4 DAY) THENconfirmed_total
ENDYou will need to swap out the date field and the confirmed_total field with the date field in your dataset and the value field that you want to total
Drag the Last 3 Days field in the Gauge Value field and choose an aggregation type of Sum.
Drag the Last 4 Days field in the Comparison Value field and choose an aggregation type of Sum.
You can then use the Chart Properties to change the look and what values you want displayed.
Hope this helps
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
@MarkSnodgrass Thanks for explainig. Somehow I am not getting the required result. Unable to see the change
0 -
@chetan_cricut make sure you are choosing an aggregation of SUM on both the gauge value and comparison value
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@MarkSnodgrass sorry for the delayed resonse, however this doesnt seem to be working.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 301 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 103 SQL DataFlows
- 629 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 759 Beast Mode
- 61 App Studio
- 41 Variables
- 698 Automate
- 180 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 399 Distribute
- 115 Domo Everywhere
- 277 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