Create Flippin’ Cool Charts with Your Query Table!

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.