Nested Score List

nested-score-list.json

{
   "headers":[
      "Portfolio",
      "Status",
      "Count"
   ],
   "chartData":[
      {
         "group":"primary_portfolio",
         "value":"",
         "query":{
            "type":"custom",
            "query":"pm_project_list.do?sysparm_query=primary_portfolio="
         },
         "children":[
            {
               "group":"status",
               "value":"Green",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=^status=green"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"28.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=^status=green"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            },
            {
               "group":"status",
               "value":"Red",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=^status=red"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"2.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=^status=red"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            },
            {
               "group":"status",
               "value":"Yellow",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=^status=yellow"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"2.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=^status=yellow"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            }
         ]
      },
      {
         "group":"primary_portfolio",
         "value":"Application Modernization",
         "query":{
            "type":"custom",
            "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201"
         },
         "children":[
            {
               "group":"status",
               "value":"Green",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^status=green"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"16.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^status=green"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            },
            {
               "group":"status",
               "value":"Red",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^status=red"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"1.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^status=red"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            },
            {
               "group":"status",
               "value":"Yellow",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^status=yellow"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"3.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^status=yellow"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            }
         ]
      },
      {
         "group":"primary_portfolio",
         "value":"Digital/Business Transformation",
         "query":{
            "type":"custom",
            "query":"pm_project_list.do?sysparm_query=primary_portfolio=e2e15e53933012003b4bb095e57ffbb7"
         },
         "children":[
            {
               "group":"status",
               "value":"Green",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=e2e15e53933012003b4bb095e57ffbb7^status=green"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"13.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=e2e15e53933012003b4bb095e57ffbb7^status=green"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            }
         ]
      },
      {
         "group":"primary_portfolio",
         "value":"HR",
         "query":{
            "type":"custom",
            "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e"
         },
         "children":[
            {
               "group":"status",
               "value":"Green",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^status=green"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"25.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^status=green"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            },
            {
               "group":"status",
               "value":"Red",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^status=red"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"3.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^status=red"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            },
            {
               "group":"status",
               "value":"Yellow",
               "query":{
                  "type":"custom",
                  "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^status=yellow"
               },
               "children":[
                  {
                     "group":"COUNT",
                     "value":"4.00",
                     "query":{
                        "type":"custom",
                        "query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^status=yellow"
                     },
                     "children":[
                        
                     ]
                  }
               ]
            }
         ]
      }
   ]
}