4 Replies Latest reply on Nov 20, 2012 10:25 AM by Nicolas Nadeau

# weekly average daily values

Hi

I need to display a weekly average of daily users and currently when selecting a week dimension, i'm getting the weekly users, not the avg daily.

How should i go about this one ?

N

• ###### 1. Re: weekly average daily values

Nicolas, if you can't provide your actual data, please use the Super Store sales data, and mock up a workbook so we can take a look at what you're trying to do.

• ###### 2. Re: weekly average daily values

Thanks for the reply Govinda,

Superstore data will not be helpful here since we're talking about "online users" which is not a finite measure in time.

Example: unique user coming in every day over a month:

- countd for 30 (31)  "daily metric"

- countd for 4 for "weekly metrics"

- countd for 1 for "monthly metric"

In my scenario, I want to weekly average the daily metric, not get a weekly metrics. in the example above, the desired result would be "1 average daily user per week" (not 4)

N

• ###### 3. Re: weekly average daily values

Nicolas, I'm happy to reply.

Using the Superstore data I put together a workbook that emulates your situation as best I could. You are almost certainly going to need a table calculation to do what you're trying to do. These are very tricky little monsters; and the structure of your data, the view you are looking to create, what's on what shelf, what color the pills are, what compute using & restart every setting you need, etc. will impact the way they behave. So if the attached workbook doesn't give you some ideas on how to solve this problem, then you really will need to provide some dummy data/workbook for us to provide further.

GK

• ###### 4. Re: weekly average daily values

Hey Shawn

Thanks for the reply. The hard part is that the dimension displayed need to be weeks, not days as displayed on your attached workbook. Also, using superstore won,t work for reasons desribed above.

I'll whip up sample data and update this case

thanks for replying

N