Report Designer

The Report Designer is used to create new reports that are not part of the core reporting solution. It can be used against any flow template even when byte counts are not available. These new report types only appear on devices that are exporting the necessary elements in templates. The steps to design a new report:

  1. Copy an existing report design or select ‘New’.

  2. Enter a name for the new report design.

  3. Select a device that is exporting the template that is needed for the report.

  4. Select a template from the device. After selecting a template, click [Open Raw Flows] to verify that the element is contained in the template.

  5. Select an element in the template for the first column.

    1. Specify the column name. It is best to try and keep it short. Often the name entered is similar to the Report Field name.

    2. Specify the treatment.

      • Average: takes the average of the total (total values divided by the number of matches).
      • Count: Counts the number of entries in consideration of the ‘group by’ columns.
      • Count Distinct: Counts the number of entries in consideration of the ‘group by’ columns, but if a matching flow shows up more than once, it is only counted once.
      • Max: Display the maximum value.
      • Min: Display the minimum value.
      • Sum: Adds up the values
      • Group By: Group the matching values together.
    3. Rate vs. Total

      • Rate : trend the data by rate per second. Total will not be an option in the drop down box after the report is run.
      • Total : trend the data by total per interval. Rate will not be an option in the drop down box after the report is run.
      • Rate (default) / Total : trend the data by rate per second. Total is an option in the drop down box after the report is run.
      • Rate / Total (default) : trend the data by total per interval. Rate is an option in the drop down box after the report is run.
    4. Stack or Unstacked

      • Stacked : trend the data as a stacked trend. Non Stacked is not an option in the drop down box after the report is run.
      • Non Stacked : trend the data as an unstacked trend. Stacked trend is not an option in the drop down box after the report is run.
      • Stacked (default) / Non Stacked : trend the data as a stacked trend. Non Stacked is an option in the drop down box after the report is run.
      • Stacked / Non Stacked (default) : trend the data as an unstacked trend. Stacked trend is an option in the drop down box after the report is run.

The new report will show up in the run report menu in a category named “Designed Reports” when the template(s) from the device contain the elements necessary for the report.

NOTES:

  • The report will not work outside of one minute intervals if rollups are not being performed on the template in a format that is supportive of the report created.
  • The columns can be reordered. Grab a row in the table with the mouse and move it up or down, then release it.