-
-
Save WillVivid/89d85ae68fe5fb155c986e0b516c021f to your computer and use it in GitHub Desktop.
Trend Table
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":[ | |
| [ | |
| { | |
| "title":"Red", | |
| "value":"Red", | |
| "key":"startingCell", | |
| "group":"red", | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^ORDERBYstatus^GROUPBYstatus^TRENDBYsys_created_on,month^status=red" | |
| } | |
| }, | |
| { | |
| "title":"1.00", | |
| "value":1, | |
| "key":"Sep/2023", | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^ORDERBYstatus^GROUPBYstatus^TRENDBYsys_created_on,month^sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=red" | |
| } | |
| }, | |
| { | |
| "title":0, | |
| "value":0, | |
| "key":"gap", | |
| "query":{ | |
| "type":"disabled", | |
| "query":"" | |
| } | |
| }, | |
| { | |
| "title":0, | |
| "value":0, | |
| "key":"gap", | |
| "query":{ | |
| "type":"disabled", | |
| "query":"" | |
| } | |
| }, | |
| { | |
| "title":"1.00", | |
| "value":1, | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYstatus^GROUPBYstatus^status=red" | |
| } | |
| } | |
| ], | |
| [ | |
| { | |
| "title":"Green", | |
| "value":"Green", | |
| "key":"startingCell", | |
| "group":"green", | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^ORDERBYstatus^GROUPBYstatus^TRENDBYsys_created_on,month^status=green" | |
| } | |
| }, | |
| { | |
| "title":0, | |
| "value":0, | |
| "key":"gap", | |
| "query":{ | |
| "type":"disabled", | |
| "query":"" | |
| } | |
| }, | |
| { | |
| "title":"4.00", | |
| "value":4, | |
| "key":"Oct/2023", | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^ORDERBYstatus^GROUPBYstatus^TRENDBYsys_created_on,month^sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')^status=green" | |
| } | |
| }, | |
| { | |
| "title":"1.00", | |
| "value":1, | |
| "key":"Mar/2024", | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^ORDERBYstatus^GROUPBYstatus^TRENDBYsys_created_on,month^sys_created_onDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^sys_created_onDATEPART2024@javascript:gs.datePart('year','2024','EE')^status=green" | |
| } | |
| }, | |
| { | |
| "title":"5.00", | |
| "value":5, | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYstatus^GROUPBYstatus^status=green" | |
| } | |
| } | |
| ], | |
| [ | |
| { | |
| "title":"Total", | |
| "value":"Total", | |
| "query":{ | |
| "type":"disabled", | |
| "query":"pm_project_list.do?sysparm_query=^EQ^sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()" | |
| } | |
| }, | |
| { | |
| "title":"1.00", | |
| "value":1, | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^TRENDBYsys_created_on,month^sys_created_onDATEPARTSeptember@javascript:gs.datePart('month','sep','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')" | |
| } | |
| }, | |
| { | |
| "title":"4.00", | |
| "value":4, | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^TRENDBYsys_created_on,month^sys_created_onDATEPARTOctober@javascript:gs.datePart('month','oct','EE')^sys_created_onDATEPART2023@javascript:gs.datePart('year','2023','EE')" | |
| } | |
| }, | |
| { | |
| "title":"1.00", | |
| "value":1, | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^ORDERBYyearref^ORDERBYtimeref^TRENDBYsys_created_on,month^sys_created_onDATEPARTMarch@javascript:gs.datePart('month','mar','EE')^sys_created_onDATEPART2024@javascript:gs.datePart('year','2024','EE')" | |
| } | |
| }, | |
| { | |
| "title":"6.00", | |
| "value":6, | |
| "query":{ | |
| "type":"custom", | |
| "query":"pm_project_list.do?sysparm_query=sys_created_onONLast 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()^statusINred,green^" | |
| } | |
| } | |
| ] | |
| ], | |
| "headers":[ | |
| "Status", | |
| "Sep/2023", | |
| "Oct/2023", | |
| "Mar/2024", | |
| "Total" | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment