1. Docs
  2. arrow-right
  3. Creating Snapshots
Matches version: 3.5.7

Creating Snapshots

Once you have a report, you can add a Snapshot to

  • Gather the data by specified time slices
  • Consolidate the data by groupings
  • Present the data visually in a graph or totals

In your Report, click the Snapshots tab, Give your Snapshot a name, and decide how you want to display your data:

  1. Count Rows: Measures the total number of transactions or records in a group.
  2. GenSum, Average, Maximum, or Minimum: Measures specific numeric field values.
    1. Choose the specific column you want to base your calculations on.
  3. Grouped By: Select the primary column used to group your data.
  4. Sort Direction (optional): Choose how to organize the results.
  5. Grouping Range (date fields only): If you choose to group by a date column, select your preferred time range (year over year, month over month, all the way down to minute by minute).
  6. Multi-Level Grouping (optional): Add a secondary grouping level.

Don't forget to Save your snapshot!

You can create multiple snapshots on the same report to create different visualizations of the same data.

https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/Queued-Orders-Report-Snapshots-1.png

It will then be available to display the results in:

  • The Data tab in Reports: Choose the Snapshot just above the Report results (see the dropdown at the lower-left of the image below)
  • Dashboard widgets.
https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/All-Queued-Orders-Snapshot-2.png

Adding this Snapshot to a Dashboard widget with the following settings will display the resulting image. 

https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/Number-of-Queued-Orders-Dashboard-Widget-1.png

You can add multiple Snapshots from multiple Reports to a widget for comparison. In this example, you might also want to show the quantities of Picks and Puts completed today.

https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/New-Widget-_-Step-3-Configure-Widget-_-Counts-2.png
https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/1200-Dashboard-illustration-_-Widgets-3.png

For snapshots with a secondary grouping, the widget chart will show quantities grouped by two values, depending on what's selected. A common choice is to group by Creation Date and a secondary value, though this will show a warning that grouping by Creation Date for many snapshots can begin to slow ItemPath down.

https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/Queued-Orders-by-Date-and-Type-1.png

Here are the snapshot settings for this widget.

https://files.sfo2.digitaloceanspaces.com/itempath-cms/docs/Queued-Orders-by-Date-and-Type-2.png