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 ?

[tresesco · Accepted solution]

You probably missed out 'date format' note. PFA

[manojkulkarni]

Thanks for solution..it worked