Community Forums

Community Forums

alexk Member

Overview

Overview
Roles
Member
Badges2

About Me

About Me

Analytics

4
31
7

Reactions

No reactions yet.

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…
Default Avatar

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

Badges

  • Name Dropper
  • First Comment