Column Selector in Cards with Filter

Hi,

Is there a way to build a filter with different column values in it and then build a beastmode that will select the column based on the filter selection?

For example lets say I have full price and markdown data in different columns. I would like to build a filter that has options for full price and markdown and then build beastmodes that would select the correct column based on the selected filter.

Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    yes the "variables beta" will be going live soon and can address this issue.

    you'll be able to set up a varaible with enumerated values (ex, "full_price" and "mark_down")

    then you could write a case statement

    CASE
    when <variable> = 'full_price' then <col_name>
    else <other_col_name>
    END
    
    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"