Skip to Content (Press Enter)
UserImage.jpg
Pedro Faria
59Views
2Comments
Count Top 1, Top 2 and Top 3 Values
Question
Reactive
Application Type
Reactive

Guys, 

I'd like to do a Count with the three largest values separated. The first count with the highest value, the second count with the second highest value, and the third count with the third highest value.

can anyone guide me on how to do these counts?

Exemple:


0
0
13 May 2023
Copy Link
2023-02-20 05-20-57
Nam Nguyen

Hi Pedro Faria,

I just want to be sure. You want to create 3 separate aggregates for these counts, right?

Nam



0
0
13 May 2023
Copy Link
2021-09-06 15-09-53
Dorine Boudry
 
MVP

Hi @Pedro Faria ,

i'm assuming that by 'top' you mean with the highest count ?

Then just sort your aggregate by descending count, and put the MaxRecords on 3

Dorine

3
0
13 May 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.