5 Replies Latest reply on Mar 23, 2016 3:10 AM by renske.hercules.0

# Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

Hi all,

Im trying to make a calculation that calculates the average growth. I have calculated an Average Share per Series in the column "AVG Share per week".In the next column it shows the share of the previous week. I did this to calculate the growth between the current and previous week. Now I face two problem:

1) I want every week to week growth to start for every Show + Series + Channel

2) I want to calculate the average growth per series. I calculated 2 examples (see image attached). So Show 1, Season 2, airing on BBC1, should have an average growth of -4.7%.

I also attached a workbook to show you what im working with.

Hope someone can help !!

Thanks a lot!

• ###### 1. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

Anyone?

• ###### 2. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

Hi,

Create another calculated field using WINDOW_AVG() function with your Week to Week growth field.

then drag this newly created field next to your week to week growth column. Go to edit table calculation and compute using week #.

You will get this output.

I hope this is what you wanted.

Mahfooj

• ###### 3. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

Yes! This does come close to what im looking for but..:

- it should show only the Show+Series+Channel and then a number of the average growth (only the blue boxes in attached image)

- For series with only 1 week, there is no average week-t-week- growth. So then it should say Null. (see red in attached image) I dont understand why it calculated a number because statistically its not right..right?

Please let me know if you have a solution !

• ###### 4. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

Hi,

I've done some calculation on Week-t-Week AVG growth. I'm not having any number for the same.

Mahfooj

1 of 1 people found this helpful
• ###### 5. Re: Calculate Average from "Percent difference from.."Table Calculation/ Calculate AVG growth

Thanks a lot! Its perfect