Hi, I have a table where I have lots of records.
Here is an example:
I want an output where I have the number of records by category.
If I count in Quicksight, then I get as result:
But now I want that each number is counted only once.
When I do a Distinct Count I get the following:
But I want to get a different result.
RED counts first, then Blue and finally Nothing.
So if number one contains an entry with RED, it will be counted at RED. The value at BLUE is not counted anymore.
So once a value is counted, it is not counted again.
Any idea how I can implement something like this?