Roll up data week wise

[Anonymous]

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.

Please help me on that issue.

Regards,

Kumar

[robert_mika]

What is your desired results?

[Anonymous]

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.

[sunny_talwar]

Try this may be:

Calculated Dimension: WeekStart(Date)

Expression: Sum(Measure)

[Anonymous]

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

Regards,

Kumar

[sunny_talwar · Accepted solution]

Is this not what you wanted?

[Anonymous]

My apologize and it is working. Thanks a lot.

[sunny_talwar]

No worries...

I am glad it worked.

Best,

Sunny