Best Of

Re: Calculate % of Repeat Customersvia Beast Mode

To do aggregate (as opposed to row-level) calculations in a BeastMode, you'll need to use FIXED functions:

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

Yours would be something like:

(case when sum(count(Distinct `Customer Name`) fixed())>=2 then 1 else 0 END)/sum(count(distinct `Customer Name`) fixed())

DavidChurchman

DavidChurchman

1

Re: HELP with Case When Statement

Thanks for picking this up @MarkSnodgrass & @ST_-Superman-_ - great solution! :)

Samuel.

Samuel.

1