Best Of

Can you provide a little more commentary about what exactly you are looking to solve for here? It looks to me like you've already figured out the solution.

If you're looking to calculate numbers based on different filter criteria I'd recommend using a CASE statement on a beast mode or in magic ETL to solve.

Pretend I'm running a fruit stand -- I have 3 apples (that are red), 2 peaches (that are pink), and 5 blueberries (which are blue). I want to lump anything that is red or pink into a 'red' bucket.

I can write a beastmode called 'red fruits':

CASE WHEN fruit color IN ('Red', 'Pink') Then SUM(Quantity) End

This would add apples and peaches together.

Hi @luizalauretti

you can easily created a beastmode case statement as

CASE 
    WHEN `PPG` = 'MPA 90GRS' THEN 90
    WHEN `PPG` = 'CTA 90GRS' THEN 90
END

Adding as many conditions as you want individually or this is another option

CASE
    WHEN `PPG` IN ('MPA 90GRS', 'CTA 90GRS') THEN 90
    WHEN `PPG` = 'CLUMINOUS 70GRS' THEN 70
END

now if , PPG contains a lot distinct values , you could ETL a table with those values and join it to your data.

anyways, there is a lot different ways to do that. hope this helps

When you’re filtering and including a and b your lag function will pull data from metric a and b. You’ll want to add PARTITION BY ` metric ` to your lag statements to make sure you’re not jumping metrics with the lag