Building Reports: Derived Reports

Building Reports: Derived Reports

Follow these instructions to build a derived report:

  1. Open the source report you’d like to use as the data source for your derived report
  2. Click on the “Actions” button in the top left section, to the left of the search box
  3. On the drop down menu that appears, select “Create derived report” 

  4. On the “New Derived Report” screen that appears, enter the following
  5. Basic information
    1. Report Name - Enter a report name
    2. Filters - Optional. Add any filters to be applied to this derived report.
  6. Extraction / Grouping - In this section you’ll be selecting the columns you’d like to include in your derived report and applying data transformations as needed.

    1. Name - Select the column from the data source 
    2. Process - Select the data transformation you’d like to apply to your selected column. Here are the various types of data transformations:
      1. No process - Default
      2. Querystring extraction - Extract a part of the string value found in the selected column
      3. Substring - Extract a part of the string value found in the selected column
      4. Substring replace - Basically a find and replace transformation, enter the starting value to find and velue to be replaced with in the selected column
      5. Values - Enter the text value (in quotes) to be counted in the selected column
      6. URL path
      7. Date - Transforms and extracts only the date of the value in the selected column
      8. Date/Time - Transforms and extracts only the date and time of the value in the selected column
      9. Time - Transforms and extracts only the time of the value in the selected column
      10. Year - Transforms and extracts only the year of the value in the selected column
      11. Month - Transforms and extracts only the month of the value in the selected column
      12. Week - Transforms and extracts only the week of the value in the selected column
      13. Json parameter - Enter the parameter name for the value to be extracted 
      14. Avg - Averages the values of the selected column
      15. Min - Displays the minimum value of the selected column
      16. Max - Displays the maximum value of the selected column
      17. Sum - Aggregates the numeric values of the selected column
      18. Count - Counts the entries of the selected column
      19. Cardinality
    3. Derived Column - Enter the name of the column to appear in the final report. By default this will be the original column name from the source report.
  7. Metrics - In this section you’ll be defining calculated metrics

    1. Name - Enter the name of the calculated metric
    2. Calculation - Enter the column names and the formula. Use the following:
      1. Addition: +
      2. Subtraction: -
      3. Multiplication: *
      4. Division: /
  8. Click "Save" to generate the report.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us