7 Replies Latest reply: Jul 31, 2015 7:28 AM by Sunny Talwar

# Roll up data week wise

Hello experts,

I have year data and my requirement is it should roll up data week wise.

For example.

week          measure

7/30/2015      20

7/23/2015      50

7/16/2015      40

7/09/2015      100

.

.

..

The data here splitting week wise and rolling up, what are the data available in that weeks.

Regards,

Kumar

• ###### Re: Roll up data week wise

Hi,

Pls find the screen shot of requirement.

In this screen shot for every week it is rolling up .

measures for each respectively

1)   =count(DISTINCT{\$<[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

2)  =count(DISTINCT{\$<[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID]&'_'&[Site Visit Vis Num])

3) =sum({\$<[Site Visit Hit Source]={"<>5,8,9"}, [Site Visit Post Page Event] = {0}>} [Site Visit Record Count])

like that I can calculate.

But in the dates I want to roll up for each week.

• ###### Re: Roll up data week wise

Try this may be:

Calculated Dimension: WeekStart(Date)

Expression: Sum(Measure)

• ###### Re: Roll up data week wise

Thanks for ur reply. It is splitting by week wise, but roll up is not happening.

Regards,

Kumar