Aggr - Help required

[manojkulkarni]

Hi everyone,

I am doing some aggregate at chart level to identify the customer last visit at shop level.

My dimension is Shop Id and expression is to get max transaction date of each user per shop.

I am calculating difference using maximum date at global & maximum date derived from aggregate at user/shop level.

This works only when I add user ID in dimension, but i doesn't want to show userid in dimension.

How this can be solved ?

[mario-sarkis]

vMaxDate=num(Today())

Count(

               If(

                         (vMaxDate - aggr(max(num(tranDate)),CustID,ShopID))>40

                         , CustID

                    )

               )

[manojkulkarni]

Not working. Same tried

[tresesco]

PFA

[manojkulkarni]

For it is not working. We are close to solution.

I need to consider certain transactions only, that means i have set analysis to filter date while taking maximum. How should we do this ?

[manojkulkarni]

I need to show only customers who made transaction between 15-12-2014 & 31-03-2015, in this case i should get count 2

[tresesco]

Count(

               If(

                         (vMaxDate - aggr(max({<Date={'>=15-12-2014 <= 31-03-2015'}>}Date),CustId,CustId))>90

                         , CustId

                    )

               )

Note: the loaded date format and this set date format (DD-MM-YYYY) have to be same.

[manojkulkarni]

tried same thing, it is not working.

[manojkulkarni]

In fact, tried same in the application provided by you. It is not working..

Pls could help me

[tresesco]

Could you share your sample app?

[manojkulkarni]

Attached Sample with modified expresion