Set Analysis to make the date selection base on anther Date Field

[#1]

In my example , these is Column SDate and EDate  and the dashboard , there is only one Year and Month selection for the user

Some of my report is base on the SDate and some of the report is base on the EDate

So i need to use to set analysis to override the date selection .

count({<YearSDate=,MonthSDate=,YearEDate={$(=vYear)},MonthEDate={$(=vMonth)}>}recCount)

I am now using a variable to store the selection , it can make it work when both Year and Month is selected .

However ,if no Year or Month is selection , all record are filtered out. That the problem ..

Anyone can help ?

[jonathandienst]

Hi

I suggest that you make vYear and vMonth based on the maximum date, rather than the selected date. They will then contain the most recent date if nothing is selected, or the selected date if one date is selected, or the most recent selected date if multiple days are selected.

Regards

Jonathan

[kaushiknsolanki · Accepted solution]

Hi,

    Have a look at the attached document.

    Hope this will help you.

Regards,

Kaushik Solanki

[#4]

Can i have more detail on the function p() please

sum({<End_Date = p(Date)>}Value)

[kaushiknsolanki]

Hi,

     Function p() is used when you need to have set expression on set expression.

     Here in our example p() function includes all the dates from the DataIsland table.

     Let me explain you the expession working.

     In the expression written we are saying that give me the sum of values where the End_Date is ( include all the Date) Here the date is coming from DataIsland table. So when you select the month shown in example the Dates withh get filter.

     Consider you selected Jan. So your Date Field will contains the date from 1st Jan 2011to 31 Jan 2011

     So now you will get the sum of values for the end_Date where month is Jan.

     Hope this is clear to you.

Regards,

Kaushik Solanki

[#6]

One more question ...

My situation is,  there are 20 reports for my dashboard

17 of it is using  EDate and only 3 reports are looking at the SDate.

If i using the DataIsland  for the selection, every report i will need to add the set analysis

So i trying to use the  DataIsland  for that 3 reports only . The dashboard keep using the EDate for selection so no change for that 17 reports.

When i select the Time Dimension , i add action to select the same value on the dataIsland .

But i face the problem of mult-selection . When i select 2 Year , the action can't select perform the same result

[kaushiknsolanki]

Hi,

   Will you please tell me in what way you are trying to implement it., So that i can suggest you any solution for that.

Regards,

Kaushik Solanki

[#8]

Attached the example file:

When multi-selection , there would be the problem