Results frequency

[claudio_reis_we]

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?

[sunny_talwar]

What are you expecting to see for frequency and why?

[claudio_reis_we]

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))

[sunny_talwar]

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

[effinty2112]

Hi Claudio,

                         See if

Count(if(Aggr(Rank([Qty Cashier],1,1)=1,Store,Date),1))

gives you what you want.

Cheers

Andrew

[claudio_reis_we]

Hi Sunny,

Follow the file for your analysis.

Thanks

[claudio_reis_we]

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

[effinty2112 · Accepted solution]

Try:

store	count(Aggr(if(Rank(Count(distinct id_cashier),1,1)=1,1),store,date))
12	6
1004	29
1404	1

[claudio_reis_we]

Andrew,

Thanks so much, It worked.