Information Map - Advanced Filter

[wrosario]

I am needing to create an advanced filter while the information map, the filter would be a prompt for an initial period least 365 days, you have any suggestions?

[Madelyn_SAS]

Can you provide more detail about your goal?

[wrosario]

I am creating a filter within the information map that you can bring me the last 12 months of a certain amount, but to know the last 12 months the user will have to enter a month, then the only way I'll figure out who are the last 12 months.

Prompt: Fev - 2014

Result Report

Month    Profit

Fev-14     15

Jan-14     10

Dez-13     28

Nov-13     30

Out-13     15

Set-13     30

Ago-13     20

Jul-13     20

Jun-13     20

May-13     20

Apr-13     20

Mar-13     20

Tks for all

[RainB]

Hi,

The solution little bit depends how the date data item is used in your information map.

What I tried and maybe helps you is this(I used dummy data for testing).

data library.test_data;

input mon date9. value;

datalines;

01Feb2014     15

01Jan2014     10

01Dec2013    28

01Nov2013     30

01Oct2013     15

01Sep2013     30

01Aug2013     20

01Jul2013     20

01Jun2013     20

01May2013    20

01Apr2013     20

01Mar2013     20

;

Then in the information map studio I defined mon data item as "Date" type and used format EURDFMY and called it DataItem1.

Next I created filter that looks like this:

And when I test this filter, I get this selection:

and results are here:

Kind Regards,

Rain

[wrosario]

Rain,

The problem is that the second date (to) not being in accordance with the first choice, it is always based on the current date minus the number of months in crate side.

Example:

From Date: Dez 14

To Date: N Months ago (Feb 14, Jan 14, Dez 14, Nov 14, Oct 14 , Sep 14 )

right would

From Date: Dez 14

To Date: N Months ago (Dez 14, Nov 14, Oct 14 , Sep 14, Ago 14 )

Tks

[RainB]

wrosario wrote:

Rain,

The problem is that the second date (to) not being in accordance with the first choice, it is always based on the current date minus the number of months in crate side.

Example:

From Date: Dez 14
To Date: N Months ago (Feb 14, Jan 14, Dez 14, Nov 14, Oct 14 , Sep 14 )

right would

From Date: Dez 14
To Date: N Months ago (Dez 14, Nov 14, Oct 14 , Sep 14, Ago 14 )

Tks

Hi again,

Your requirement is something that I am not sure can be achieved- dynamic calculation. Or maybe someone else with more knowledge can help you out.

Rain