Report Groupings

09/22/2015 Posted by Brandon

You can now add multiple groups to your reports!

Most reports in Knack work by running calculations on groups of records. For example, you could group orders by date and then calculate the average order total for each date. You can then display these calculations in line or bar charts.

We recently added the ability to add multiple groups. Here’s an example where orders are grouped by both date (month) and by product:

We also expanded which fields are eligible to use for groups. Beyond dates, connections, and multiple choice, we added yes/no and most of the text and numeric fields.

Notes:

  • The most groups you can add is two.
  • You can only add 1 calculation if you have more than one group.