Add, Print, and Export A Workbook In Plutora Analytics

Workbooks in Plutora Analytics allow users to analyze and graph data from one or more data cubes.

The Analytics Admin or Analytics Analyst user permissions are required to create reports in Plutora Analytics.

1. Create a workbook

To create a workbook showing the list of Releases per Organization by Release Type:

  1. Go to:
    • Plutora: Reporting > Analytics.
    • Plutora Test: Click Plutora Analytics.

      Plutora Analytics will only open if a single instance of Plutora or Plutora Test is open in your browser. If your pop up blocker prompts you when you try to open Plutora Analytics, disable it for the site.
  2. Click Top-level Projects.
  3. Select All Data Sources.
  4. Browse for the Entity, for example, Releases:
    • The Entity might be easier to find if you toggle the View mode between grid and list.
    • Initiative Management Form Instance data is now available in Plutora Analytics: 
      • Initiative Management Form Instance data includes the following data types: Checkbox, Checkbox Group, Date Field, Number, Radio Group, Select, Text Field, and Text Area.
      • Each Initiative Management Form has its own data source containing the Form Instance data.
      • Form Instance Workflow and Status data is included.
  5. Click the three dots beside the Entity.
  6. Select New Workbook.
  7. Under Dimensions in the left-hand column, click the beside Organization to open the list of Organization fields.

     The following are now distinguished in the Deployment Plan FACT table: Master Deployment Plans, and Release ID.
  8. Drag and drop the Organization Name field into Rows:

    • Sheet 1 below Rows will populate with Organization Names.
      Custom Fields with a special character (!@#$%^*()+-=|\:/?,.&””<>{}[]_) as a label cannot be added to Plutora Analytics workbooks. 
    • If the field vanishes when you drag and drop, click the downward-pointing triangle on the right side of the field and select Add to Sheet.
    • Now, you can add record URLs to Plutora Analytic workbooks using Entity URL fields. For example, Release URL.
        • The following entities have URL fields:
          • Plutora:
            • Releases.
            • TEBRs.
            • TECRs.
            • Systems.
            • Environment Groups.
            • Deployment Plans.
          • Plutora Test:
            • Requirements.
            • Test Plans.
            • Defects.
  9. Under Dimensions in the left-hand column, click the beside Release to open the list of Release fields.
  10. Drag and drop the Release Name field into Rows to the right of the Organization Name field.

    • Sheet 1 below Rows will list Organization Names with their associated Release Names.
  11. Manage filters:
    1. Drag and drop the Organization Name field into Filters.

      The Organization Names, with checkboxes to filter them, populate on the right of the screen.
    2. Click to select or deselect checkboxes to filter whether those Organization Names appear on the sheet.
  12. Drag and drop the Release Type field into Columns.

    Sheet 1 below Rows will populate with a column for each Release Type with ABC marking the presence of data.
    Release Type uses files from the Release Type Customization.  To find out if a Release is Enterprise, Project, or Independent, use Release Title.

  13. Count the number of Releases per Release Type:
    1. From under Dimensions, drag and drop the Release Name field into Text.

      Release Name appears as a text field under the Text button.
    2. Click Release Name under the Text button and select Measure > Count Distinct.

      The count data will appear.
  14. Count the total number of Releases:
    1. Click Sum and select Show column grand totals.
    2. Click Sum again and select Column totals to top.

      The grand totals appear at the top of each column.
  15. Connect to another data cube:
    1. Click the add cube button.
    2. Click to select another cube, for example, Release Activities.
    3. Click Add data source.
      Another cube appears under Data.
    4. Click to select the new cube (if it isn’t selected already).
    5. Click the > beside the new menu to open it and show the fields from the new cube.
    6. Link the two cubes by clicking the link button beside a field. Now the fields from the new cube can be dragged and dropped like the fields from the old cube.

      To ensure correct data is displayed, only click the link buttons in the FACT tables. 

 

2. Tips and Tricks

Here are some tips and tricks to tackle any problems or quirks you might encounter:

Asterisks

  1. If you are seeing asterisks in your data tables:

    • You are using a multidimensional data source as a secondary data source.
    • To prevent this, use a ‘bottom up’ approach by adding data cubes that are lower on the hierarchy first. For example, add Release Activities cube before adding Releases cube.
    • To stop asterisks showing, clear your columns and rows and start again using the secondary data source as primary.
    • Link data cubes if necessary and all your data will appear without asterisks.

Dates and Times

Managing the appearance of dates and times in your sheets:

    • Fields that contain date and time data have a calendar clock icon. 
    • When users drag and drop a date and time field into Rows or Columns, it appears as + YEAR(Field Name).
    • To drill down further:
      • Click the plus sign  to open a QUARTER column or row.
      • Click the plus sign on QUARTER to open a MONTH column or row.
      • Click the plus sign on MONTH to open a DAY column or row.
      • Click the plus sign on DAY to open an HOUR column or row.
      • Click the plus sign on HOUR to open a MINUTE column or row.
      • Click the plus sign on MINUTE to open a SECOND column or row.
    • To drill back up, click the minus sign.
    • To reveal the full date and time:
      • Open the field menu and click Exact Date.

        Dates and times appear as a bar graph.
      • To change the bar graphs to discrete dates, open the field menu again and click Discrete.

        The bars turn to discrete dates.

Pie Charts

To create a single pie chart from TECR data:

  1. Go to:
    • Plutora: Reporting > Analytics.
    • Plutora Test: Click Plutora Analytics.

      Plutora Analytics will only open if a single instance of Plutora or Plutora Test is open in your browser. If your pop up blocker prompts you when you try to open Plutora Analytics, disable it for the site.
  2. Click Top-level Projects.
  3. Select All Data Sources.
  4. Browse for the Entity Environment Change Requests.
    The Entity might be easier to find if you toggle the View mode between grid and list. 
  5. Click the three dots beside the Entity.
  6. Select New Workbook.
  7. Open the Environment_Change_Request folder by clicking >.
  8. Drag and drop the Environment Change Request Type field into Rows.

    1. Drag and drop the TECR Number field into Rows to the right of the Environment Change Request Type field.
    2. Open the TECR Number field menu and select Measure > Count (Distinct).
    3. Select the text tables view from Show Me.
    4. Click Show Me again to close the menu.
    5. Hold down the Ctrl key on your keyboard and use your mouse to drag and drop CNTD(TECR Number) into Size.

      On the Mac, hold down the Alt-Option key.
    6. Select Pie from the Marks drop-down menu.
    7. Hold down the Ctrl (or Alt-Option on a Mac) key on your keyboard and use your mouse to drag and drop Environment Change Request Type field into Color.

      The TECR data becomes a pie chart.

 

3. Export or print the data

To export or print the data from the report above:

  1. Click the export button.
  2. Select one of the following data formats to export:
    1. Image:
      1. Click Download to download a .png image of the data.
    2. Data.
      This feature is grayed out and unavailable.
    3. Crosstab.
      This feature is grayed out and unavailable.
    4. PDF:
      1. Select the layout: Portrait or Landscape.
      2. Select the content: This Sheet or all of the Sheets in Workbook.
      3. Select a Paper Size.
      4. Leave scaling as Automatic.
      5. Click Generate.
      6. Click Download.
    5. Powerpoint.
    6. Tableau Workbook.

 

4. Convert the data to a graph

To convert the data to a graph:

  1. Click Show Me.
  2. Click to select a graph type.
    The data is turned into the selected graph with the legend on the right under the filter.

 

Back to the top arrow

Related Articles

Contents

Be the first to find out about new features. Subscribe to the Release Notes email.

Was this article helpful?

Thanks for your answer!