Filter Question ??

[mstrgrl]

This may be a dumb question, but... I have a transformation table for my dates this year/last year/2 years ago. I'm OK using dynamic dates for my "Today" date filter; however, when I need "last year today" -- the dynamic function will pull calendar date when I need fiscal date. The value for my filter exists in the transformation table but I don't think there is a way to apply any logic to filtering to do anything like this. (Example: transform table shows:

date_id (this year) ly_dateid (LY) lly_date_id (2 ya)
with a lot of other date data in same row.

If Sysdate is "date_id" then I want to be able to put the value in ly_dateid into the filter???

Thanks and hope it isn't too confusing!!!

 

[Z3]

What you need to do is just use this filter, but in your metrics apply "last year" transformation. That'd take care of it hopefully.