Rich table section type - details

Applies to NAM 2018

This section type creates a lightweight table (simple columns of data), but each row is expandable to show more information. Within each row, you can nest report subsections of the following types:

Your rich table section will display a simple table showing columns for the selected dimensions and metrics, but there will be an added expand control in the More column on the right. (You can actually click anywhere in a row to expand the row. The More column is just there to indicate that you can expand a row.) Expand a row to see the child sections for that row.

Examples of rich table sections in our reports:

  • Open Applications > Health dashboard, then select Show health details in the Application health trend over time.
    The Details report uses a rich table for the list of applications. Expand a row in that table to display the child sections (charts, color counters, and dimension tiles) defined for that rich table section.
  • Open Explore > Alerts to open the Alerts explorer. The Alert log details table is a rich table. Expand a row in that table to display the child sections (metric tiles and dimension tiles) defined for that rich table section.
  • Open Explore > Operation sequences to open the Sequence explorer. The Operation sequences table is a rich table. Expand a row in that table to display the child sections (metric tiles and dimension tiles) defined for that rich table section.

Requirements

  • Set Display name to the name of the section
  • Set Section type to Rich table
  • Select at least one dimension
  • Select at least one metric

Example: from start to finish

Let's create a new report from start to finish, with every step listed to create a table that has expandable rows to show metrics you want to optionally show for each row.

  1. On the NAM Server menu, select DMI > New report to open the report editor to an empty section edit page on the Data tab for this new section of your new report.

  2. Set Display name to My rich table section. This will be the label for this section (your table with expandable rows).

  3. Set Section type to Rich table.

    The Rich table tab is added to the row of tabs in the editor, but we don't need to go there just yet. Stay on the Data tab.

  4. With Data view set to the default (Software service, operation, and site data), click the edit control and select some data for your report.

    • Click Dimensions and select Software service. This is going to be a simple table of software services, but we are going to add expandable charts to each row.
    • Click Metrics and add metrics Availability (TCP) and Availability (application).

    Now your table will have columns for Software service, Availability (TCP), and Availability (application).

  5. Now you can click the Rich table tab to show editing options specific to a rich table.

  6. Set Select detail items to Software service. (You can select any combination of displayed items here, but let's stick with Software service for this example.)

  7. Click Add new to add the first of two child sections we are going to have for each row.

    1. Set Name to My TCP availability chart (this is a free-form label) and Type to Chart (the default setting).
    2. Click the Edit control for this row to open the section editor for this child section.
    3. Click Metrics and select Availability (TCP) (because that's what we want this child section's chart to show).
  8. In the breadcrumbs row at the top, click the name of your rich table section (My rich table section in this example) to go back up to editing your rich table section.

  9. Click the Rich table tab to show editing options specific to a rich table section again.

  10. Click Add new again to add another child section per row.

    1. Set Name to My application availability chart and Type to Chart again.
    2. Click the Edit control for this row (the second child in this example) to open the section editor for this child section.
    3. Click Metrics and select Availability (application) this time (because that's what we want the second child section's chart to show).
  11. Click Display report to see your progress.

    The report opens with:

    • My rich table section at the top (it's the only main section we defined in this report, though each row actually has two subsections)
    • Within that section, a table showing columns for Software service, Availability (TCP), and Availability (application)
    • A More column on the right to indicate that you can expand any row
  12. Click a row to expand it and show:

    • Software service and the selected software service name appear as a heading. This is what we defined for Select detail items. If you selected a different combination of dimensions and metrics for this, they would be displayed here above the charts for this row.
    • My TCP availability chart shows a chart for the metric we selected for this child section (Availability (TCP)).
    • My application availability chart shows a chart for the metric we selected for this child section (Availability (application)).
  13. Click the row again to hide the charts.

Example: NAM Health dashboard > Details report

To see how we use rich tables to good effect in our own NAM reports:

  1. Open the NAM Server menu and select Applications > Health dashboard to display the Health dashboard.
  2. In the Application health trend over time section, select the Show health details button to display the Details report.

On this report, the table lists one application per row, with a More column on the right. Select any row in the table to expand that row.

Unexpanded rich table:

NAM rich table: unexpanded row

First row expanded:

NAM rich table: expanded row

Examining the section definition:

To see how that section was defined, open the section for editing in DMI. The Rich table tab lists all the child sections.

  • Note that we use conditional statements (Visible is set to Conditional) to determine whether to display a child section when you expand a row, which is why you may not see all children in the definition when you open a report row.
  • To see how a child section is defined, either click in the Edit column for that child or select it child from the Show section list for this report (all child sections in that list are indented below the rich table they are part of).

NAM rich table: table definition

Examining a child definition:

Remember that each child definition will be one of five possible types. In this example, we have defined a chart labeled Reasons for slowness. You can use the other tabs in this definition to see how we selected the data and so on.

NAM rich table: child definition