Set analysis not working in Aggr function

[#1]

Hi All,

In my application there is a chart for year 2010, 2011, 2012 related to certain dimensions. The chart should not be disturbed when i select last 12month ,6 months, 3 months. (All are seperate list box). Below is the expression that i have used in the chart.

=Count({1<'Last 3 Months','Last 6 Months','Last 12 Months'= >}(if(Year=Year([MinDateVarSession]), (aggr(Timestamp,User_Pin,[Session Start])))))

When i select 3 months , the value is getting changed. I am not sure why this is happening , since in my other expression it is working fine. Is this because of AGGR function.

Below expression works fine for another chart,

=Count({$<[Last 3 Months]=,[Last 6 Months]=,[Last 12 Months]= >}distinct if( Year =Year([MinDateVarSession]) ,[Document_Name]))

Please provide a solution

Regards,

Gerard

[nstefaniuk]

Hello,

you have in your wrong formula:

<'Last 3 Months','Last 6 Months','Last 12 Months'= >

And in your good formula:

<[Last 3 Months]=,[Last 6 Months]=,[Last 12 Months]= >

I have never seen the syntax used in wrong formula, so try with the syntax of the good formula.

[#3]

Hi,

Sorry the formula that i have used in my applicaiton is as below , but still its not working.

=Count({$<[Last 3 Months]=,[Last 6 Months]=,[Last 12 Months]= >}distinct(if(Year=Year([MinDateVarSession]), AggR(Timestamp,User_Pin,[Session Start]))))

[nstefaniuk]

I think you are right but it's not a bug. In the help we can found for Aggr:

By default, the aggregation function will aggregate over the set of possible records defined by the selection. An alternative set of records can be defined by a set expression.

Maybe you can achieve it using TOTAL keyword