Trying to sum up my group by - check picture it will help

Q&A
1

Hi All! Working on solving for a complex problem I can’t seem to solve. I have a column called ‘Buckets’ and I am trying to create a new column to take a count of how many people are in each respective bucket. In the photo below you can see my problem, it isn’t summing this up based on my table calcs. All of this is raw, row level data and I am using quicksight table calcs to aggregate. Any ideas?

Screen Shot 2022-07-06 at 11.07.23 AM

2

The total count is how the buckets are determined - ultimately, I am trying to get a count of how many ‘TEST NAME’ exist in each respective bucket based on the ‘Total Count’ column.

3

I would just reorder your table.

Group by Buckets and take the distinct count of Test Name.

image

Or take the distinctCountOver of test names over buckets if that makes more sense to your calculations.