Cards, Dashboards, Stories

Cards, Dashboards, Stories

Use year selected from card filter

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answers

  • Answer ✓

    You could explore using a variable to accomplish this: Site faviconCustomer Support Community

    If I solved your problem, please select "yes" above

  • Coach
    Answer ✓

    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:

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

Answers

  • Answer ✓

    You could explore using a variable to accomplish this: Site faviconCustomer Support Community

    If I solved your problem, please select "yes" above

  • Coach
    Answer ✓

    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:

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

  • 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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In