Bookmark Max Data

[Anonymous]

Hello Guys,

I have a bookmark, which filter Areas. But i want include or create a bookmark which filters my variable maxDate ( max(Date)).

Every day i need to filter year, month and day. I want to only select the Bookmark calling my variable maxDate.

Thanks

[maleksafa]

you can create a bookmark to filter on the max(date) by using the advanced search expression on the date field.

1) add a new label with Date as dimension

2) right click on the object and go to advanced expression

3) write the expression there and hit go

4) create the new bookmark that will call this expression.

[Anonymous]

Hello Malek,

Thanks for you answer, but this doesnt resolve my problem.

I actually have 20 reports, and need to filter all of them with a different bookmark. So i need to filter by region and with a variable MaxDate.

The problem is this :

If i bookmark a region, it always get max date. But if i select a previous month, it still gets the actual month, not the previous.

And i cant select area by area, date by date, because we are using a macro to generate these reports.

Is this possible?

Thanks !

[JonnyPoole]

Hi - i am wondering if you just need to take the '=' sign out of your variable definition.  If your variable is something like this:

=max(Date)

try changing it to this:

max(Date)

that way the expression text is injected into your other expressions first before calculating it the overall expression. you will probably need dollar sign expansion  $(vMaxDate)  to invoke  the variable (in this example named 'vMaxDate'). 

[Anonymous]

Hello Jonathan,

Thanks for the answer.

Is possbile apply my variable in the bookmark ?

Thanks

[Anonymous · Accepted solution]

Hello Guys,

I've solved it.

When we apply a bookmark, it overwrite all the other selections. So i've done, is edit the bookmarks, and check the option '+'.

Before, if i have the 2014 selected and apply bookmark x, the selections stay only 'x'.

Now, is my selection AND the bookmark.

Thank all of you !