Details and Filters

When you add a new dashboard element and select statistics for it, each statistics are presented with a single aggregated value. All statistics can provide details per Type (facility type), Object (a specific facility) or  Product. If several statistics are added to a single dashboard element, you will be only able to select the additional details options that are applicable to all of them.

Statistics can also be filtered by specific values of the Objects (specific facilities) they are collected for. If statistics are collected per product, filtering by Product is also available. If no filter is set, all the available statistics values are displayed.

You can change additional details and filtering options for a dashboard element by clicking the Change settings button in the top-right corner of the desired element and modifying the corresponding properties.

To filter the data to be displayed in the statistics

  1. Click the Change setings button in the top-right corner of the desired element. The Properties dialog box will open.
  2. Navigate to the Additional settings table.
  3. Find the required data type to filter in the Detail by column.
  4. Click the cell in the Contains column of the corresponding Detail by row to open a dialog box with a list of all the available options. By default all options are selected.
  5. Deselect all the options by Ctrl + clicking the Include column and pressing Spacebar.
  6. Now select the required options by clicking the toggle buttons in the corresponding rows.

To have the data displayed by item

  1. Click the Change settings button in the top-right corner of the desired element. The Properties dialog box will open.
  2. Navigate to the Additional settings table.
  3. Click the toggle button in the Show column of the corresponding row to switch from the default Total view to the Per item view.

For example, you add the Available inventory amount statistics to the dashboard element. If no additional details are specified to be displayed, a single summarized Available inventory amount value is shown:

The Available inventory amount type of statistics is collected for DCs and Factories, so when you add the Type as the additional details parameter, the value will be displayed for each of the two facility types: Available inventory amount for DC and Available inventory amount for Factory:

When you add the Object as the additional details parameter, the values will be further displayed for each available facilitiy: Available inventory amount for DC JapanAvailable inventory amount for DC BrazilAvailable inventory amount for Factory MFG Hong Kong, etc.:

The Available inventory amount type of statistics is collected per product, so you can also add the Product as the additional details parameter: the values will be displayed for each product of your supply chain model:

To get the Available inventory amount values for specific Objects or products, you can apply filtering. This will sort out the data only relevant for specific Objects and products, for example: Available inventory amount for DC USA / Product A:

Note that custom statistics can provide their own fields that can be used for displaying additional details and filtering.

 

Related topics

Properties of a dashboard element 

ALX Statistics