Beast mode case change based on whether or not a filter is in use

Domomon

Hey all,

Is there a way for me to use a beast mode to calculate a COUNT when a filter is not in use but to use a COUNT(DISTINCT) when a specific filter is in use or when a filter is applied on a dashboard around a specific field?

JasonAltenburg

Beast modes cannot be written to detect the state of filters. Currently there is no

CASE WHEN €filter€ = x THEN COUNT(y) ELSE COUNT(DISTINCT y)

type of logic available.

Agreed, set up a variable with 2 options, and a beast mode that uses the variable. Here’s another discussion around variables to check out: https://community-forums.domo.com/main/discussion/59343/beast-mode-that-looks-at-filters

here is the variables documentation, I highly recommend watching the video at the bottom: https://domo-support.domo.com/s/article/7903767835031?language=en_US

MichelleH

@Domomon It sounds like you could use variables for this, though that likely depends on the details of your specific use case.

JasonAltenburg

Beast modes cannot be written to detect the state of filters. Currently there is no

CASE WHEN €filter€ = x THEN COUNT(y) ELSE COUNT(DISTINCT y)

type of logic available.

Agreed, set up a variable with 2 options, and a beast mode that uses the variable. Here’s another discussion around variables to check out: https://community-forums.domo.com/main/discussion/59343/beast-mode-that-looks-at-filters

here is the variables documentation, I highly recommend watching the video at the bottom: https://domo-support.domo.com/s/article/7903767835031?language=en_US