Comments
-
Hopefully this is enough? CASE WHEN `Stage`='7' THEN $ WHEN `Record Type` IN ('A','B') AND `Stage` NOT LIKE '%7%' AND `Score`>= # AND DATEDIFF(`Snapshot Date`,`Last Modified Date`)<= # THEN `$` WHEN `Record Type` IN ('A','B') AND `Score` IS NULL AND `Stage` NOT LIKE '%7%' AND ((`Stage`='1' AND `Days in Current Stage`<=#)…
-
@RobSomers A colleague recommended I move the transform to MagicETL so it's a formula card now instead of a beast mode. The transform is a bit confidential so can't really share the exact statement. In essence, it adds a column to pull through existing $ value for each record depending on 3/4 sets of criteria
-
Thanks friends!@Ashleigh I'm sorting on a beast mode but doesn't look like it removing it made much difference :( @RobSomers It is pretty large... the dataset has 5.5M. When I apply filters to the pivot table card, it brings it down to about 10k. Do filters not help with "reducing the size"? What's weird is that it was…
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In