Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this not what you wanted?
What is your desired results?
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.
Try this may be:
Calculated Dimension: WeekStart(Date)
Expression: Sum(Measure)
Thanks for ur reply. It is splitting by week wise, but roll up is not happening.
Regards,
Kumar
Is this not what you wanted?
My apologize and it is working. Thanks a lot.
No worries...
I am glad it worked.
Best,
Sunny