alexk

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`<=#)…
    in Pivot Table summary values Comment by alexk July 2022
  • @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
    in Pivot Table summary values Comment by alexk July 2022
  • 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…
    in Pivot Table summary values Comment by alexk July 2022
Default Avatar