Need to Comparison Single Value Chart

scpradhan
scpradhan Member
in Charting
image.png

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?

Answers

  • ArborRose
    ArborRose Coach

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • scpradhan
    scpradhan Member

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

  • MichelleH
    MichelleH Coach

    @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
    scpradhan Member

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

    image.png

  • csteele
    csteele Member

    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
    ArborRose Coach

    @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).

    image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • scpradhan
    scpradhan Member

    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

    image.png

  • ArborRose
    ArborRose Coach
    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories