Pivot Explorer Report in CloudCheckr CMx

The Pivot Explorer report, one of the new Cost reports in CloudCheckr CMx, allows you to manipulate your cost data and build meaninful visual usage trends —right in the CloudCheckr CMx interface.

In the past, you had to export the data into other tools, like Microsoft Excel, and create those extrapolations in a very tedious, time-consuming process. With the Pivot Explorer report, all the tools you need are right at your fingertips, so you can build reports much more quickly.

To access the Pivot report, you can click in the Left Navigation pane or in the Dashboard pane.

In its default state, the Pivot Explorer only shows your total cost. It's only when you modify the data using the built-in tools that the data can provide more insight on how to optimize your costs and resources.

Using the callouts as a guide, review this table to learn more about the Pivot Explorer tools:

Feature Description

1

Select to export your data into one of the following outputs: print, HTML, CSV, Microsoft Excel, image, or PDF.

2

Choose one of the following chart options: column, bar, line, scatter, pie, stacked column, column line, or you can create a chart that layers multiple chart types.

3

Select your format options such as how to align your data, what type of separator you want to use between data points, if you want to use a currency symbol, and if you want to show values as a percentage.

4

Select your layout options such as if you want to show grand totals and/or subtotals as well as if you want a compact, classic, or flat format. You can also choose if you want to include conditional formatting.

5

Click to open the Fields dialog box where you can choose from all available fields and drag an drop those fields into your report filters, chart rows, chart columns, or values.


Procedures

Click a button to learn more about the actions you can perform in the Pivot Explorer Report:

In this procedure, we will create a Pivot Explorer Report that shows that grand totals by location in a piec chart, which we will export to PDF.

  1. Click the Options icon.

    For this procedure, we chose to show the grand totals in a Classic format:

  2. Click APPLY.
  3. Click the Fields icon.

    For this procedure, we chose service as the report filter with report rows of location, type, and month.date:

  4. Click APPLY.
  5. Click the Charts icon and from the drop-down list, select Pie:
  6. Click the Export icon and select PDF from the drop-down list.
  7. From the dialog box, select the Save As File option and click OK.
  8. From the Downloads folder on your local drive, select your new PDF file.

    Here is what your pie chart looks in the exported PDF:


How did we do?