Now it’s time to build our report! This is where the query table (and your newfound SQL skills) pay off.
Create a chart that counts up the records in those four categories, one that you can filter by date.
However, don’t limit yourself! You could create a timeline, with each category being a separate line.
Or, build a Pivot or summary table. On all of these, the user filters work really well for an easy and helpful user experience.
