Reporting on link validity status in Report Builder

Your report already has some columns, including columns for the attributes you created conditions for.

• Add attribute columns: Select the artifact type from the list, and that the link validity attributes to add to the report.
• Select Select all checkbox if you want to select all the listed attributes and then click Add.
• Add calculated value columns: Add columns that show calculations such as averages, sums, or counts.
  1. Select the artifact type.
  2. Select the calculation to show.
  3. Select the attribute for your calculation.
  4. To add other calculated values, click Add. Otherwise, click Add and close.
• Add custom expression columns if you are a report manager, and if your data source is configured to allow report managers to edit queries: To show the data in the form that you need, you can use attributes and functions to build custom expressions.
  1. Select the artifact type from the list.
  2. Add attributes (and functions if needed) one by one, by selecting one and clicking Add.
  3. Modify the expression in the Custom expression field.

     For LQE, you can pick a frequently used function from the Choose functions list to help you choose the functions quickly without worrying about the syntax of the query language. If you add one of these functions to the custom expression, you must replace the placeholder text. In the custom expression, position the cursor at the placeholder text, choose an attribute, and click Add; then, delete the placeholder text.

  4. If your custom expression includes a function or an aggregate expression, select the Contains an aggregate expression checkbox .
     Note: Aggregate expressions calculate a single value based on a set of values such as SUM, COUNT, AVG. Each database vendor has its own set of aggregate expressions. Check the vendor documentation.
  5. Optional: Specify how to display the values. You can use the default String.
  6. Validate your expression.
  7. Click Add to include the column in the report.
• Format columns.
  • Change the column name: Type in the Column Label field.
  • Arrange columns: Click the drag handle next to the column label, and drag it to another location, or use the controls in the Actions column.
  • Adjust the column width: Click the column boundary in the table layout, and drag it into position.
  • Sort columns: Select the sort method from the Sort Type list. You can sort more than one column. To change the sort order, edit the number.
  • Color-code your report: Click in the Color section to configure rules for highlighting specific data in your report. You can add multiple coloring conditions. If several conditions target the same cells in your report, prioritize them:
    • Within the same column: Drag a condition to adjust its priority. In a list, the priority increases from first to last. The first condition is met first. The last condition can override the first one, so it has the highest priority.
    • Across all columns in your report: Use the Priority field to define the sequence to apply your conditions in. Enter a value from 1 (highest) to 9 (lowest). To give a condition the lowest priority, leave the Priority field empty.
  • Combine consecutive columns: Enter the same column label for equivalent attributes that are grouped in one condition. Using the risk status example from Set conditions, for each instance of the attribute (Risk Status in RM, Risk Status in QM, and so on), set the column label to Risk Status. When you run the report, one Risk Status column shows data from all the projects.
    Important: If the consecutive columns contain calculations, the labels are combined in the report that you export, but not on the Run Reports page.
  • Remove columns: Use the controls in the Actions column.

1. Give your report a name and a description. The description helps other team members find your report if it is public.
2. Tag your report to make it easy to find, or to group it with related reports. Each tag becomes a category on the All Reports and My Reports pages.
3. Specify how to publish the report:
   • Public (publish to catalog): The report is in the Report Builder catalog. Team members can add the report as a widget to their Jazz dashboards.
   • Private (publish to catalog and visible only to creator and owners): The report is in the Report Builder catalog. Only the report creator and owners can add the report to a dashboard and see it. Other users see the widget, but they cannot run the report.
   • Private (visible only to me): The report is available only on the My Reports page.
4. Specify whether the default visualization for your report is a table or a graph.
   For example, if you select Graph, but then run the report to generate a table, the next time you run the report, the results are shown again in a graph.
5. To improve the performance of reports that do not the need the up-to-date data, set the Result timeout in seconds field. The report displays data at the configured time. Caching is implemented for the last report result to quickly display it on dashboard, reducing the load on Lifecycle Query Engine caused by automatically triggered query executions by each dashboard refresh.
6. Click Add owner.
   Your report can have multiple owners who can modify the report, and assign other owners.
7. Click Save, and click Continue.