Parts Grid - Filter, group and chart your parts with Explore Data

Modified on Fri, 30 Oct at 1:46 PM

Use Explore Data on the Parts grid to build your own filters, group parts by a column such as supplier, export to CSV and turn your results into charts.

1. On the Parts list, click Explore Data. It gives you more control than the standard grid, including CSV exports.

The Explore Data button on the Parts list

2. Create your own filters. For example, filter to show only parts with no stock.

Creating a filter in Explore Data

3. Group your parts by dragging a column header into the area at the top of the grid, for example Main Supplier. Your parts are then shown grouped by supplier.

Dragging the Main Supplier column header to group the grid

4. To visualise your data, click and drag to select some cells, then right-click and use the menu to create a chart or graph.

The right-click menu for creating a chart from selected cells

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article