Page History

Configure the Pivot widget as follows:

1. Configure general common parameters (see General Common widget settings).
   Image Modified

2. Select the field that will be in the table rows (1).

3. Select the field that will be in the table columns (2).Select the field to be analyzed (3).

4. If non-numeric fields are selected, then in the Value op functionfield, select count (4) - 3). This parameter will count the number of events will be counted. If a numeric field is selected, then you can select the sum, average, minimum and maximum value. Info

   title	Note

   In the example on the image above, the summary table will display the number of events for each detection tool of each video camera.
5. If the summary table has many columns and you need it is necessary to freeze the first column when scrolling through it, then activate the Fixed 1 column parameter (54).
   Image Added

6. If necessary, configure the column with the difference in the values ​​of other columns. To do this:

   1. Activate the Delta column parameter (65).

   2. Enter the column name (76).

   3. To display only this column in the table, set the Hide others checkbox (87).

   4. In lists A and B, select the columns, between the values ​​of which you want to calculate the difference (98).

7. To highlight a row in red when the specified conditions are met, do the following:

   1. Activate the Highlight row if parameter (109).

   2. Select the column which value will be compared with the reference value (1110).

   3. Select the operation (1211).

   4. Set the reference value (1312).

      Info
      title Note
      In the example on the image above, the row will be highlighted in red if the number of events from the face detection tool is strictly more than 42,000.

   Click Save.
8. Click Save.

The Pivot widget is configured.

Image Added