Sankey

sankey.json

{
   "chartData":[
      {
         "nodes":[
            {
               "node":0,
               "name":"Pending",
               "value":"-5"
            },
            {
               "node":1,
               "name":"Green",
               "value":"green"
            },
            {
               "node":2,
               "name":"Yellow",
               "value":"yellow"
            },
            {
               "node":3,
               "name":"Open",
               "value":"1"
            },
            {
               "node":4,
               "name":"Work in Progress",
               "value":"2"
            },
            {
               "node":5,
               "name":"Red",
               "value":"red"
            },
            {
               "node":6,
               "name":"Closed Complete",
               "value":"3"
            }
         ],
         "links":[
            {
               "source":0,
               "target":1,
               "value":"71.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=-5^status=green"
               }
            },
            {
               "source":0,
               "target":2,
               "value":"5.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=-5^status=yellow"
               }
            },
            {
               "source":3,
               "target":1,
               "value":"1.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=1^status=green"
               }
            },
            {
               "source":4,
               "target":1,
               "value":"17.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=2^status=green"
               }
            },
            {
               "source":4,
               "target":5,
               "value":"7.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=2^status=red"
               }
            },
            {
               "source":4,
               "target":2,
               "value":"6.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=2^status=yellow"
               }
            },
            {
               "source":6,
               "target":1,
               "value":"5.00",
               "query":{
                  "type":"default",
                  "query":"ORDERBYstate^ORDERBYstatus^GROUPBYstate,status^state=3^status=green"
               }
            }
         ]
      }
   ]
}