The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Percent of change Day by Day by Category

Neffri
8 - Asteroid

Can someone please help with figuring out how to create day by day % of  change for the below data? I'd like to have it broken down by region and country.

As mentioned - below you can find a sample data.

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @Neffri, how does this look? The main component we're using here is the Multi-Row Formula to look back up rows and calculate the % difference. We need to handle this in two different streams as for the [REGION] comparison, we need to aggregate up to this level first. At the end, we just join these back up and then apply a sort so that we follow a similar order to what you started with.

 

2222.png

 

Hope this helps!

Neffri
8 - Asteroid

Thank you very much it's working :)

I thought that maybe multi row formula will work but something didn't work.

Labels
Top Solution Authors