-
-
Save WillVivid/b209a817866debab0bb391df651c64d6 to your computer and use it in GitHub Desktop.
Multi Line
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "chartData":[ | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTDecember@javascript:gs.datePart('month','dec','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"Dec/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTNovember@javascript:gs.datePart('month','nov','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"Nov/2023", | |
| "value":"3.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"Oct/2023", | |
| "value":"5.00" | |
| }, | |
| { | |
| "groupName":"Work in Progress", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2" | |
| }, | |
| "name":"Oct/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Work in Progress", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2" | |
| }, | |
| "name":"Sep/2023", | |
| "value":"3.00" | |
| }, | |
| { | |
| "groupName":"Closed Complete", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=3" | |
| }, | |
| "name":"Sep/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTAugust@javascript:gs.datePart('month','aug','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"Aug/2023", | |
| "value":"3.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTJuly@javascript:gs.datePart('month','july','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"July/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTJune@javascript:gs.datePart('month','june','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"June/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Work in Progress", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTApril@javascript:gs.datePart('month','apr','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2" | |
| }, | |
| "name":"Apr/2023", | |
| "value":"2.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=-5" | |
| }, | |
| "name":"Mar/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Work in Progress", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTFebruary@javascript:gs.datePart('month','feb','EE')^start_dateDATEPART2023@javascript:gs.datePart('year','2023','EE')^state=2" | |
| }, | |
| "name":"Feb/2023", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Pending", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTApril@javascript:gs.datePart('month','apr','EE')^start_dateDATEPART2024@javascript:gs.datePart('year','2024','EE')^state=-5" | |
| }, | |
| "name":"Apr/2024", | |
| "value":"1.00" | |
| }, | |
| { | |
| "groupName":"Closed Complete", | |
| "query":{ | |
| "type":"default", | |
| "query":"start_dateONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^ORDERBYyearref^ORDERBYDESCtimeref^GROUPBYstate^TRENDBYstart_date,month^start_dateDATEPARTFebruary@javascript:gs.datePart('month','feb','EE')^start_dateDATEPART2024@javascript:gs.datePart('year','2024','EE')^state=3" | |
| }, | |
| "name":"Feb/2024", | |
| "value":"1.00" | |
| } | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment