Best Of

@louiswatson It sounds like you're almost there already. How about this:

(count(case when `Status` in ('Application Consented','Application Refused','Waiting for Decision') then `Status` end)
  + count(`Appeal Determination Date`))
/ count(case when `Status` in ('Application Consented','Appeal Allowed'))

@NathanDorsch You would need to enable a second axis under Chart Properties > Value Scale (Right) > Show Right Scale. Then you will be able to set a different value format for anything on the right scale.

@NathanDorsch Try going to Value Scale under Chart Properties and changing Decimal Places to none.

@NathanDorsch So you would create a number of variables equal to the maximum number of lines you would want displayed (we'll use 3 for the examples you gave). You could name them Line 1, Line 2, and Line 3. Each one would have CPC, ROAS, and CTR as values. Then you would create 3 beast modes like the following:

case when 'Line 1' = 'CPC' then [CPC calculation]

when 'Line 1' = 'ROAS' then [ROAS calculation]

when 'Line 1' = 'CTR' then [CTR calculation]

end

Then use additional beast modes for more lines. You could also add a 'Blank' value for each variable and then in the beastmodes when the value = 'Blank' then you could set it to 0 so the line can be out of the way.

@NathanDorsch Next step is to click on 'Create Control' and define what values the variable can have. You've only set up what the default value will be, but you need to set up the actual values. Here's Domo's knowledge base article about variables:

https://domo-support.domo.com/s/article/7903767835031?language=en_US

@NathanDorsch A couple of ways you could do this. You can either start off the chart with all the lines and then the user can deselect what they don't want to see by clicking on the metric in the legend. A second option would be to use variables. You could create x number of variables for the number of lines you would want displayed, and each variable would have the metric options. Then each line would have a beastmode to show the metric that would correspond to one of the variables.

@eduardon A case statement inside a count function should give you what you need:

count(distinct case when `Status` = 'Active' then concat(`Month`,`Client`,`Country`) end)

You can utilize a window function to pull the MAU for each month and divide your DAU by that number

MAX(CASE WHEN `category` = 'DAU' THEN `users` END)
/
MAX(MAX(CASE WHEN `category` = 'MAU' THEN `users` END) FIXED (BY LAST_DAY(`date`)))