{ "SourceType": 0, "LinkedToId": "00000000-0000-0000-0000-000000000000", "Tabs": [ { "Id": "5b26e7a4-7839-4c61-b4fd-cb0b122496d8", "Name": "(01) Portfolio Dashboard", "TabType": 1, "IsPersonal": false, "Widgets": [ { "Id": "3cb35922-8cfc-d9f4-f439-16682490b529", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Budget", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "Budget", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "1000", "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "199d858a-691c-a0e4-f1e6-0ed0386a8294", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 130, "Title": "Budget by Investment Category", "URL": null, "SizeX": 4, "SizeY": 3, "Row": 1, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "Budget", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Goals", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "906ef7e9-52a0-58f0-0fe4-9dc6a268a76c", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 20, "Title": "Portfolios", "URL": null, "SizeX": 12, "SizeY": 3, "Row": 4, "Col": 0, "DataFilters": { "condition": "AND", "rules": [ { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "f3c89b1f-897a-4c3e-ae2d-23d58e461346", "type": "string", "isDefined": null, "isDefinedCondition": null } ], "id": null, "field": null, "operator": null, "value": null, "type": null, "isDefined": null, "isDefinedCondition": null }, "Fields": [ { "Name": "PlannerTypeId", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Name", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "State", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Status", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "ProjectType", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Budget", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Forecast", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Actuals", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Benefits", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "ROI", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": "Name", "IsAscending": true, "Aggreate": null, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": true, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "5a5e2d5e-ea5c-bc1f-5613-5508854a3ffd", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Actuals", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 2, "DataFilters": null, "Fields": [ { "Name": "Actuals", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "11a77125-c829-72e0-8b62-c05f351c8e12", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Remaining Budget", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 4, "DataFilters": null, "Fields": [ { "Name": "RemainingBudget", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "1000", "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "e918007e-69b2-f40c-ebee-29a53779ff5d", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 135, "Title": "Budget by Business Unit", "URL": null, "SizeX": 4, "SizeY": 3, "Row": 1, "Col": 4, "DataFilters": null, "Fields": [ { "Name": "Budget", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "40c664c5-44b3-17df-6a54-8d2137f2d0e5", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Budget Variance", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 6, "DataFilters": null, "Fields": [ { "Name": "BudgetVariance", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "1000", "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "0161e7f9-5611-0553-bab2-10837458e100", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Benefits", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 8, "DataFilters": null, "Fields": [ { "Name": "Benefits", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "1000", "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "4cb76c70-a3f5-20f1-c2ac-edab17c71525", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 15, "Title": "Actual vs. Budget", "URL": null, "SizeX": 4, "SizeY": 3, "Row": 1, "Col": 8, "DataFilters": null, "Fields": [ { "Name": "Actuals", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": "manual", "GaugeMin": 0.0, "GaugeMaxField": "Budget", "GaugeMax": 100.0, "GaugeUnits": "currency", "GaugeRanges": [ { "Label": "Poor", "Color": "#F50A0A", "Min": 0.0, "Max": 631152.83 }, { "Label": "Fair", "Color": "#FB7F7F", "Min": 631152.83, "Max": 1262305.67 }, { "Label": "Average", "Color": "#FFF557", "Min": 1262305.67, "Max": 1893458.5 }, { "Label": "Good", "Color": "#C9FF21", "Min": 1893458.5, "Max": 2524611.34 }, { "Label": "Excellent", "Color": "#43C714", "Min": 2524611.34, "Max": 4280501.67 } ] }, { "Id": "74ff63aa-14b8-608f-45ad-02fae64f7082", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "ROI", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 10, "DataFilters": null, "Fields": [ { "Name": "ROI", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 15, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null } ], "Slicers": [ { "Field": "Goals", "RequiredSlicer": null }, { "Field": "BusinessUnit", "RequiredSlicer": null }, { "Field": "ProjectType", "RequiredSlicer": null }, { "Field": "State", "RequiredSlicer": null } ], "DataFilters": [ { "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "DataFilters": { "condition": "OR", "rules": [ { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "f3c89b1f-897a-4c3e-ae2d-23d58e461346", "type": "string", "isDefined": null, "isDefinedCondition": null } ], "id": null, "field": null, "operator": null, "value": null, "type": null, "isDefined": null, "isDefinedCondition": null } } ] }, { "Id": "21ea1c9e-c600-4454-ad6a-2aea66f09102", "Name": "(02) Project Health Dashboard", "TabType": 1, "IsPersonal": false, "Widgets": [ { "Id": "ee3dbc48-75e2-1e09-0558-f1af0b2dbb83", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Tasks In Progress", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "TasksinProgress", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "3b3a0c72-7abd-fba9-1e2d-00ce4bb2614d", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Active Issues", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 1, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "ActiveIssues", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "93786256-46ca-f2ad-3f25-df2767cba50b", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Active Risks", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 2, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "ActiveRisks", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "bbdfd9b3-8ef9-7141-9132-49054d999a81", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "Active Changes", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 3, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "ActiveChanges", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "cc1663c6-b2ba-3ba0-4c5a-d21e2b2cbded", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 160, "Title": "Investment Category by Status w/ Active Risk", "URL": null, "SizeX": 12, "SizeY": 3, "Row": 4, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "ActiveRisks", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "Status", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": [ { "Name": "Goals", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": true, "ColorGradient": "RedYellowGreen", "IntensityScaling": "Linear", "InvertColors": true, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "90c9b93d-03ac-7607-a95a-ac508e3301e7", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 20, "Title": "Plans", "URL": null, "SizeX": 12, "SizeY": 6, "Row": 7, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "PlannerTypeId", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Name", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "State", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Status", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "ProjectType", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "EstimatedStart", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "EstimatedEnd", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Budget", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Forecast", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Actuals", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "Benefits", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "ROI", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": "Name", "IsAscending": true, "Aggreate": null, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": null, "ShowTitle": true, "ShowBorder": false, "ShowTotals": true, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "4babb837-f4b3-197d-38a4-3252a430c9d0", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 135, "Title": "Overall Health", "URL": null, "SizeX": 5, "SizeY": 2, "Row": 0, "Col": 2, "DataFilters": null, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "Status", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "42c1057a-1b05-1526-b077-f429f541ad2b", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 110, "Title": "By Priority", "URL": null, "SizeX": 5, "SizeY": 2, "Row": 2, "Col": 2, "DataFilters": null, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Priority", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "1e097463-e66d-11d3-1da3-ea1abbe62d12", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 130, "Title": "Plans By Business Unit", "URL": null, "SizeX": 5, "SizeY": 2, "Row": 0, "Col": 7, "DataFilters": null, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "f4e36e3f-a19f-dcce-cc70-5e1f399ce678", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 135, "Title": "By Investment Category", "URL": null, "SizeX": 5, "SizeY": 2, "Row": 2, "Col": 7, "DataFilters": null, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "Goals", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null } ], "Slicers": [ { "Field": "BusinessUnit", "RequiredSlicer": null }, { "Field": "State", "RequiredSlicer": null } ], "DataFilters": [ { "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "DataFilters": { "condition": "OR", "rules": [ { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "f2944753-635e-4a4c-bf52-d62f19649c3a", "type": "string", "isDefined": null, "isDefinedCondition": null }, { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "ea956d36-1e9e-4021-9452-80bb4fc4df8e", "type": "string", "isDefined": null, "isDefinedCondition": null }, { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "0a9a5786-a1d8-46cb-bb54-3b5ec7071768", "type": "string", "isDefined": null, "isDefinedCondition": null } ], "id": null, "field": null, "operator": null, "value": null, "type": null, "isDefined": null, "isDefinedCondition": null } } ] }, { "Id": "c627846f-ff94-45b4-8222-807f60ecc484", "Name": "(03) Financial Dashboard", "TabType": 1, "IsPersonal": false, "Widgets": [ { "Id": "98a96a7f-addd-4590-97a5-d2ed80c9e887", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 110, "Title": "Budget by Quarter", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 0, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "215170e0-b0b9-4438-b2be-e6ffd371665f", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 110, "Title": "Actuals by Quarter", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 3, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_4745acb9-7203-41a4-b74d-c8b9ce6dc53d", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "3d3fa1af-d834-9085-3038-4213d920d5cc", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 30, "Title": "Budget by Category & Year", "URL": null, "SizeX": 12, "SizeY": 2, "Row": 6, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "Plan_Goals", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": [ { "Name": "Cost_Date_Quarter", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": false, "Aggreate": null, "DisplayUnit": null, "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": false, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "078f2c97-eaae-4f0c-9b45-47a1d3bbb8fe", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 110, "Title": "Forecast by Quarter", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 0, "Col": 6, "DataFilters": null, "Fields": [ { "Name": "CostType_68165839-e487-4fb2-a6d6-311bee0b6e8b", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "c8471133-05c5-4954-89ab-c6ed2260a14e", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 110, "Title": "Benefits by Quarter", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 3, "Col": 6, "DataFilters": null, "Fields": [ { "Name": "CostType_8683c061-5667-488c-8d48-110cf28a71b8", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": false, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null } ], "Slicers": [ { "Field": "DateRangePicker", "RequiredSlicer": "false" }, { "Field": "Goals", "RequiredSlicer": "false" }, { "Field": "BusinessUnit", "RequiredSlicer": "false" }, { "Field": "State", "RequiredSlicer": "false" }, { "Field": "ProjectType", "RequiredSlicer": "false" } ], "DataFilters": [] }, { "Id": "e4b2f2ca-0dde-472e-9401-d805511d4fed", "Name": "(04) Financial Comparisons", "TabType": 1, "IsPersonal": false, "Widgets": [ { "Id": "993938a8-ca52-2c18-12bd-1fb2bace4cb3", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 155, "Title": "Forecast vs Budget", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 0, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_68165839-e487-4fb2-a6d6-311bee0b6e8b", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "CostType_b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "ColumnType": 3, "DisplayAs": 1, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 1, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "25886c16-192b-1bd2-02f5-0758f5cf79e0", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 155, "Title": "Budget vs Benefits", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 3, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_8683c061-5667-488c-8d48-110cf28a71b8", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "CostType_b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "ColumnType": 3, "DisplayAs": 1, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 1, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "ad104e02-3f49-7d21-c35a-0f0d615c0d3a", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 155, "Title": "Budget vs Actuals", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 0, "Col": 6, "DataFilters": null, "Fields": [ { "Name": "CostType_b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "CostType_4745acb9-7203-41a4-b74d-c8b9ce6dc53d", "ColumnType": 3, "DisplayAs": 1, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 1, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "8b2d5197-3775-116d-9ed9-74bfbe44f4f3", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437402", "WidgetType": 155, "Title": "Cumulative Budget by Quarter", "URL": null, "SizeX": 6, "SizeY": 3, "Row": 3, "Col": 6, "DataFilters": null, "Fields": [ { "Name": "CostType_b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "ColumnType": 3, "DisplayAs": 0, "DataTableId": 0 }, { "Name": "CostType_68165839-e487-4fb2-a6d6-311bee0b6e8b", "ColumnType": 3, "DisplayAs": 1, "DataTableId": 0 }, { "Name": "CostType_4745acb9-7203-41a4-b74d-c8b9ce6dc53d", "ColumnType": 3, "DisplayAs": 1, "DataTableId": 0 } ], "GroupBy": null, "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "3", "SortBy": null, "IsAscending": null, "Aggreate": 6, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 1, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null } ], "Slicers": [ { "Field": "DateRangePicker", "RequiredSlicer": null }, { "Field": "Goals", "RequiredSlicer": null }, { "Field": "BusinessUnit", "RequiredSlicer": null }, { "Field": "State", "RequiredSlicer": null }, { "Field": "ProjectType", "RequiredSlicer": null } ], "DataFilters": [] }, { "Id": "45267159-be72-457a-ace2-cdcc402b98c9", "Name": "(05) Resource Dashboard", "TabType": 1, "IsPersonal": false, "Widgets": [ { "Id": "4b35df17-fdeb-be4c-1597-eb0447eab7c4", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "# of Portfolios", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 0, "Col": 0, "DataFilters": { "condition": "AND", "rules": [ { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "f3c89b1f-897a-4c3e-ae2d-23d58e461346", "type": "string", "isDefined": null, "isDefinedCondition": null } ], "id": null, "field": null, "operator": null, "value": null, "type": null, "isDefined": null, "isDefinedCondition": null }, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": "0", "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "37b8cf0a-0d4b-d61e-80ae-01453062b7c3", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "# of Programs", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 1, "Col": 0, "DataFilters": { "condition": "AND", "rules": [ { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "d73d864d-9370-4785-b94e-b9e57e731f6b", "type": "string", "isDefined": null, "isDefinedCondition": null } ], "id": null, "field": null, "operator": null, "value": null, "type": null, "isDefined": null, "isDefinedCondition": null }, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": "0", "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "faee6d70-b2e1-1024-8e42-17da7adb5ec9", "DataSourceOptionId": "31bb513b-4d19-4173-8256-ceef66437401", "WidgetType": 10, "Title": "# of Projects", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 2, "Col": 0, "DataFilters": { "condition": "OR", "rules": [ { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "f2944753-635e-4a4c-bf52-d62f19649c3a", "type": "string", "isDefined": null, "isDefinedCondition": null }, { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "ea956d36-1e9e-4021-9452-80bb4fc4df8e", "type": "string", "isDefined": null, "isDefinedCondition": null }, { "id": "PlannerTypeId", "field": "PlannerTypeId", "operator": "equal", "value": "0a9a5786-a1d8-46cb-bb54-3b5ec7071768", "type": "string", "isDefined": null, "isDefinedCondition": null } ], "id": null, "field": null, "operator": null, "value": null, "type": null, "isDefined": null, "isDefinedCondition": null }, "Fields": [ { "Name": "id", "ColumnType": 0, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 10, "DisplayUnit": "0", "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "31577b37-d93e-9331-41ec-db87b807609b", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 10, "Title": "Committed Hours", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 3, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_42bb3a83-8407-4743-9727-ab2f0123a750", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "1000", "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "426321d1-2f3c-cdc0-bbde-dd38a46a388a", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 10, "Title": "Scheduled Hours", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 4, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_136905cc-2f86-4646-b5c3-8364b4ec493c", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "1000", "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "bdd948bb-99bf-0b19-0e08-0284b576aebe", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 10, "Title": "Timesheet Hours", "URL": null, "SizeX": 2, "SizeY": 1, "Row": 5, "Col": 0, "DataFilters": null, "Fields": [ { "Name": "CostType_905f787c-64a3-40f5-b41b-f2807e724c87", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": null, "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": "0", "DecimalCount": null, "ChartLabel": null, "ShowTitle": true, "ShowBorder": null, "ShowTotals": null, "ShowLegend": null, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "a78a8ed2-288b-2e63-78f1-24f34ed4e0c6", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 140, "Title": "Committed by Business Unit", "URL": null, "SizeX": 5, "SizeY": 3, "Row": 0, "Col": 2, "DataFilters": null, "Fields": [ { "Name": "CostType_42bb3a83-8407-4743-9727-ab2f0123a750", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": [ { "Name": "Cost_Date", "ColumnType": 1, "DisplayAs": 0, "DataTableId": 0 } ], "SizeField": null, "DateFormat": "2", "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 1, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "33fc9c17-e5a2-f9d3-fe12-e6b31357462a", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 135, "Title": "Scheduled Hours by Business Unit", "URL": null, "SizeX": 5, "SizeY": 3, "Row": 3, "Col": 2, "DataFilters": null, "Fields": [ { "Name": "CostType_136905cc-2f86-4646-b5c3-8364b4ec493c", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "138efc62-3216-039a-bccc-bc57d34892ea", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 135, "Title": "Committed Hours by Business Unit", "URL": null, "SizeX": 5, "SizeY": 3, "Row": 0, "Col": 7, "DataFilters": null, "Fields": [ { "Name": "CostType_42bb3a83-8407-4743-9727-ab2f0123a750", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null }, { "Id": "fae44d99-1e44-5117-cc00-3e01c9c91052", "DataSourceOptionId": "31bb513b-4d19-4173-8257-ceef66437403", "WidgetType": 135, "Title": "Timesheet Hours by Business Unit", "URL": null, "SizeX": 5, "SizeY": 3, "Row": 3, "Col": 7, "DataFilters": null, "Fields": [ { "Name": "CostType_905f787c-64a3-40f5-b41b-f2807e724c87", "ColumnType": 2, "DisplayAs": 0, "DataTableId": 0 } ], "GroupBy": [ { "Name": "BusinessUnit", "ColumnType": 5, "DisplayAs": 0, "DataTableId": 0 } ], "XFields": null, "SizeField": null, "DateFormat": null, "SortBy": null, "IsAscending": null, "Aggreate": 5, "DisplayUnit": null, "DecimalCount": 0, "ChartLabel": 10, "ShowTitle": true, "ShowBorder": false, "ShowTotals": null, "ShowLegend": true, "ColorGradient": null, "IntensityScaling": null, "InvertColors": null, "AdvancedGradient": null, "GaugeMinField": null, "GaugeMin": null, "GaugeMaxField": null, "GaugeMax": null, "GaugeUnits": null, "GaugeRanges": null } ], "Slicers": [ { "Field": "DateRangePicker", "RequiredSlicer": null }, { "Field": "OP_Financial_ResourceType", "RequiredSlicer": null }, { "Field": "BusinessUnit", "RequiredSlicer": null } ], "DataFilters": [] } ], "References": { "Fields": [ { "InternalName": "ActiveChanges", "DisplayName": "Active Changes", "ColumnType": 2, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "ActiveIssues", "DisplayName": "Active Issues", "ColumnType": 2, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "ActiveRisks", "DisplayName": "Active Risks", "ColumnType": 2, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Actuals", "DisplayName": "Actuals", "ColumnType": 3, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Benefits", "DisplayName": "Benefit Target", "ColumnType": 3, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Budget", "DisplayName": "Budget", "ColumnType": 3, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "BudgetVariance", "DisplayName": "Budget Variance", "ColumnType": 3, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "BusinessUnit", "DisplayName": "Business Unit", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Cost_Date", "DisplayName": "Date", "ColumnType": 1, "FieldCategory": "Timesheet", "DataTableId": 6 }, { "InternalName": "DateRangePicker", "DisplayName": "Date Range", "ColumnType": 1, "FieldCategory": "Slicer", "DataTableId": 2 }, { "InternalName": "EstimatedEnd", "DisplayName": "Estimated End", "ColumnType": 1, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "EstimatedStart", "DisplayName": "Estimated Start", "ColumnType": 1, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Forecast", "DisplayName": "Forecast", "ColumnType": 3, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Goals", "DisplayName": "Investment Category", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "id", "DisplayName": "(Id)", "ColumnType": 0, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Name", "DisplayName": "Name", "ColumnType": 0, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "OP_Financial_ResourceType", "DisplayName": "Non-Labor Type (Resource)", "ColumnType": 5, "FieldCategory": "Resource", "DataTableId": 5 }, { "InternalName": "Plan_Goals", "DisplayName": "(Plan) Investment Category", "ColumnType": 5, "FieldCategory": "Financials", "DataTableId": 0 }, { "InternalName": "PlannerTypeId", "DisplayName": "Plan Type", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Priority", "DisplayName": "Priority", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "ProjectType", "DisplayName": "Type", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "RemainingBudget", "DisplayName": "Remaining Budget", "ColumnType": 3, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "ROI", "DisplayName": "ROI", "ColumnType": 2, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "State", "DisplayName": "State", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "Status", "DisplayName": "Status", "ColumnType": 5, "FieldCategory": "Plan", "DataTableId": 0 }, { "InternalName": "TasksinProgress", "DisplayName": "# of Tasks In Progress", "ColumnType": 2, "FieldCategory": "Plan", "DataTableId": 0 } ], "CostTypes": [ { "Id": "4745acb9-7203-41a4-b74d-c8b9ce6dc53d", "Name": "Actual Cost", "IsRequired": true }, { "Id": "8683c061-5667-488c-8d48-110cf28a71b8", "Name": "Benefits", "IsRequired": true }, { "Id": "b9bfed2a-c5cd-4e8c-8d21-460ec50ac442", "Name": "Budget", "IsRequired": true }, { "Id": "42bb3a83-8407-4743-9727-ab2f0123a750", "Name": "Committed", "IsRequired": true }, { "Id": "68165839-e487-4fb2-a6d6-311bee0b6e8b", "Name": "Forecast Cost", "IsRequired": true }, { "Id": "136905cc-2f86-4646-b5c3-8364b4ec493c", "Name": "Scheduled", "IsRequired": true }, { "Id": "905f787c-64a3-40f5-b41b-f2807e724c87", "Name": "Timesheets", "IsRequired": true } ], "PlanTypes": [ { "Id": "2bd4a777-177c-415a-a783-80e1adb4707e", "Name": "Account" }, { "Id": "91eb879f-a7be-436f-a482-a06ce30b3d86", "Name": "Application" }, { "Id": "ed9d52e0-5e86-4a46-911c-ffcd28fd0f80", "Name": "Benefit" }, { "Id": "051b8118-ee17-4d09-b634-650d8d199577", "Name": "Business Capabilities" }, { "Id": "f6bd99ff-b078-45e5-8eef-66bd0aaf31fe", "Name": "Business Need" }, { "Id": "49290724-31e0-4c7e-8610-3c3770ffd4ee", "Name": "Challenge" }, { "Id": "0a9a5786-a1d8-46cb-bb54-3b5ec7071768", "Name": "Engagement" }, { "Id": "cb82c4e6-2b6f-4060-b817-4d85480347e5", "Name": "Enterprise Risk" }, { "Id": "ea956d36-1e9e-4021-9452-80bb4fc4df8e", "Name": "Epic" }, { "Id": "73f50e0c-fb25-4b66-b529-4d8e80f4a827", "Name": "Idea" }, { "Id": "e5bcdf62-600c-4b8c-98e7-4beffabe4d21", "Name": "Key Result" }, { "Id": "d82475a1-7712-4419-a5ce-bd9d9b815ba7", "Name": "Objective" }, { "Id": "f3c89b1f-897a-4c3e-ae2d-23d58e461346", "Name": "Portfolio" }, { "Id": "0d153565-d897-42e6-8b36-5f3513ce1373", "Name": "Product" }, { "Id": "7e915956-f6b6-4deb-a1b2-e4fc213e3275", "Name": "Product Line" }, { "Id": "d73d864d-9370-4785-b94e-b9e57e731f6b", "Name": "Program" }, { "Id": "f2944753-635e-4a4c-bf52-d62f19649c3a", "Name": "Project" }, { "Id": "81dd5c28-337f-40b4-ad83-ff1564fb15f9", "Name": "Requirements" } ], "WorkTypes": [ { "Id": "d319ae09-ff12-482e-96f3-0f1069320258", "Name": "Approvals" }, { "Id": "32a5e893-f8f9-47b3-a81e-c4123fe89164", "Name": "Backlog" }, { "Id": "315497d8-abe0-42bc-919f-a62d979fcaf4", "Name": "Changes" }, { "Id": "92af3dcc-0711-4b84-b53f-a8ada853c324", "Name": "Issues" }, { "Id": "22f0160e-1a1b-45d0-99f4-36cf173b3fd9", "Name": "Key Decisions" }, { "Id": "e04d627c-e0c6-437f-8894-6a13efc92039", "Name": "Risks" }, { "Id": "e2a5e9dc-932c-4f1e-827f-37bf55772cb1", "Name": "Tasks" } ] } }