Histogram is a graphical representation of the distribution of data. For the axis X you can select from all measurements defined in the data model with a data type of Quantity, Money or Number. The axis Y is the frequency of the selected measurement defined in the data model with a data type of Date or Text.

Open

Specify Histogram Details

To access a Histogram chart, go to Analytics > Data Analyzer > Histogram. The first tab Histogram contains the result chart. The second tab contains the data that is shown in the chart.

You can specify the Histogram details by doing the following:

1. Enter the name of the data series in the Label field (max 60 characters).

2. Choose the Data Source from the drop-down list. It can be any Pricefx data source – a Datamart, Data Feed, Simulation Datamart, Rollup or Optimization Model (DMT tables organized by Models to which they belong).

3. Select a Currency to which money data will be converted.

4. You can set up the Generic filter (all dimensions, dates and values):

   1. Click Add Generic Filter, the Generic Filter dialog will open. 

   2. Specify the filter criteria. You can combine individual rules with groups of rules as clauses and subclauses.

   3. Click Apply.

5. (Optional) Create an Aggregation filter that allows you to filter the Datamart query results, i.e., to determine, which values will be shown in the chart. You can only set this filter after X Axis has been defined. Variables (columns) calculated as contribution cannot be selected in aggregation filter.

6. Product filter allows you to select products from the drop-down list or filter by attributes from the product master data. You can use the quick filters under the table header, set up an advanced filter or select an attribute value in the table, which selects all products with the same attribute value. Attributes that are not available for filtering are grayed out.

7. Customer filter allows you to select customers from the drop-down list or filter by attributes from the customer master data. You can use the quick filters under the table header, set up an advanced filter or select an attribute value in the table, which selects all products with the same attribute value. Attributes that are not available for filtering are grayed out. Only the filtered data will be used in the analysis.

8. You can set up a Dimension filter:

   1. Select the filter dimension from the drop down list.

   2. Select the values to filter by.

   3. Add more dimensions if required. In all subsequent filters you will only be able to select values complying with all previous filters.

9. Define the axis X:

   1. Select the appropriate measurement for the axis X from the drop down list.

   2. Specify the value for the axis X. The selectable options depend on the data type. For details see Data Calculation Options.

   3. Determine how the data is aggregated.
      Select the 'Aggregation By' from the drop-down list. Only data fields marked as Dimension in the Datamart can be selected for aggregation.

10. Enter the number of Bins. Note that the analytics engine will decide on the actual number of bins by choosing rounded values for the bin limits. Hence, the actual number of bins can be different from the entered value.

11. Determine how the data is aggregated.
    Select the 'Aggregation By' from the drop-down list. Only data fields marked as Dimension in the Datamart can be selected for aggregation.
     The tooltip shows the values of the variable by which the data is aggregated only if the bucket contains no more than 3 items.

12. Define the Sort By. Click the Ascending icon to select whether the values will be sorted in ascending or descending order.

13. (Optional) Disable the Show data labels checkbox to hide the variable values in the chart.

14. (Optional) You can add additional measures:

    1. Click the Add Measure.

    2. Select a measure from the drop down list.

    3. Specify the value for the Aggregation. The selectable options depend on the data type. For details see Data Calculation Options.

    4. Select a Type. The chart type can be defined as Bar , Line  or Spline (diagram with flattened lines) .

    5. You can optionally show the measured value on the axis Z by checking the Z checkbox. This is necessary when the scale of the data of the different measurements on the y-axis differ (e.g., cash value and percentage). Enabling this option here also automatically enables Show Z-axis on the Options tab.

    6. Repeat the process until you have defined all additional readings.

15. Click the Apply and Refresh button or the Refresh icon on the toolbar to update the chart.