Example Report: Show Composite Crew Rate

You can create a report to help you analyze the composite crew rate.

  1. From the Viewpoint Analytics Reports page, navigate to the folder for your report.
    Note: Reports in the My Reports folder are only available to the user who creates them. Reports in thePublic Reports folder are available throughout your enterprise.
    Tip: If you create a report in the My Reports folder and want to make it available in the Public Reports folder, you can open the report, select the Additional Options button , and then Copy Report to save a copy of the report to Public Reports. Note that this requires an Analytics role of Admin.
  2. Select the Add button in the upper right-hand corner.
    The Select Data Source dialog appears.
  3. Select the Cost Detail data source, and then select OK.
    The New Report page appears.
  4. Add the Job Code field to the report by double-clicking it or by dragging it to the layout pane.
  5. Filter on on the Job Code to see only the job(s) you're interested in.
    1. In the Job Code field, select the Additional Options button , and then select Filter.
    2. From the Filter on Job Code dialog, select one or more jobs in the left-hand column and either double-click, or select the > (Add Selected) button. Then select OK.
  6. Add the Cost Type field, and then filter it to display only the Cost Types for labor and equipment.
    Tip: To include a description of each Cost Type, in the Cost Type field, select the Additional Options button ,and then select Show Properties > Cost Type Description.
  7. Add the following fields to the report:
    • Projected Cost
    • Cost
    • Projected Hours
    • Hours
    These fields allow you to see projected and actual costs by hour.
  8. You can now determine the cost per hour by using a calculated measure. Right-click the Cost field in the report and select User Defined Measure > Create Calculated Measure.
    1. In the Display Name field, enter a name for the calculation (for example, "Cost Per Hour") that will appear in the report.
    2. Use the list of measures and the buttons to create a calculation. For cost per hour, select Cost, the division symbol, /, and then Hours. The calculation window should show the following: [Measures].[Cost]/[Measures].[Hours].
    3. Select OK.
  9. You can now create a second calculated measure to show the projected cost per hour. Right-click the Projected Cost field in the report and select User Defined Measure > Create Calculated Measure.
    1. In the Display Name field, enter a name for the calculation (for example, "Projected Cost Per Hour") that will appear in the report.
    2. Use the list of measures and the buttons to create a calculation. For cost per hour, select Projected Cost, the division symbol, /, and then Projected Hours. The calculation window should show the following: [Measures].[Projected Cost]/[Measures].[Projected Hours].
    3. Select OK.
    The following image shows an example of the resulting fields.

  10. Save the report.
    1. Click the Save icon.
    2. In the Filename field, enter a file name for your report.
      Note: File names cannot include spaces at the beginning or end, and cannot include forward or back slashes: /, \.
    3. Double-click the folder icon next to the Location field to navigate to a folder for the report, and then click Save.
      From the Save dialog, the My Reports folder displays the user login, and the Public Reports folder displays the name of your enterprise.
You can now use the report to analyze the project's productivity with projected costs.