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.
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)
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.
WeeklyAvgDailyValue.twbx.zip 395.8 KB
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