Dynamic dimension bucketing

[punitpopli]

Hi All,

I have a requirement where I have to show week ending date along with some measure value in bar chart, but the week ending date will be selected by users on run time.

The data presentation is like below:

the values must be summed up for every 4 week and Max() of week end date (i.e. out of 4) should be displayed as per the screen shot below (highlighted both week ending date and values background)

How to calculate the date range dynamically (i.e 4 weeks and their sum) on run time ?

Thanks in advance

[#2]

Hi,

How many week ending dates a user is allowed to select. is it only one or he can select any number of week ending dates?

[vikasmahajan]

Week is there in your calender ?

Vikas

[punitpopli]

Shruthi Reddy : User can select any numbers of Weeks.

Vikas Mahajan : Yes, we have week ending date in our calender.

Please let me know if any other information required from my side.

[vikasmahajan]

you can try this expression

SUM(AGGR(Sum(Values),WEEKDAYS))

Vikas

[punitpopli]

Vikas Mahajan : We are not having data for each day, instead we have data on the basis of Week ending date (as shown in the example above) and we have to show accumulation of 4 weeks data on Y axis and the 4th week ending date on x axis (as highlighted in example above).

Please let me know fi any other information required.

[vikasmahajan]

pfa sample  you need to apply rangesum command

Vikas