Multi value comparison

LearningNinja

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.

david_cunningham

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

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

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

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.

Here we are comparing 2024 Q1 to 2023 Q1.

david_cunningham

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

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

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

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.

Here we are comparing 2024 Q1 to 2023 Q1.