Help use a beast mode to dynamically filter a dataset

JacobReynolds
JacobReynolds Domo Employee
in Beast Mode

I have a beast mode that returns the name of the current day. I want to filter a dataset to show only the rows where the Day column in my dataset are equal to the name of the current day. Can someone help?

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You could create a beast mode that creates an include/exclude output and then drag this beast mode into your filters and filter to include.

    CASE WHEN DAYNAME(CURRENT_DATE()) = 'daycolumn' THEN 'Include' ELSE 'Exclude' END

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You could create a beast mode that creates an include/exclude output and then drag this beast mode into your filters and filter to include.

    CASE WHEN DAYNAME(CURRENT_DATE()) = 'daycolumn' THEN 'Include' ELSE 'Exclude' END

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories