-
Re: normalized data multi line chart
Heya - Had a play with this although with not much more success as I am not sure how the overall (column O) number should look like. But to get the individual account, I added Account to the filter a…1 -
Re: If contains statement beast mode
remove the ; at the end of the syntax case when `url` like '%goo%' then 'google' when `url` like '%adCREASIANs%' THEN 'By Gina' when `url` like '%Aerovex SystemsInc%' THEN 'Hemp Beauty' else 'na' end2 -
Re: Beast Mode works but not in Summary
Using my own dataset, I can get the beast calc to show in the summary value: The difference is I moved the ABS to the front. Hope that helps CONCAT( round(abs(avg(case when (`Account Name`) = 'Units'…3 -
Re: CASE WHEN X IS NULL THEN Previous Value
I am not sure how the performance would be like on a large dataset, but on a sample data, it can be achieved in 2 steps. Step 1 - Create a transformation call rank_table SELECT `Account`,`Date`,`Cost…3
