Hi team, does the new function

HISTOGRAM

in 0.11.0 support distinct count? From the documentation seems like it does not

It does not right now. What’s the use case you are trying to solve?

@Mayank For example, I have a bunch of students with test scores, each row has student id and test score on one subject, so one student id can associate with multiple rows (scores for different subject), I want to show their score distributions like how many of them receive a score between "70-80", "80-90 etc. Previously I used CASE WHEN ELSE

select distinctcount(student_id)count, case when ... else end score group by score

so I'm trying to see if histogram can offer the similar functionality

I see, so distribution is on students’ score on “any” subject? Wouldn’t you want it per subject?

@Mayank Yes, in this example I want "any subject". This is an example I came up randomly since my use case is for work so I'm not allowed to share

Got it.