Timed Grouped Horizontal Bar

timed-grouped-hor-bar.json

{
   "chartData":[
      {
         "name":"Red",
         "value":1,
         "query":{
            "type":"default",
            "query":"sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=red"
         },
         "groupData":[
            {
               "name":"Sep/2023",
               "value":"1.00",
               "query":{
                  "type":"default",
                  "query":"sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=red"
               }
            },
            {
               "name":"Oct/2023",
               "value":0,
               "query":{
                  "type":"default",
                  "query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=green"
               }
            },
            {
               "name":"Mar/2024",
               "value":0,
               "query":{
                  "type":"default",
                  "query":"sys_created_onDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^sys_created_onDATEPART2024@javascript:gs.datePart('year','2024','EE')^status=green"
               }
            }
         ],
         "Sep/2023":"1.00",
         "Oct/2023":0,
         "Mar/2024":0,
         "groupMax":"1.00"
      },
      {
         "name":"Green",
         "value":5,
         "query":{
            "type":"default",
            "query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=green"
         },
         "groupData":[
            {
               "name":"Oct/2023",
               "value":"4.00",
               "query":{
                  "type":"default",
                  "query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=green"
               }
            },
            {
               "name":"Mar/2024",
               "value":"1.00",
               "query":{
                  "type":"default",
                  "query":"sys_created_onDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^sys_created_onDATEPART2024@javascript:gs.datePart('year','2024','EE')^status=green"
               }
            },
            {
               "name":"Sep/2023",
               "value":0,
               "query":{
                  "type":"default",
                  "query":"sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=red"
               }
            }
         ],
         "Oct/2023":"4.00",
         "Mar/2024":"1.00",
         "Sep/2023":0,
         "groupMax":"4.00"
      }
   ],
   "keys":[
      {
         "name":"Sep/2023",
         "value":"1.00",
         "query":{
            "type":"default",
            "query":"sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=red"
         }
      },
      {
         "name":"Oct/2023",
         "value":"4.00",
         "query":{
            "type":"default",
            "query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=green"
         }
      },
      {
         "name":"Mar/2024",
         "value":"1.00",
         "query":{
            "type":"default",
            "query":"sys_created_onDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^sys_created_onDATEPART2024@javascript:gs.datePart('year','2024','EE')^status=green"
         }
      }
   ]
}