How to Create a Trending Report

Trending report allows you to monitor changes in selected metrics in relation to the previously collected data. Using the trending report feature you can get valuable insights on your videos and/or ads by seeing changes in comparison to data collected in the previous hour, day, week, month or year. 

 

To create a trending report, perform the following steps:

  1. Access the report create page by either Creating a new report or Editing an existing one.

  2. Apply filters to your report according to the steps described here: How to Apply Filters to Your Report.

    NUI_Trending_Section_301.jpg

  3. Go to the 'SECTIONS' tab. The sections tab is displayed.

  4. Select the relevant section representation type according to the following options:

    Icon Name Description
    NUI_Table.jpg Table Displays your report data in a form of a table.
    NUI_Area.jpg Area chart Displays your report data in a form of an area chart.
    NUI_Line.jpg Line chart Displays your report data in a form of a line chart.
    NUI_Columns.jpg Column chart Displays your report data in a form of a column chart.

    Note: The trending option is available only for section types listed above.

    Note: For further details, please see Report Section Type Examples.

    NUI_Trending_Section_302.jpg

  5. Enter a name for your first section in the section name field.

    Note: This will be the title of the data section representation area that is displayed at the top of the report.

  6. Click on the 'Category Filter' field and select 'Date And Time' group from the drop-down list.

  7. Drag & drop the required dimension to the selected 'DIMENSIONS' area. Alternately, you can click the plus symbol '+' on each dimension.

    Note: For a trending report, only Dynamic Date, Hour, Date, and Month dimensions are supported.

    Important! For a trending report, only one Dimension can be selected.


    Note: At least one dimension is required to create a report.

    NUI_Trending_Section_303.jpg

  8. Select the 'Add Trending' check box. A trending period field is displayed.

  9. Click on the trending period field and select the required trend period option from the drop-down list according to the following options:

    • Compare vs prior hour - Selecting this option will compare the defined dimension's data to the hour before it [current hour vs (current hour-1)].
    • Compare vs prior day - Selecting this option will compare the defined dimension to the prior day's data [current day vs (current day-1)].
    • Compare vs prior week -  Selecting this will compare the defined dimension to the prior week's data [current day vs (current day - 7)].
    • Compare vs prior month - Selecting this will compare the defined dimension to the prior month's data [current month vs (current month - 1)].
    • Compare vs prior year - Selecting this will compare the defined dimension to the prior year's data [current month vs (current month - 12)].

      NUI_Trending_Section_304.jpg

  10. Optional: Search for a Metric using the search field. Relevant search results are displayed in the Dimensions and Metrics areas.

    Note: A number will be displayed beside each area indicating how many matching results reside in each area (Dimensions/Metrics).

  11. Optional: Select a required filter value under the 'Category Filter' drop-down to review a specific group of metrics.

  12. Drag & drop the required metric to the selected 'METRICS' area. Alternately, you can click the plus symbol '+' on each metric.

    Note: Metrics that are active for Trending will have a 'T' indicator. You may select more than one metric for the trending report.

    Note: At least one metric is required to create a report.

    NUI_Trending_Section_305.jpg

  13. Go to the 'DIMENSIONS' area and click on the sorting arrow icon (NUI_Arrow_button.jpg) to set the order of the data as either ascending or descending.

    Note: Each click on the sorting arrow icon cycles through the three supported states: ascending, descending and none (Arrow up = Ascending, Arrow down = Descending).

  14. Go to the 'METRICS' area and make sure that the order of the data defined with the sorting arrow icon (NUI_Arrow_button.jpg) is set to none.

    Note: Each click on the sorting arrow icon cycles through the three supported states: ascending, descending and none (Arrow up = Ascending, Arrow down = Descending).

  15. Optional: Rearrange your dimensions and/or metrics by dragging them to define their display order when running the report.

  16. Click on the trending indication icon (Trending_icon.jpg) within each metric to activate/disable the relevant trend information in relation to the selected trending period you defined.

    Important! At least one trending metric must be selected.

    Note: A blue indication means that trend information will be displayed, while a gray indication means that trend information is disabled.

    NUI_Trending_Section_306.jpg

  17. Click on 'SAVE SECTION'. Your section settings are saved.

    NUI_Trending_Section_307.jpg

  18. Optional: Add additional Sections to your report by clicking on 'Add New Section' and repeat steps 4 to 17.

  19. Click on one of the following options to save your report:
    • SAVE - Selecting this option will save your report and remain in the report edit mode.
    • SAVE & RUN - Selecting this option will save your report and redirect you to the run report screen.

      Note: If you have selected Save & Run, please continue to How to Run a Report.
Have more questions? Submit a request