Use year selected from card filter

ecabanas

Hi,

I'm using a dropdown list that selects year values, I want to use the value selected to created a calculation. Is it possible to use the year selected?

For example if in my dropdown list I selected year 2023, then use this value to do a year previous revenues sum

thanks

ColemenWilson

You could explore using a variable to accomplish this: https://domo-support.domo.com/s/article/7903767835031?language=en_US

marcel_luthi

As @ColemenWilson suggested, once you have the year as a variable, you can make your cards show all time, and then create a Beast Mode to use as a filter instead, which would look something like:

CASE WHEN YEAR(`date_field`) = `variable_name` THEN 'show' ELSE 'hide' END 

And make it so that you filter only to the show value. (if you want the year previous to the one selected you can just update the formula to be YEAR(`date_field`) + 1 = `variable_name` instead)

ColemenWilson

You could explore using a variable to accomplish this: https://domo-support.domo.com/s/article/7903767835031?language=en_US

marcel_luthi

As @ColemenWilson suggested, once you have the year as a variable, you can make your cards show all time, and then create a Beast Mode to use as a filter instead, which would look something like:

CASE WHEN YEAR(`date_field`) = `variable_name` THEN 'show' ELSE 'hide' END 

And make it so that you filter only to the show value. (if you want the year previous to the one selected you can just update the formula to be YEAR(`date_field`) + 1 = `variable_name` instead)

ecabanas

Hi

Thanks' both for your help, but the question is how assign to a variable the value that comes from a year selector card. In PowerBi I hve the option to assign "selected Value" but in domo I have no idea.

Thanks

Eduard

https://community-forums.domo.com/main/discussion/comment/83918#Comment_83918