Best Of

Re: SQL Flow taking hours to run

Thanks so much for the great advice on solving this issue! I will look into using Magic 2.0.

mroker

1

Re: Why are my filters not working in Magic ETL?

@damen In your formula, instead of doing COUNT('withdrawn'), do this:

SUM(case when 'fallout_reason' = 'withdrawn' then 1 else 0 end)

As you have it now, the numerator is essentially creating a "column" with the string 'withdrawn' in every row, so the numerator is doing the same thing as your denominator. You need to identify the column your aggregation should be looking at and what the condition is.

RobSomers

4

Re: Beast Mode Delete Button

Hey, @DawsonKent - I had some communication with Chris Wright about this months ago and I got the impression that they opted for "archive" rather than "delete". @ckwright, any thoughts on this?

DanBrinton

1

Re: Legend includes colour rules

I would be interested in knowing this as well. I could see why someone may want to see this on their cards but for me that would be the exception not the norm.

Chris

Chris_Wolman

1

Re: ¿How can I classify an object based on conditions?

@andersson_morales19 I would modify your statement further. Right now when you look at how many tools are used and you look at 'Basico', if they just used one 'cantidad _noticias' an that was it, they would qualify for Basico even though they only used one tool. For level one, does it have to be two different tools, or could it be two of the same (Ex: two 'cantidad_noticias' and nothing else)? This will determine how complex your beast mode will be.

RobSomers

1