Limit Months,weeks

[santhosh_k_n]

Hi All,

I am using a cyclic group as a dimension in chart with 'Month,week and days' as sub dimensions.

Now i need to limit the dimensions as follows,

1. Months - for last 3 months

2. Weeks - to last 8 weeks

3. Days - as last 14 days

Irrespective of the from date and to date selected in the calender prompt.

Please guide

[tresesco]

Try using expression in group like:

[santhosh_k_n]

hi Tresesco,

Thanks for your reply.

But I need to limit the week, days and month for the selected dates in the calender prompt

for eg: if  from date is : 1st Apr and end date : 30- Apr,

then i need to display last 3 months: Jan,Feb and Mar

                                last 8 weeks: week 10 - week 18

                                last 14 days: 15th Apr - 29th Apr

[tresesco]

Could you post your sample qvw?

[santhosh_k_n]

sorry i dont have a sample right now.

[its_anandrjs]

If possible provide some sample data in the excel file.