alexk ⚪️

About

Username
alexk
Joined
Visits
31
Last Active
Roles
Member
Points
7
Badges
2

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 [email protected] 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…