Skip to content

Instantly share code, notes, and snippets.

@WillVivid
Created April 3, 2024 17:48
Show Gist options
  • Save WillVivid/16ef35b0c54e8cf75e77074d6befb21a to your computer and use it in GitHub Desktop.
Save WillVivid/16ef35b0c54e8cf75e77074d6befb21a to your computer and use it in GitHub Desktop.
Grouped Vertical Timed Bar
{
"chartData":[
{
"name":"Oct/2023",
"value":4,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5"
},
"groupData":[
{
"name":"Pending",
"value":"2.00",
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5"
}
},
{
"name":"Work in Progress",
"value":"1.00",
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2"
}
},
{
"name":"Closed Complete",
"value":"1.00",
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=3"
}
}
],
"Pending":"2.00",
"Work in Progress":"1.00",
"Closed Complete":"1.00",
"groupMax":"2.00"
},
{
"name":"Sep/2023",
"value":1,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2"
},
"groupData":[
{
"name":"Work in Progress",
"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')^state=2"
}
},
{
"name":"Pending",
"value":0,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5"
}
},
{
"name":"Closed Complete",
"value":0,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=3"
}
}
],
"Work in Progress":"1.00",
"Pending":0,
"Closed Complete":0,
"groupMax":"1.00"
},
{
"name":"Mar/2024",
"value":1,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^sys_created_onDATEPART2024@javascript:gs.datePart('year','2024','EE')^state=-5"
},
"groupData":[
{
"name":"Pending",
"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')^state=-5"
}
},
{
"name":"Work in Progress",
"value":0,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2"
}
},
{
"name":"Closed Complete",
"value":0,
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=3"
}
}
],
"Pending":"1.00",
"Work in Progress":0,
"Closed Complete":0,
"groupMax":"1.00"
}
],
"keys":[
{
"name":"Pending",
"value":"2.00",
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5"
}
},
{
"name":"Work in Progress",
"value":"1.00",
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2"
}
},
{
"name":"Closed Complete",
"value":"1.00",
"query":{
"type":"default",
"query":"sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=3"
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment