
Partner - Specialist III
2024-04-30
07:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Front End Calculations SET, AGGR, IF?
Cheers people
I am facing an issue while trying to calculate this on the front end this type of results.
The income data is A:C - result E:G columns.
I need to COUNT the DISTINCT number of Barcodes according to the Manufacture minimal Rating.
Manufacturer | Rating | Barcode |
A | 1 | 1 |
A | 1 | 1 |
A | 2 | 3 |
A | 2 | 4 |
A | 4 | 5 |
B | 2 | 6 |
B | 2 | 6 |
B | 2 | 8 |
B | 3 | 9 |
C | 1 | 10 |
C | 2 | 11 |
C | 3 | 12 |
Thank you in advance for helping me out!
1 Solution
Accepted Solutions


Champion III
2024-05-02
02:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As below
=Count(Distinct Aggr (if(Rating=min(total <Manufacturer> Rating), Barcode),Manufacturer,Rating,Barcode))
Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
If a post helps to resolve your issue, please accept it as a Solution.
4 Replies

Contributor
2024-04-30
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This should work:
sum(aggr(min(Rating),Manufacturer))
You can hide 0 values from your table, or exclude them in your expression if you don't want to see them in your table.
707 Views

Partner - Specialist III
2024-05-02
01:23 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yet I need COUNT IDTSINCT of Barcodes.
672 Views


Champion III
2024-05-02
02:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As below
=Count(Distinct Aggr (if(Rating=min(total <Manufacturer> Rating), Barcode),Manufacturer,Rating,Barcode))
Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
If a post helps to resolve your issue, please accept it as a Solution.

Partner - Specialist III
2024-05-02
04:24 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@vinieme12 you're a champ! 🙂
