Need to Comparison Single Value Chart

Options
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
    Options

    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
    Options

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

  • MichelleH
    MichelleH Coach
    Options

    @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
    Options

    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

Categories