How do I chart grouped numbers of repeated entries?

Hello All,

I have a data set that has students listed with their student ID. The students are entered into this data set any time a member of staff has an encounter with them.

Some of these students are listed once, some are listed anywhere between 2 and 17 times. e.g. they have repeat encounters.

On the X axis I want to display “number of encounters” e.g. 2 encounters, 3 encounters etc…

And on the Y axis I want to display the “count of students who have that number of encounters”. e.g. 3 students have had 12 encounters.

My data set has a ticket number, time stamp, student ID, a couple other identifiers including grade and age.

I have included an image of where I am. You can see the X axis is the individual student ID, and there are distinct groupings of ID that have the same amount of encounters.

I honestly can’t recall ALL the things I have tried but from what I can tell Looker may not be able to easily group or display the “number of unique encounters greater than 2 in buckets”.

Send help x