You are doing a rollup along a category. If I understand your use case correctly, your category is a date.
Have a look at the following post and try with the relation column and rollup column.
Once you manage to get the data you need in your Glide Table – I would recommend you use Glide tables here and not a Google Sheet – then you’ll determine which components are best suited to displaying the data.