Page 36 - Unanet GovCon: Using Analytics Studio for Project Management Reporting

5. Type 400 in the Row Height (px) field.
6. Select the Okay button.
7. Select cells C19, D19, E19, F19, G19, H19, and I19.
8. Select the Merge Cells button.
9. Select cell C19.
10. Select the Chart Wizard button. The Chart Wizard window opens.
11. Select the Combination Chart button.
12. Select the Next button.

Part 7: Add Data to the Chart
1. Select =DateCustomFormat({PRJ: Periodic JSR.Period End Date},”MM yy”)
from the X-Axis Labels dropdown list.
2. Use the information in the table to add series to the chart:

Series Value Render Type Series Name
=AggSum(If({PRJ: Periodic JSR.Cost Report Item Column Periodic Revenue
Label}=”Revenue”, {PRJ: Periodic JSR.Current
Period Hours or Amount},0))
=AggSum(If({PRJ: Periodic JSR.Cost Report Item Column Periodic Raw Cost
Label}=”Raw Cost”, {PRJ: Periodic JSR.Current
Period Hours or Amount},0))
=AggSum(If({PRJ: Periodic JSR.Cost Report Item Column Periodic Total Cost
Label}=”Total Cost”, {PRJ: Periodic JSR.Current
Period Hours or Amount},0))
=AggSum(If({PRJ: Periodic JSR.Cost Report Item Line ITD Revenue
Label}=”Revenue”, {PRJ: Periodic JSR.ITD
Amount},0))
=AggSum(If({PRJ: Periodic JSR.Cost Report Item Line ITD Raw Cost
Label}=”Raw Cost”, {PRJ: Periodic JSR.ITD
Amount},0))
=AggSum(If({PRJ: Periodic JSR.Cost Report Item Line ITD Total Cost
Label}=”Total Cost”, {PRJ: Periodic JSR.ITD
Amount},0))
3. Select the Next button.

Part 8: Format the Appearance of the Chart
1. Select the Chart Axes button. The Chart Axes window opens.
2. Type Month Ending in the Title field for X-AXIS.
3. Type Periodic Amount in the Axis Title field for Y-Axis 1.
4. Select the + Add Y Axis button.
5. Type ITD Amount in the Axis Title field for Y-Axis 2.

LESSON 3: ADVANCED REPORTING
©2022 Unanet. All rights reserved. 36