Ranking function across two dimension for a count of products

Douwe_KB — Tue, 08 Nov 2022 15:05:31 GMT

Dear reader,

I am currently working on a ranking function which ranks products bought by the frequency. The location of the shelf is also included, however it is currently only ranking within shelves and not across the entire shop. For example if we have a shelf A with 3 products: Apple: 3, Banana 5: Tomato: 1 and a shelf B: Cucumber: 4, Pineapple: 2, Rice: 6.

I want the ranking to look like this:

B: Rice |1

A: Banana |2

B: Cucumber|3

A: Apple |4

B: Pineapple|5

A: Tomato |6

However, it is currently showing up as follows:

A: Banana |1

A: Apple |2

A: Tomato |3

B: Rice |1

B: Cucumber|2

B: Pineapple|3

Image for reference of my data.

I am currently using this function for ranking:

rank(count(Total Aantal))

Any help is appreciated!

Re: Ranking function across two dimension for a count of products

rubenmarin — Tue, 08 Nov 2022 16:11:45 GMT

Hi, try with the TOTAL on the rank function, not the count: rank(Total count(Aantal))

topic Ranking function across two dimension for a count of products in App Development

Ranking function across two dimension for a count of products

Re: Ranking function across two dimension for a count of products