5 Replies Latest reply on Oct 18, 2013 5:18 AM by Matt Lutton

Total Averages

I have 2 sources of data

- customer base

- revenues

I have blended these data sets together to get the ARPU (Revenues / Average base)

the ARPUs for each account in the table below are correct

However, I want to be able to show the overall total average as well

It looks like my main problem is to create the total of averages

In my example - the total Average customers are averaged . I want the total average to take the average of the total closing base for 2 months   eg Jan average is showing 1183.  I want the average of 6500 Dec & 7700 Jan = 7100

For the ARPU (Revenue / Average Base)

I want to calculate total revenue Jan 578,000  / average base Jan 7100  = \$81.41

But my tableau example is showing \$488.45

Can anyone please help with this?

thanks,

Katherine

Ramon Martinez

• 1. Re: Total Averages

So it's acting that way because of the Number of Records you have based on your blend. I too have been plagued with this. For my case I went back and fixed my import so I wasn't blending, but in your case I think you can just divide ARPU by SUM([Number of Records]) to get the average you want.

Am I off base?

1 of 1 people found this helpful
• 2. Re: Total Averages

Thanks Kyle, that's great!

Are you able to help me get the total average base?

K

1 of 1 people found this helpful
• 3. Re: Total Averages

thanks - I've updated my average base formula to

WINDOW_AVG(SUM([Closing Base]), -1, 0)

& the overall total works now

• 4. Re: Total Averages

Hi Katherine,

Good to know your get your problem solved.

Ramon

• 5. Re: Total Averages

Katherine: Please mark your question "assumed answered" or otherwise mark it answered so others know not to try and help with this thread.  Helps keep the forum clean.  Thanks!