time based filter

[#1]

Hello,

I am trying to figure out the best way of implementing a time based filter. The data is at a monthly level, but I would like to create a filter that would show data for the Last 3 Months, Last 6 Months, Last 12 Months, Last 18 Months and Last 24 Months.

I thought of doing this in the Load script by tagging each record based on today's date - but found a few issues with that. I also considered dynamically evaluating that in the expression of the graph, based on a value selected by the user in the list box, created from an INLINE table .That also didn't seem to be the best way of doing this.

Any thoughts/ideas for accomplishing this?

Thanks, Maria

[maneshkhottcpl]

Hi Maria,

u can use the inmonth function in backend and create a 3 months bucket.

or use mod function to create a bucket of 3 month like 3,6,9,......

if u send me the sample data i can surly help u.

Thanks

Manesh

[#3]

Manesh,

thanks for the offer. I convinced the users to just have a filter for Month.

Thanks, Maria

[Oleg_Troyansky]

Maria,

I usually solve those problems in the script, adding an extra field to the Master Calendar. What issues have you had with that?