Create A Report

Report Center contains over 170 ready-made reports that can be customized.

Report Center has been recently updated. See the release notes.

Report Center v45200 opening screen

To create a report:

  1. Go to Reporting > Report Center.
  2. Click Create a Report in the left-hand navigation panel.
    My Reports left-hand navigation panel has been renamed to My Bookmarks. Public Reports has been renamed to Public Bookmarks.

    Report Center update v43200 Create a Report
  3. Click to select a report subject.
    Report Center v43200 report folders
  4. See how to manage Report Favorites.
  5. Manage report public URLs:
    1. Enable a public report:
      1. Click View Public URL.
      2. Click Copy to Clipboard.
      3. Click to close the pop up.
      4. Share the public URL by pasting it into another application.
        Public URLs can be viewed by anyone who opens them in a browser. It is not necessary to be logged into Plutora.
    2. Disable a public report:
      1. Click View Public URL.
      2. Click Disable.
  6. Add a new column from a formula:
    Formula help v43200 formula button

    1. Click Formula.
    2. Type the Name, which will appear in the heading of the column.
    3. Click to select a column from Insert a column.
    4. Click Insert. This selects the data column which the formula (below) will act upon and puts a shortcode (in square brackets) representing that column into the Formula field.
    5. Type a formula in the Formula field.
      See Formula Help for formula examples.
    6. Select a Data Type:
      • Number.
      • Text.
      • Date.
      • DateTime.
    7. Leave Display Format blank unless you need the data to use the following formats:
      Display Format

      • ###,###,##0.00: Number.
      • $###,###,##0.00: Currency.
      • yyyy/MM/dd.
      • yyyy/MM/dd hh:mm:ss.
      • MM/dd/yyy.
      • MM/dd/yyy hh:mm:ss.
      • Bar Gauges: A single bar graph.
      • Cell Colours:
        Slider

        • Automatically highlights true or false, or number range values in red or green.
        • Slide the slide to make the colors redder or greener.
    8. Click Add to create the new column.
    9. Update the column by updating the form and clicking Replace.
    10. Click Remove to remove the column.
  7. Filter the data:
    Formula help v43200 Filter button

    1. Click Filter.
    2. Click to select a column to filter by from Filter Column.
    3. Click to select a Comparison, for example, “=”.
    4. Type a Value.
    5. Click Add to filter the data.
    6. Update the filter by updating the form and clicking Replace.
    7. Click Remove to remove the filter.
  8. Add a chart:
    1. Click Add Chart.
      Formula help v43200 Add Chart
    2. Select a graph tab:
      Graph tabs v43200
      If the data is unsuitable for a particular kind of graph, that graph tab will be hidden.  Once you have created a graph, click and drag the resize handles to resize it.Chart resize handles v43200

      1. Pie:

        1. Click to select the Label Column.
        2. Click to select the Data Column.
        3. Click to select the Data Aggregation.
          1. Click to select Show:
            • Value.
            • Percentage.
        4. Click to select the Relevance.
      2. Bar:
        Bar graph red

        1. Click to select the Label Column.
        2. Click to select the Data Column.
        3. Click to select the Data Aggregation.
        4. Click to select the Compare Column.
          1. Click to select the format:
            • Stacked: Compare Column data as a percentage of column size.
            • Stacked by Percentage: Compare Column data as a percentage of the total graph size.
            • Side by Side: Compare Column data as a separate bar.
        5. Click to select the Bar Orientation to swap the X and Y axes.
      3. Line:
        Line graph red

        1. Click to select the X-Axis Column.
        2. Click to select the Y-Axis Column.
      4. Curved Line:
        Curved line graph red

        1. Click to select the X-Axis Column.
        2. Click to select the Y-Axis Column.
      5. Scatter Plot:
        Scatter plot graph red

        1. Click to select the X-Axis Column.
        2. Click to select the Y-Axis Column.
      6. Heatmap:
        Heatmap graph red

        1. Click to select Label Column to choose which column will supply the labels on each heatmap square.
        2. Click to select Size Column to choose which column will supply the size of the heatmap squares.
        3. Click to select Size Column Aggregation to perform calculations on the column you chose for the size column.
        4. Click to select Color Column to choose which column will be used to calculate heatmap square colors. The highest number will be represented as green, the lowest as red, and the numbers in between as orange, yellow, and pale green.
        5. Click to select Color Column Aggregation to perform calculations on the column you chose for the color column.
      7. Gauge:
        Gauge graph

        1. Click to select the graph type from Gauge Type:
          1. Arc (see above).
          2. Balloon Bar.
            Balloon Bar
          3. Bullet Bar.
            Bullet Bar
        2. Click to select the Data Column to be graphed.
        3. Click to select the Data Aggregation.
        4. Type in Min the minimum value to appear on the graph.
        5. Type the first-level goal in Goal-1, which will appear in red.
        6. Type the second-level goal in Goal-2, which will appear in amber.
        7. Type the third-level goal in Goal-3, which will appear in green.
  9. Add a crosstab:
    A crosstab (also known as a contingency table or cross tabulation) is a type of table in a matrix format that displays the (multivariate) frequency distribution of the variables.

    1. Click to select a Header Values Column, which will appear in the header row.
    2. Click to select a Label Values Column, which will appear in the left-hand column.
    3. Click to select an Aggregate Values Column, the contents of the crosstab as the Sum, Average, Standard Deviation, or Count of the Header and Label columns.
    4. Click to select an Aggregate Function, whether the data in each cell is a Count (all items counted) or Distinct Count (with each separate item counted once).
  10. Rearrange columns:
    1. Hover your mouse cursor over a column header until the sort handle appears.
      Sort handle red rectangle
    2. Drag the column by its sort handle to a new location.
  11. Resize columns:
    1. Hover your mouse cursor over a column header until the resize handle appears.
      Rearrange columns handle red rectangle
    2. Drag the handle to resize the column.
  12. Sort the data:
    Sort menu report center cogwheel red arrow

    1. Using the sort menu: Click the cogwheel-shaped Report Center sort menu cogwheel button to open the sort menu:
      Report Center sort menu

      1. Sort by Columns: Click the Columns tab:
        Report Center sort tabs red rectangle

        1. Hide and show columns by clicking to select the blue checkboxes.
        2. Click All to select all the checkboxes in one click.
        3. Click None to deselect all the checkboxes in one click.
        4. Click OK.
      2. Sort by Sort: Click the Sort tab:
        Report-Center-Sort-tab-red

        1. Click to select a Data Column.
        2. Click to select a Direction.
        3. Click Add.
      3. Sort by Group: Click the Group tab.
        Report-Center-Group-tab-red

        1. Click to select a Grouping Column.
        2. Click Add.
      4. Sort by Aggregate: Click the Aggregate tab.
        Report-Center-Aggregate-tab-red
        Use Aggregate for making calculations on numerical data or counting non-numerical data.

        1. Click to select a Data Column.
        2. Click to select an Aggregate Function:
          • Sum.
          • Average.
          • Standard Deviation.
          • Count.
          • Distinct Count.
          • Minimum.
          • Maximum.
        3. Click to select the Results Positioning:
          • Top.
          • Bottom.
        4. Click Add.
      5. Sort by Paging:
        Report-Center-Paging-tab-red

        1. Click to select one of the following radio buttons:
          1. Show all rows: No pagination.
          2. Show paging: Display a set number of rows so that the data can be easily printed.
            • Type the number of Rows per Page.
        2. Click OK.
    2. Using the header menu:
      1. Click a column header to open the sort menu:
        Sort report center column

        1. Sort A-Z: Sort in ascending order.
        2. Sort Z-A: Sort in descending order.
        3. Filter: Display the filter rows by cell values form.
        4. Group: Group by the clicked column. This column will move to the left
        5. Aggregate:
          1. Count: Count the total number of rows and put that number under the header. (For example, if the column contained the following rows the result would be 5: 3, 6, 6, 5, 1.)
          2. Distinct Count: Count the total number of distinct rows of data and put that number under the header. (For example, if the column contained the following rows the result would be 4: 3, 6, 6, 5, 1.)
        6. Format:
          1. Align Left.
          2. Align Center.
          3. Align Right.
          4. Expanded Spaces.
          5. ###,###,##0.00.
          6. $###,###,##0.00.
          7. yyyy/MM/dd.
          8. yyyy/MM/dd hh:mm:ss.
          9. MM/dd/yyyy.
          10. MM/dd/yyyy hh:mm:ss.
          11. Bar Gauges.
          12. Cell Colors.
          13. No Format: Remove formatting.
        7. Add Chart.
        8. Add Crosstab.
        9. Hide Column.
    3. Manage sort filters: Click the cogwheel-shaped Report Center sort menu cogwheelbutton to open the sort menu.
      1. Replace sort filters:
        1. Click the filter’s tab.
        2. Fill in the tab form.
        3. Click Replace to move the selections in the form to the sort filter.
      2. Remove sort filters:
        1. Click Remove.
  13. Once the report is created:
    1. Create a private report bookmark.
    2. Create a public report bookmark.
    3. Click Add to Dashboard to add the open report to your personal dashboard.
      Add to dashboard red
    4. Type the Panel Title.
    5. Type the Panel Description.
    6. Click Done.
      Or:
    7. Click to select the Add to custom dashboard panel list checkbox:

Back to the top arrow

Was this article helpful?

1 found this helpful.