Team Dashboard

Team Dashboard

The team dashboard is to see the status of investigations within the greater team.

Let’s take a look at the code.

You can find the checked in file in the Hubstream solution here …

Hubstream.Intelligence.Server.Frontend/Data/Home/teamdashboardlayout.json

JSON
{
  "PageName": "Team Dashboard",
  "Tiles": [
    {
      "SubHeaderLabel": "Dashboard",
      "SubHeader": "null",
      "Header": "null",
      "HeaderLabel": "Team",
      "TileType": "LabelCard",
      "ContainerWidth": "full",
      "ContainerOverFlow": "true",
      "PositionSize": [ 0, 0, 20, 2 ],
      "IsFixed": true,
      "IsResizable": false
    },
    {
      "MenuItems": [
        {
          "Icon": "th",
          "Name": "User",
          "Caption": "User Dashboard"
        },
        {
          "Icon": "th",
          "Name": "Team",
          "Caption": "Team Dashboard"
        }
      ],
      "TileType": "SideMenu",
      "IsFixed": true,
      "IsResizable": false
    },
    {
      "TileType": "LayoutContainer",
      "ContainerBorder": "3px 3px 0 0",
      "ContainerWidth": "half",
      "IsFixed": true,
      "PositionSize": [ 0, 2, 5, 7 ],
      "Tiles": [
        {
          "Caption": "Active By Incident Type",
          "TileType": "SmallLabel",
          "PositionSize": [ 0, 0, 20, 1 ],
          "IsFixed": true,
          "IsResizable": false,
          "Filters": [ "IncidentType" ]
        },
        {
          "TileType": "Chart",
          "ChartType": "BubbleChart",
          "PositionSize": [ 0, 1, 20, -1 ],
          "IsFixed": true,
          "DataAPI": "tbl/investigation/dashboard/Organization/summary/IncidentType",
          "FieldName": "IncidentType",
          "Filters": [
            {
              "FieldName": "ActiveStatus",
              "FieldValue": "0"
            }
          ],
          "EntityName": "Investigation",
          "FieldExpression": "IncidentType",
          "Expression": "TeamDashboard-ActiveIncidentType",
          "SelfFilterExclusion": true,
          "DefaultNullCaption": "Not Specified"
        }
      ]
    },
    {
      "TileType": "LayoutContainer",
      "ContainerBorder": "0 3px 0 0",
      "ContainerWidth": "half",
      "IsFixed": true,
      "PositionSize": [ 0, 9, 5, 10 ],
      "Tiles": [
        {
          "Caption": "Active Investigations By Status",
          "TileType": "SmallLabel",
          "PositionSize": [ 0, 0, 20, 1 ],
          "IsFixed": true,
          "IsResizable": false,
          "Filters": [ "ActiveStatus", "Status" ]
        },
        {
          "TileType": "Chart",
          "ChartType": "HorizontalBarChart",
          "PositionSize": [ 0, 1, 20, 5 ],
          "ScrollY": true,
          "IsFixed": true,
          "DataAPI": "tbl/investigation/dashboard/Organization/summary/Status",
          "FieldName": "Status",
          "Filters": [
            {
              "FieldName": "ActiveStatus",
              "FieldValue": "0"
            }
          ],
          "EntityName": "Investigation",
          "FieldExpression": "Status",
          "Expression": "TeamDashboard-ActiveStatus",
          "ActiveValue": "0",
          "SkipScaling": true
        }
      ]
    },
    {
      "TileType": "LayoutContainer",
      "ContainerBorder": "3px 0 0 0",
      "ContainerWidth": "half",
      "IsFixed": true,
      "PositionSize": [ 5, 2, 5, 7 ],
      "Tiles": [
        {
          "Caption": "Workload",
          "TileType": "SmallLabel",
          "PositionSize": [ 0, 0, 20, 1 ],
          "IsFixed": true,
          "IsResizable": false,
          "Filters": [ "UserID", "FullName" ]
        },
        {
          "Caption": "unassigned",
          "TileType": "NumberLabel",
          "PositionSize": [ 0, 1, 4, 2 ],
          "DataAPI": "tbl/investigation/dashboard/User/count",
          "FieldName": "UserID",
          "Filters": [
            {
              "FieldName": "UserID",
              "IsValueTypeNull": true,
              "IgnoreDefaultFilter": true
            },
            {
              "FieldName": "ActiveStatus",
              "FieldValue": "0"
            }
          ],
          "EntityName": "+User",
          "FieldExpression": "UserID",
          "Expression": "TeamDashboard-UnAssignedCount",
          "SkipIdentityInjection": true,
          "ActiveValueTypeNull": true,
          "IsFixed": true,
          "IsResizable": false,
          "IsUserLevelFilter": true
        },
        {
          "Header": "Action",
          "TileType": "OptionsMenu",
          "PositionSize": [ 10, 1, 10, 2 ],
          "IsFixed": true,
          "ActionMenus": []
        },
        {
          "TileType": "Chart",
          "ChartType": "HorizontalBarChart",
          "PositionSize": [ 0, 3, 20, 4 ],
          "IsFixed": true,
          "ScrollY": true,
          "DataAPI": "tbl/investigation/dashboard/User/summary/FullName",
          "FieldName": "FullName",
          "IsUserLevelFilter": true,
          "DefaultNullCaption": "Unassigned",
          "SkipIdentityInjection": true,
          "SkipScaling": true,
          "EntityName": "+User",
          "FieldExpression": "User.FullName",
          "Expression": "TeamDashboard-Workload-ByName",
          "Filters": [
            {
              "FieldName": "ActiveStatus",
              "FieldValue": "0"
            }
          ]
        }
      ]
    },
    {
      "TileType": "LayoutContainer",
      "ContainerBorder": "3px 0 0 3px",
      "ContainerWidth": "half",
      "ContainerOverFlow": "true",
      "IsFixed": true,
      "PositionSize": [ 10, 2, 10, -1 ],
      "Tiles": [
        {
          "Caption": "Team Investigations",
          "TileType": "SmallLabel",
          "PositionSize": [ 0, 0, 20, 1 ],
          "IsFixed": true,
          "IsResizable": false,
          "Filters": [ "ActiveStatus", "Priority" ]
        },
        {
          "Caption": "active",
          "TileType": "NumberLabel",
          "PositionSize": [ 0, 1, 3, 2 ],
          "DataAPI": "tbl/investigation/dashboard/Organization/count",
          "FieldName": "ActiveStatus",
          "Filters": [
            {
              "FieldName": "ActiveStatus",
              "FieldValue": "0"
            }
          ],
          "EntityName": "Investigation",
          "FieldExpression": "Status.Group",
          "Expression": "TeamDashboard-ActiveCount",
          "ActiveValue": "0",
          "IsFixed": true,
          "IsResizable": false
        },
        {
          "Caption": "high priority",
          "TileType": "NumberLabel",
          "PositionSize": [ 3, 1, 3, 2 ],
          "DataAPI": "tbl/investigation/dashboard/Organization/count",
          "FieldName": "Priority",
          "Filters": [
            {
              "FieldName": "Priority",
              "FieldValue": "High Risk"
            }
          ],
          "EntityName": "Investigation",
          "FieldExpression": "Priority",
          "Expression": "TeamDashboard-ActiveCount-HighPriority",
          "ActiveValue": "High Risk",
          "IsFixed": true,
          "IsResizable": false,
          "TileColor": "#f10000"
        },
        {
          "Header": "Action",
          "TileType": "OptionsMenu",
          "PositionSize": [ 15, 1, 5, 2 ],
          "IsFixed": true,
          "ActionMenus": [
            {
              "Tooltip": "Open List",
              "Icon": "share",
              "Action": "openlistpage"
            },
            {
              "Tooltip": "Add new Investigation",
              "Icon": "plus",
              "Action": "addnewInvestigation",
              "AccessInfo": "EntityAccessInfo",
              "AccessInfoAction": "Add"
            }
          ]
        },
        {
          "TileType": "MiniTable",
          "PositionSize": [ 0, 3, 20, 15 ],
          "DynamicHeightOffset": 302,
          "EntityName": "Investigation",
          "ContainerWidth": "full",
          "IsFixed": true,
          "DataAPI": "api/v2/tbl/investigation/dashboard/Organization/list",
          "RowCountAPI": "tbl/investigation/dashboard/Organization/count",
          "Expression": "TeamDashboard-Investigations",
          "RowCountExpression": "TeamDashboard-Investigations-Count",
          "OutputColumns": [
            {
              "FieldName": "InvestigationID",
              "TargetFieldName": "ID"
            },
            {
              "FieldName": "Name"
            },
            {
              "FieldName": "PriorityIcon",
              "TargetFieldName": "SubIcon"
            },
            {
              "FieldName": "PriorityColor",
              "TargetFieldName": "SubIconColor"
            },
            {
              "FieldName": "Status"
            },
            {
              "FieldName": "TimePeriodName"
            },
            {
              "FieldName": "TimePeriodColor",
              "TargetFieldName": "ItemColor"
            },
            {
              "FieldName": "DateUpdated",
              "FormatType": "DeltaDate",
              "TargetFieldName": "DateUpdatedText"
            }
          ]
        }
      ]
    },
    {
      "TileType": "LayoutContainer",
      "IsFixed": true,
      "ContainerWidth": "half",
      "PositionSize": [ 5, 9, 5, 10 ],
      "Tiles": [
        {
          "Caption": "Days Active",
          "TileType": "SmallLabel",
          "PositionSize": [ 0, 0, 20, 1 ],
          "IsFixed": true,
          "IsResizable": false,
          "Filters": [ "TimePeriodName" ]
        },
        {
          "TileType": "Chart",
          "ChartType": "DonutChart",
          "PositionSize": [ 0, 1, 20, -1 ],
          "IsFixed": true,
          "DataAPI": "tbl/investigation/dashboard/Organization/summary/TimePeriodName",
          "FieldName": "TimePeriodName",
          "EntityName": "Investigation",
          "FieldExpression": "DateTimeReceived.DateRange",
          "Expression": "TeamDashboard-Days-Active",
          "ColorField": "TimePeriodColor",
          "SelfFilterExclusion": true,
          "Filters": [
            {
              "FieldName": "ActiveStatus",
              "FieldValue": "0"
            }
          ],
          "ActiveValue": "0"
        }
      ]
    }
  ]
}