matrix displaying data by date using segmentation

I have a timeseries (one year length) for 3 locations, with 1 daly value for each one of them:

Besides, I have 3 events categories:

Good: Values lower than 50

Regular: Values between 50 and 100

Bad: Values higher than 100

With that in mind, I need to create a matrix showing the number of Good, Regular and Bad events for each location. Something like this (referential values):

To make it even more intresting, the matrix has to be sortable by date, in order to display the number of events in a given time range. I know it can be done somehow using data segmentation:

I can share the data if needed. I would be very grateful if you could indicate me how to achieve this. Thanks in advance!

@GuyInACube @EnterpriseDNA