So we have a table “score” (see the screenshot). It contains a date, user id, factor code, score, and score bin (attribute with 5 possible bins that are calculated based on score) We want to make a score distribution bar chart that will show how many users are in each bin (have a score in a specific range). The problem is that the user count doesn’t take to account the bin and shows the total count of users. What is the best way of solving this issue?

How you defined primary key (grain) on the dataset

score

?

@Martin Au-yeung In your screenshot, I can see the same user in all score bins. My guess is you actually do have all users in all bins in your data. All rows seem to be duplicated, maybe the view definition is wrong.