Multi value comparison

LearningNinja
LearningNinja Member
in Beast Mode

Hi,

I am configuring a multi value comparison card.

I have Sales column which is being configured in Gauge Value.

In Comparison Value, I want to input the value of Sales Column itself but of previous year.

I want this comparison to be dynamic because on my dashboard I have dropdown filter (Year, Month, Quarter). So if I select any Year like 2023, this should be in gauge value and previous should become 2022.

I am unable to reference the Year dropdown which is configured on my dashboard. This dropdown is configured using a Year column available on my dataset.

Tagged:

Best Answer

  • david_cunningham
    david_cunningham Coach
    Answer āœ“

    @LearningNinja if you use Domo's built in date range/grain page filtering, this is handled for you. However, you can't specify the exact year. When you use a filter card, the rows are filtered down, so you would need your comparison values in a column to be able to reference them.

    For example, here is a card which is defaulted to show the current year compared to the previous year. You can see that 2024 is 2.3k and all of 2023 is 5.39k.

    Screen Shot 2024-06-03 at 1.35.26 PM.png

    If you select YTD using the built-in page filter, now we are comparing 2024 ytd to 2023 ytd for the same period.

    Screen Shot 2024-06-03 at 1.37.27 PM.png

    I understand that you want to be able to select a year, and see the previous year as a comparison, but how would this work if a user also selects a quarter? Would you want to show the same quarter in the previous year? The previous quarter in the same year? Same question for month. If you're just wanting to always compare the same period, but in the previous year, you could achieve this as follows.

    Set this up comparison periods in your ETL and stack those. This would basically look like this

    Screen Shot 2024-06-03 at 4.33.35 PM.png
    Screen Shot 2024-06-03 at 4.33.51 PM.png

    Then in Analyzer, you could set up the following beast modes.

    Gauge Value

    SUM(case when compare_type = 'Current' then Column end)

    Comparison

    SUM(case when compare_type = '1 Year Ago' then Column end)

    Then if you create your filters off of the column "compare_date", you drive interactions like this.

    For example, here no comparison is selected.

    Screen Shot 2024-06-03 at 4.36.02 PM.png

    Here we are comparing 2024 Q1 to 2023 Q1.

    Screen Shot 2024-06-03 at 4.37.14 PM.png

    David Cunningham

    ** Was this post helpful? Click Agree šŸ˜€, Like šŸ‘ļø, or Awesome ā¤ļø below **
    ** Did this solve your problem? Accept it as a solution! āœ”ļø**

Answers

  • david_cunningham
    david_cunningham Coach
    Answer āœ“

    @LearningNinja if you use Domo's built in date range/grain page filtering, this is handled for you. However, you can't specify the exact year. When you use a filter card, the rows are filtered down, so you would need your comparison values in a column to be able to reference them.

    For example, here is a card which is defaulted to show the current year compared to the previous year. You can see that 2024 is 2.3k and all of 2023 is 5.39k.

    Screen Shot 2024-06-03 at 1.35.26 PM.png

    If you select YTD using the built-in page filter, now we are comparing 2024 ytd to 2023 ytd for the same period.

    Screen Shot 2024-06-03 at 1.37.27 PM.png

    I understand that you want to be able to select a year, and see the previous year as a comparison, but how would this work if a user also selects a quarter? Would you want to show the same quarter in the previous year? The previous quarter in the same year? Same question for month. If you're just wanting to always compare the same period, but in the previous year, you could achieve this as follows.

    Set this up comparison periods in your ETL and stack those. This would basically look like this

    Screen Shot 2024-06-03 at 4.33.35 PM.png
    Screen Shot 2024-06-03 at 4.33.51 PM.png

    Then in Analyzer, you could set up the following beast modes.

    Gauge Value

    SUM(case when compare_type = 'Current' then Column end)

    Comparison

    SUM(case when compare_type = '1 Year Ago' then Column end)

    Then if you create your filters off of the column "compare_date", you drive interactions like this.

    For example, here no comparison is selected.

    Screen Shot 2024-06-03 at 4.36.02 PM.png

    Here we are comparing 2024 Q1 to 2023 Q1.

    Screen Shot 2024-06-03 at 4.37.14 PM.png

    David Cunningham

    ** Was this post helpful? Click Agree šŸ˜€, Like šŸ‘ļø, or Awesome ā¤ļø below **
    ** Did this solve your problem? Accept it as a solution! āœ”ļø**

Categories