TDX Reports: Make a New Report

You can make a new report in TDX if none of the existing reports meet your needs. See Understand the Reporting Function in TDX for details on how to find existing reports in the tool.

Making a new report

  1. Go to the U of M Tickets application, click on the +Report button, then click on Report.
    Button for new report highlighted
  2. Select the type of report you would like to make.
    Note: Different report types provide different filters and parameters.
    List showing report types
  3. Name your report. Keep in mind best practices for naming conventions.
  4. (Optional) Add a Description for your report.
  5. Select the columns you would like to see displayed in the report results. 
    • You may add, remove, and reorder the columns to your liking.
  6. Add filtering to your report. Modify the following fields as needed:
    • Column: Select a parameter you wish to report on.
    • Operator: Select an option to act on the data. The options available may change depending on the parameter you selected.
    • Value: Enter a specific value. The options available may change depending on the parameter and operator you selected.
    • (Optional) By default TDX will use ALL the filters you add into the filtering section. Click on the green Show Advanced button to set conditional filtering using AND/OR expressions.
      • For example, you want your report to filter on Filter 1 OR Filter 2 AND Filter 3. In this case the expression would be "(1 OR 2) AND 3".
        Report Details, Add button, Add filtering to your report section with three filters set. Hide Advanced button. Text box: "Specify advanced filtering syntax using parenthesis and the boolean operators AND and OR. Refer to a filtering condition by its number in the list. For example, "(1 OR 2) AND 3". Advanced filtering field with criteria.
  7. Order your report.
    • You can select to order by any of the display columns you selected above in step 4.
  8. Set the maximum number of rows to retrieve.
    • Depending on your data, you may need to adjust this number higher or lower than the default value.
  9. (Optional) Choose a report folder (see Organize Reports in Folders).
  10. Set the visibility of the report.
    • By default, reports you create will only be visible to you.
    • At your discretion, you can instead allow specific groups to view the report, or everyone in TDX.
  11. (Optional) Add a chart.
  12. Click Save and Run.
  13. Review the results to confirm the report meets your expectations. If it doesn't, continue editing the report as necessary.
TDX ID
5744