Hiding rows and columns in Explore reports

What's my plan?

Suite

Professional, Enterprise, or Enterprise Plus

Support with

Explore Professional or Enterprise

When you create result manipulations, there might be parts of your report that need to be there to ensure the calculation is correct, but that you don't need to display. You can hide empty columns or rows.

For example, if you use a result path calculation to display the difference in results over time, the first reference result will be empty (the Q1 2015 column in the image below). You can hide it, resulting in a cleaner-looking chart.

This article covers the following topics:

• Hiding rows and columns
• Hiding columns without an attribute in the Columns panel
• Hiding columns in reports with multiple metrics
• Hiding rows when metrics are displayed on rows

Hiding rows and columns

To hide rows or columns

1. In the report builder, click the Result manipulation icon ().
2. Select Hide part of your result.
3. Enter the number of first and last results you want to hide. Alternatively, you can type in specific rows or columns.

   

4. Click Apply. Hide results is automatically be added to the Filters panel.

Hiding columns without an attribute in the Columns panel

If you haven’t added an attribute in the Columns panel, hiding any number of columns using the Hide part of your result menu will return a blank screen. This happens because this menu affects only columns generated by attributes added in the Columns panel of the report builder.

Instead, if you don’t have any attributes in the Columns panel and you're using the Table visualization, you can use Chart configuration > Columns to remove any columns you don’t want. For more information, see Working with tables.

Hiding columns in reports with multiple metrics

When you use the Hide part of your result menu to hide columns, the number of hidden columns refers to the columns generated by the attribute values, not the metrics.

What this means is that, in the image below, each of the blue boxes below is considered a single column, because all the information is being generated by a single value of the Ticket status attribute.

Hiding rows when metrics are displayed on rows

Similarly, if you have the Metrics on rows setting selected, hiding rows using the Hide part of your result menu may appear to hide more rows than you initially expect.

In the image below, each of the blue boxes is considered a single row. This happens because the Metrics on rows setting is selected. Without that setting selected, the two metrics in the report—Tickets and Solved tickets—would appear on the same row.