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
