Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can you help me please!
In the example below I am counting the item per store and date. I would also like to know the frequency of income per store.
Table:
store | date | item
1 | 01/08/2016 | A
1 | 01/08/2016 | A
1 | 02/08/2016 | A
1 | 03/08/2016 | A
1 | 03/08/2016 | A
Max(Aggr(Count(DISTINCT item),store,date))
Result:
store | amount | frequency
1 | 2 | ???
Question: what is the frequency?
Try:
store | count(Aggr(if(Rank(Count(distinct id_cashier),1,1)=1,1),store,date)) |
---|---|
12 | 6 |
1004 | 29 |
1404 | 1 |
What are you expecting to see for frequency and why?
Hi Sunny, thank you for your quick response.
I would like to represent the frequency in which store worked with the maximum number of cashiers. Follow attached the example for your better understanding.
Thank you in advanced.
Qty cashier = Max(Aggr(Count(DISTINCT ID_Cashier),Store,Date))
I see what you are looking to get, would you be able to share a sample to play around with it. Apologize for not able to give you a solution right away, as I feel I might need to play around with it before I can propose a solution
Hi Claudio,
See if
Count(if(Aggr(Rank([Qty Cashier],1,1)=1,Store,Date),1))
gives you what you want.
Cheers
Andrew
Hi Sunny,
Follow the file for your analysis.
Thanks
Hi Andrew,
This expression works only if the values have not been calculated. In this case, it has expression:
Qty cashier = Max(Aggr(Count(DISTINCT ID_Cashier),Store,Date))
Follow the file for your analysis.
Thanks
Try:
store | count(Aggr(if(Rank(Count(distinct id_cashier),1,1)=1,1),store,date)) |
---|---|
12 | 6 |
1004 | 29 |
1404 | 1 |
Andrew,
Thanks so much, It worked.