6 Replies Latest reply: Oct 14, 2014 7:25 AM by vikas mahajan RSS

    Dynamic dimension bucketing

    Punit Popli

      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