How do create complex filter in View
10 December, 2013
Hi Team,
I need help in create a Month filter in view. My requirement is as follows : Create a month filter in view which displays latest month data only. i.e. if when a report developer adds this month filter, data should be dynamically filters for latest month in database.
I tried something like month = Max(month) filter but couldn't succeed.
Thanks
raosinga.
I need help in create a Month filter in view. My requirement is as follows : Create a month filter in view which displays latest month data only. i.e. if when a report developer adds this month filter, data should be dynamically filters for latest month in database.
I tried something like month = Max(month) filter but couldn't succeed.
Thanks
raosinga.
Hi Raosinga,
Are you able to give some more information on what happened when you tried the max(month) function?
I think there are a few ways to do this;
Option 1 :
Using a cached filter, then setting the default value to 'Maximum Value'
Option 2 :
Once again using a cached filter, but choosing the 'Pre-defined date period' and choosing this month etc..
Option 3 :
Creating a calculated field at the view level, and using the 'Max' function.
Then in your report, you drag in your date filter , and link this to the calc field you just created.
E.g.
Let me know how you go, or if I've missed anything.
Regards,
David
Are you able to give some more information on what happened when you tried the max(month) function?
I think there are a few ways to do this;
Option 1 :
Using a cached filter, then setting the default value to 'Maximum Value'
Option 2 :
Once again using a cached filter, but choosing the 'Pre-defined date period' and choosing this month etc..
Option 3 :
Creating a calculated field at the view level, and using the 'Max' function.
Then in your report, you drag in your date filter , and link this to the calc field you just created.
E.g.
Let me know how you go, or if I've missed anything.
Regards,
David