Need to Comparison Single Value Chart

scpradhan · 2024-03-07T19:34:07+00:00

There was an error rendering this rich post.

This chart should be changed based on any date range selected by user and compare the value based on the date range selected by user. For exampale if user selects 10days it should compare with prior 10 days; if 30 days prior 30 days. Is it possible to do in Domo?

Find more posts tagged with

Accepted answers

All comments

ArborRose

Use a beast mode calculation that subtracts the amount desired. If you want to compare to previous 10 days, it would be DATE_ADD(CURRENT_DATE(),-10)). The number of days could be selected from a static filter.

scpradhan

But date range is not always static; its dynamic; user can select any date range from date filter.

MichelleH

@scpradhan You could use a variable for "Number of Days" instead of using the date range filter, then you could reference that variable in the beast mode that @ArborRose suggested

scpradhan

Actually the client wants to use global filter, want to see the changes in the card based on the selection. Is it possible?

csteele

Did you ever find a solution for this? I'm struggling with the same issue. I need to use a global date filter and have the comparison based on the previous period from what was selected.

ArborRose

@csteele - As @MichelleH stated, you should be able to use variables for start and end dates. The variables will show up under the variable tab on the card. They can be placed on the dashboard for user selection. In a formula, reference the variable like you do a field name (backticks).

scpradhan

While creating a variable where the user can select the date range, how can I change it from the default value, as it does not allow to save without selecting default value

ArborRose

https://community-forums.domo.com/main/discussion/comment/100490#Comment_100490

There has been a suggestion posted asking Domo to give us a default value ability based on formula or at least set it to curdate(). Over 100 upvotes but alas, we are still waiting.