A custom report can be drawn as a chart, and every number on a grouped report can be opened to show the records that make it up. Both work on the Reports page in the Shopify admin and at go.stockroom.app.
Add a chart
Click the chart button above the table. Its label reads Add a chart. The chart sits above the table and uses the rows the report already has, so it does not run the report again.
Your report needs a grouping, such as by supplier or by month. Without one, the chart says Group your report to chart it. and offers a grouping to add.
Chart type: Best fit, Bars, Columns, Line or Stacked. Best fit draws dates as a line or columns, and everything else as bars.
Values: up to five number columns of the same kind, such as all money or all units.
Along the axis: with two groupings, pick the one that runs along the axis. The other grouping splits each bar.
Show the previous period: when the date range has Compare with set, draws the earlier period beside each value.
Remove chart takes it off the report.
Bars show the top 15 groups and columns the top 12. When every row is loaded, the rest are added together as Other. Hover over or tap a bar or point to read its value, or use the arrow keys.
See the records behind a number
On a grouped report, click a number in a row, a section line or a total. On a chart, click a bar or point and choose See the records. A window lists the records behind that number, with your report's filters and dates, and they add up to the number you clicked.
On a report that lists products, stock or purchase order lines without grouping them, units sold and sales amounts open the sale days behind them, and stock figures open the stock at each location.
From the window you can Export the records, or click Open as a report to keep working with them as a new custom report. If your report has unsaved changes, you are asked to save it first. A long list shows its first rows and says so; open it as a report to see them all.
Only numbers that can be traced to records are clickable. Calculations, comparison changes and a few figures worked out from other data, such as open units on order or the last received date, can't be opened.
Good to know
Amounts in different supplier currencies are never drawn on one axis. Group or filter by currency to chart one at a time.
The chart is saved with the report and prints in PDF exports and scheduled PDFs. CSV and Excel files hold the rows only.
If your role hides costs, the records you open never show them either.


