I am making a simple chart that shows the count of events occurring each day for the past 7 days. Currently, I have 10 events in my user’s collection, and all of these are marked over the past 7 timestamps as seen in the screenshot. I am trying to make this chart count how many events occurred each day and display that count per day (ie. 1 count if 1 event happened 2 days ago, 2 counts if 2 events happened 3 days ago, etc). How would I go about making this happen?
A small second question - my chart was sorted oldest to newest with a max # of items, but this cuts off the latest events… Is there a way to sort newest to oldest moving right to left (essentially flipping the screenshot)?