Best Of

Everything
Promote
Insightful
Agree
Like
Awesome
LOL

Re: Summing Values Between Dates & Comparing to Other Values

Have you tried using SUM on your billed amount and MAX on your gross amount with a group by function in an ETL grouping on your provider and pay period dates?

GrantSmith

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

Re: HELP with Case When Statement

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

Samuel.