Create Dynamic Data Export report (Labs)

Dynamic Data Export allows you to generate customized reports tailored to your business needs. You can combine various data insights, such as low battery events, total network usage, and app abnormal events, into a single report, eliminating the need to view reports for each insight separately. And with the ability to output your data in Table, Line graph, or Pie chart format, you can ensure that your custom reports are relevant, impactful, and understandable to both technical and non-technical audiences.

Create report

To create a Dynamic Data Export report:

1. Click Dynamic Data Export in the left navigation pane, then click CREATE REPORT in the top-right corner. If you already have reports in your console, create additional reports by clicking ACTIONS > Create a report.

2. Give your report a title and description, then select a chart type: Table, Line, or Chart.

   

Date range

3. In the Date range selector, specify the reporting window for the report.

   • For Table and Line chart types, you can also specify how you want data grouped in the Intervals field. By default, data is grouped Daily, however if you select This month, Last month, or This quarter, you also have the option to select Weekly.
   • For Custom date ranges greater than 90 days, you can only group data in Weekly intervals.

4. The Start date and End date fields will be populated automatically, based on your selected date range. Click either field to manually select a Custom date range.

   

Measures

5. In Measures and Calculations, you can define the numerical values that represent quantities or amounts of data (Measures), and the aggregation method (Calculations). For example:

   • Measures include data insights collected by Knox Asset Intelligence like Foreground run time, Background run time, or Screen time.
   • Calculations include the Average or Sum values for each data insight.

6. Click + Add measure to include additional insights, or click X to remove an insight from the report. Note that you can have up to 10 measures in a report.

   

Dimensions

7. In Dimensions, you can select the categories that describe the chosen insights in the Measures field. Note that the available dimensions options will vary depending on the chosen measures. For example:

   • Selecting app-related insights like Screen time in the Measures field would allow you to select Application name and Device models in the Dimension field, as you can categorize the amount of time a device’s screen was turned on, to a specific app name and a specific device model.

     

   • Selecting battery-related insights like Battery level at shift start in the Measures field would allow you to select Device model in the Dimension field, as there is a correlation. But selecting App version as a dimension would produce an error, as the app’s version would have nothing to do with the device’s battery levels at the start of a work shift.

     

   Additionally, the selected Dimension must contain less than 10 values for Table and Line type, and 6 values for Pie type, for the report to be generated. For example:

   • If you are creating a report with Screen time in the Measures field, and you selected Application name in the Dimension field, then the number of apps to include in the report must not exceed 10. In other words, you can only select up to 10 app names (6 app names if Pie type report) in the Filters field for this report to generate.

     

   For Line chart types, if your Dimension selection only contains a single value, then you also have the option to include multiple Measures in the report. For example:

   • You can create a report that includes Total run time, Screen time, and Normalized screen time as your Measures, and Application name as your Dimension, as long as you only select a single application name in the Filters field.

     

8. For Table type charts only, you can add additional dimensions by clicking + Add dimension. If your chosen dimension value has conflict with the selected insight in the Measure field, you’ll see an error in the tooltip. To resolve this conflict, either select a different dimension, or select different measures.

   

Filters

9. In the Filters field, click + Add filter to only include data that meets a certain criteria. For example, when selecting Screen time as your measures, you can set a filter to only display data when the average screen time for the fleet is greater than 500 hours over the selected reporting period.

   

   • For Line and Pie chart type reports, you will see a tooltip informing you of the required filter option, depending on your measures and dimension selection. You must select this required filter to generate the report, after which additional filters can be added.

     

10. Once you’re finished defining your report, click Create. You’ll return to the Dynamic Data Export page where you’ll see your report in the table with an In progress status. Once the server successfully generates the report, the status will change to Complete and you’ll see a link to download the report for offline viewing.