How to use the interactive tables for waste and cost reports correctly?

You have the option to create waste and cost reports and download them for further analysis. In the reports, you can easily answer various questions by correctly filtering, grouping, and performing other actions. In this article, we will explain how to use the interactive table correctly.

The column menu:

In the column menu, you will find various actions such as filtering, grouping, or pinning. You can open the column menu by first hovering over a column with your mouse and then clicking on the icon in the form of three bars.

The filter options:

Open filters

The filter options are located in the column menu, in the middle tab.

Select elements

By clicking on an element, you can add or remove it from the filter. If you want to add a specific element, you can find it using the text search at the top. You can select or deselect all objects using the "Select all" action. Only the objects that are displayed to you by the text filter will be selected or deselected. To remove all objects from the list, you must first clear the text filter. 

Filter numerical data

There is a separate filter for numerical data. You must first select how you want to filter, e.g. greater than, less than or equal to. And then enter the value to compare.

Further filters

Above the table, you can filter the data in the table by a specific period and a specific level of detail. To do this, enter the start and end date of the period or select the corresponding information in the "Detail level" dropdown menu.

Reset filters

To reset the filter selection, click the "Reset filters" button above the table.

Selecting the displayed columns:

To save space, not all possible columns are displayed initially. If you need additional information, click on the third tab (table icon) in the column menu (icon with three bars) of any column and select the information you want to display. Select the information that you do not want to include in the table.

Grouping columns:

You can group columns by dragging them to the top bar. Alternatively, you can also select the "Group by..." option in the column menu of the corresponding column.

Pinning columns:

If you want to always see a column, you can pin it to the side. To do this, first open the column menu and then click on "Pin column" and select the corresponding option (pin left, pin right, no pin).

Exporting data:

You can export data by right-clicking on any row in the table. There you can then select the desired file format (CSV export or Excel export) and export the data. Alternatively, you can also click on the download button (Excel export) above the table for an Excel export. Note: Only the columns that are displayed in the table are always exported. To export additional information, you must first display the desired columns (see description above).