ITSM-NG complete dashboard
A full featured dashboard to perform reporting on ITSM-NG.
![](https://static.wixstatic.com/media/e5b7d4_f67ff8c629844818a6e3e43550cb1e17~mv2.png/v1/fill/w_348,h_122,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Original%20on%20Transparent.png)

ITSM-NG is a GLPI fork with the objective of offering a strong community component and relevant technological choices.

# Some Links

  - [Website](https://www.itsm-ng.com)
  - [Github](https://github.com/itsmng)
  - [Wiki](https://wiki.itsm-ng.org)

# Setup Grafana dashboard

To install and configure ITSM-NG Grafana dashboard, please refer to our documentation : [Grafana dashboard](https://wiki.itsm-ng.org/third-party/grafana/).

# Report list 

The default provided dashboard contains three different type of reporting : 

* Ticketing
	* Tickets opened per day
	* Tickets per location / category / user group
	* Tickets with exceeded resolution time
	* Tickets with exceeded resolution time last month
	* Tickets with time to open exceeded last month

![](https://wiki.itsm-ng.org/img/grafana/grafana_dashboard_ticketing.png)

* Assets
	* Computers per location / status / warranty / manufacturer
	* Network equipment per type / manufacturer
	* Number of network equipment

![](https://wiki.itsm-ng.org/img/grafana/grafana_dashboard_asset.png)

* Financial
	* Total budget
	* Budget per type
	* Expenses per budget
	* Amortizations duration
	* Computers per supplier / amortization type
	* Network equipment per supplier

![](https://wiki.itsm-ng.org/img/grafana/grafana_dashboard_financial.png)


{
  "__inputs": [
    {
      "name": "DS_ITSM-NG_API",
      "label": "ITSM-NG API",
      "description": "Full featured dashboard for ITSM-NG product",
      "type": "datasource",
      "pluginId": "marcusolsson-json-datasource",
      "pluginName": "JSON API"
    }
  ],
  "__elements": {},
  "__requires": [
    {
      "type": "panel",
      "id": "barchart",
      "name": "Bar chart",
      "version": ""
    },
    {
      "type": "panel",
      "id": "bargauge",
      "name": "Bar gauge",
      "version": ""
    },
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "9.3.6"
    },
    {
      "type": "datasource",
      "id": "marcusolsson-json-datasource",
      "name": "JSON API",
      "version": "1.3.2"
    },
    {
      "type": "panel",
      "id": "piechart",
      "name": "Pie chart",
      "version": ""
    },
    {
      "type": "panel",
      "id": "stat",
      "name": "Stat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "timeseries",
      "name": "Time series",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "grafana",
          "uid": "-- Grafana --"
        },
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "target": {
          "limit": 100,
          "matchAny": false,
          "tags": [],
          "type": "dashboard"
        },
        "type": "dashboard"
      }
    ]
  },
  "editable": true,
  "fiscalYearStartMonth": 0,
  "graphTooltip": 0,
  "id": null,
  "links": [],
  "liveNow": false,
  "panels": [
    {
      "collapsed": false,
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 0
      },
      "id": 7,
      "panels": [],
      "title": "Ticketing",
      "type": "row"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "locations_id"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 0,
        "y": 1
      },
      "id": 27,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.locations_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/ticket?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Tickets per location",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "locations_id": {
                "aggregations": [
                  "lastNotNull"
                ],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "itilcategories_id"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 8,
        "y": 1
      },
      "id": 28,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.itilcategories_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/ticket?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Tickets per category",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "itilcategories_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 16,
        "y": 1
      },
      "id": 45,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": "id",
              "type": "number"
            },
            {
              "jsonPath": "$.*.groups_id",
              "language": "jsonpath",
              "name": "Groupe"
            }
          ],
          "method": "GET",
          "queryParams": "",
          "refId": "B",
          "urlPath": "/Group_Ticket/?expand_dropdowns=true&range=0-99999999999999999999"
        }
      ],
      "title": "Tickets per user group",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "2": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "71": {
                "aggregations": [],
                "operation": "groupby"
              },
              "Budgets": {
                "aggregations": [],
                "operation": "groupby"
              },
              "Depense": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "Groupe": {
                "aggregations": [],
                "operation": "groupby"
              },
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "continuous-GrYlRd"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 0,
            "gradientMode": "scheme",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 3,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 10,
        "w": 12,
        "x": 0,
        "y": 9
      },
      "id": 26,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].2",
              "name": "nb"
            },
            {
              "jsonPath": "$.data[*].15",
              "language": "jsonpath",
              "name": "date",
              "type": "time"
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/ticket/?expand_dropdown=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Tickets opened per day",
      "transformations": [
        {
          "id": "calculateField",
          "options": {
            "alias": "Number of tickets",
            "mode": "reduceRow",
            "reduce": {
              "include": [
                "date"
              ],
              "reducer": "count"
            },
            "replaceFields": true
          }
        },
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "Nombre de tickets": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "Number of tickets": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "date": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "continuous-GrYlRd"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "bars",
            "fillOpacity": 30,
            "gradientMode": "scheme",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineStyle": {
              "fill": "solid"
            },
            "lineWidth": 1,
            "pointSize": 1,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 10,
        "w": 12,
        "x": 12,
        "y": 9
      },
      "id": 46,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].2",
              "name": "nb"
            },
            {
              "jsonPath": "$.data[*].15",
              "language": "jsonpath",
              "name": "date",
              "type": "time"
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/ticket/?expand_dropdown=true&range=0-99999999999999999999&criteria[0][field]=82&criteria[0][searchtype]=equals&criteria[0][value]=1",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Tickets with exceeded resolution time",
      "transformations": [
        {
          "id": "calculateField",
          "options": {
            "alias": "Nombre de tickets",
            "mode": "reduceRow",
            "reduce": {
              "include": [
                "nb"
              ],
              "reducer": "count"
            },
            "replaceFields": true
          }
        },
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "Nombre de tickets": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "date": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "description": "",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [
            {
              "options": {
                "0": {
                  "color": "green",
                  "index": 0,
                  "text": "None"
                }
              },
              "type": "value"
            }
          ],
          "thresholds": {
            "mode": "percentage",
            "steps": [
              {
                "color": "red",
                "value": null
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 12,
        "x": 0,
        "y": 19
      },
      "id": 5,
      "options": {
        "colorMode": "value",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.totalcount"
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/ticket/?is_deleted=0&as_map=0&criteria[0][link]=AND&criteria[0][field]=82&criteria[0][searchtype]=equals&criteria[0][value]=1&criteria[1][link]=AND&criteria[1][field]=15&criteria[1][searchtype]=morethan&_select_criteria[1][value]=-1MONTH&criteria[1][value]=-1MONTH",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Ticket with resolution time exceeding last month",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "percentage",
            "steps": [
              {
                "color": "red",
                "value": null
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 4,
        "w": 12,
        "x": 12,
        "y": 19
      },
      "id": 4,
      "options": {
        "colorMode": "value",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.totalcount"
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/ticket/?criteria[0][field]=159&criteria[0][searchtype]=equals&criteria[0][value]=1&criteria[1][link]=AND&criteria[1][field]=15&criteria[1][searchtype]=morethan&_select_criteria[1][value]=-1MONTH&criteria[1][value]=-1MONTH",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Ticket with time to open exceeded last month",
      "type": "stat"
    },
    {
      "collapsed": false,
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 23
      },
      "id": 9,
      "panels": [],
      "title": "Assets",
      "type": "row"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "locations_id"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 0,
        "y": 24
      },
      "id": 29,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "donut",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.locations_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/computer?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Computers per location",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "locations_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "states_id"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 8,
        "y": 24
      },
      "id": 30,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.states_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/computer?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Computers per status",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "locations_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "states_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 16,
        "y": 24
      },
      "id": 36,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.manufacturers_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/computer/?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Computers per manufacturer",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "57": {
                "aggregations": [],
                "operation": "groupby"
              },
              "A 57": {
                "aggregations": [
                  "sum"
                ],
                "operation": "groupby"
              },
              "B ID": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "B sort": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "id": {
                "aggregations": [
                  "max"
                ],
                "operation": "aggregate"
              },
              "manufacturers_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "continuous-BlPu"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 3,
        "w": 24,
        "x": 0,
        "y": 32
      },
      "id": 21,
      "options": {
        "displayMode": "lcd",
        "minVizHeight": 10,
        "minVizWidth": 0,
        "orientation": "horizontal",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "showUnfilled": true
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.totalcount",
              "name": "."
            }
          ],
          "method": "GET",
          "queryParams": "",
          "refId": "With warranty",
          "urlPath": "/search/Computer?range=0-99999999999999999999&criteria[0][field]=120&criteria[0][searchtype]=morethan&_select_criteria[0][value]=NOW&criteria[0][value]=NOW"
        },
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "name": "."
            }
          ],
          "hide": false,
          "method": "GET",
          "queryParams": "",
          "refId": "Without warranty",
          "urlPath": "/Computer?range=0-99999999999999999999"
        }
      ],
      "title": "Computers per warranty",
      "transformations": [],
      "type": "bargauge"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "percentage",
            "steps": [
              {
                "color": "red"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 0,
        "y": 35
      },
      "id": 16,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.totalcount"
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [
            [
              "App-Token",
              "hZQVHhDM19pA33dx4ydrOb68nZIEYG6WHjCQgsId"
            ],
            [
              "Session-Token",
              "qaai2886l9ls8a4dkdvnvc7t2c"
            ]
          ],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/networkequipment",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Number of network equipment",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 8,
        "y": 35
      },
      "id": 37,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.manufacturers_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/networkequipment/?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Network equipment per manufacturer",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "57": {
                "aggregations": [],
                "operation": "groupby"
              },
              "A 57": {
                "aggregations": [
                  "sum"
                ],
                "operation": "groupby"
              },
              "B ID": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "B sort": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "manufacturers_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 16,
        "y": 35
      },
      "id": 32,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.networkequipmenttypes_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/networkequipment?expand_dropdowns=true&range=0-99999999999999999999",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Network equipment per type",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "locations_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "networkequipmenttypes_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "networks_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "states_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "collapsed": false,
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 43
      },
      "id": 11,
      "panels": [],
      "title": "Financial",
      "type": "row"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "fixedColor": "super-light-blue",
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "57"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "color": "super-light-green",
                        "index": 1,
                        "text": "No amortization"
                      },
                      "1": {
                        "color": "super-light-blue",
                        "index": 2,
                        "text": "Decreasing"
                      },
                      "2": {
                        "color": "super-light-purple",
                        "index": 3,
                        "text": "Linear"
                      },
                      "": {
                        "color": "super-light-orange",
                        "index": 0,
                        "text": "Not activated"
                      }
                    },
                    "type": "value"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 0,
        "y": 44
      },
      "id": 41,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].57",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.data[*].31",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/computer/?expand_dropdowns=true&range=0-99999999999999999999&criteria[0][field]=57&criteria[0][searchtype]=equals&criteria[0][value]=",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Computers per amortization type",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "31": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "57": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "super-light-blue"
              }
            ]
          },
          "unit": "currencyEUR"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 8,
        "y": 44
      },
      "id": 35,
      "options": {
        "colorMode": "value",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "sum"
          ],
          "fields": "",
          "values": false
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].7",
              "language": "jsonpath",
              "name": ".",
              "type": "number"
            }
          ],
          "method": "GET",
          "queryParams": "",
          "refId": "Sous Garantie",
          "urlPath": "/search/budget/?criteria[0][field]=6&criteria[0][searchtype]=morethan&_select_criteria[0][value]=NOW&criteria[0][value]=NOW&criteria[1][link]=OR&criteria[1][field]=6&criteria[1][searchtype]=equals&_select_criteria[1][value]=NOW&criteria[1][value]=NOW&criteria[2][link]=AND&criteria[2][field]=5&criteria[2][searchtype]=equals&_select_criteria[2][value]=NOW&criteria[2][value]=NOW&criteria[3][link]=AND&criteria[3][field]=7&criteria[3][searchtype]=contains&criteria[3][value]="
        }
      ],
      "title": "Total budget",
      "transformations": [],
      "type": "stat"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "fillOpacity": 80,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineWidth": 1,
            "scaleDistribution": {
              "type": "linear"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          },
          "unit": "none"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "PC (count)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Number of computers"
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "x an"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "match": "null+nan",
                      "result": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "special"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 16,
        "y": 44
      },
      "id": 40,
      "options": {
        "barRadius": 0,
        "barWidth": 0.97,
        "groupWidth": 0.7,
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "right",
          "showLegend": true
        },
        "orientation": "auto",
        "showValue": "never",
        "stacking": "none",
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": 0,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].1",
              "language": "jsonpath",
              "name": "PC"
            },
            {
              "jsonPath": "$.data[*].56",
              "language": "jsonpath",
              "name": "x an"
            }
          ],
          "method": "GET",
          "queryParams": "",
          "refId": "Sous Garantie",
          "urlPath": "/search/computer/?range=0-99999999999999999999&criteria[0][field]=56&criteria[0][searchtype]=equals&criteria[0][value]="
        }
      ],
      "title": "Amortizations duration",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "PC": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "x an": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "barchart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisLabel": "",
            "axisPlacement": "auto",
            "fillOpacity": 80,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineWidth": 1,
            "scaleDistribution": {
              "type": "linear"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "budget_value (sum)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Total"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "super-light-orange",
                  "mode": "fixed"
                }
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "budget_expenses (sum)"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Expenses"
              },
              {
                "id": "color",
                "value": {
                  "fixedColor": "light-red",
                  "mode": "fixed"
                }
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 10,
        "w": 24,
        "x": 0,
        "y": 52
      },
      "id": 48,
      "options": {
        "barRadius": 0,
        "barWidth": 1,
        "groupWidth": 0.93,
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "right",
          "showLegend": true
        },
        "orientation": "vertical",
        "showValue": "never",
        "stacking": "none",
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": 0,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "9.3.6",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.name",
              "name": "budget_id"
            },
            {
              "jsonPath": "$.*.value",
              "language": "jsonpath",
              "name": "budget_value",
              "type": "number"
            }
          ],
          "method": "GET",
          "queryParams": "",
          "refId": "Budget",
          "urlPath": "/Budget/?expand_dropdowns=true&range=0-99999999999999999999"
        },
        {
          "cacheDurationSeconds": 300,
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.value",
              "name": "budget_expenses",
              "type": "number"
            },
            {
              "jsonPath": "$.*.budgets_id",
              "language": "jsonpath",
              "name": "budget_id"
            }
          ],
          "hide": false,
          "method": "GET",
          "queryParams": "",
          "refId": "Expenses",
          "urlPath": "/InfoCom/?expand_dropdowns=true&range=0-99999999999999999999"
        }
      ],
      "title": "Expenses per budget",
      "transformations": [
        {
          "id": "merge",
          "options": {}
        },
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "Expenses": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "Total": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "budget_expenses": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "budget_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "budget_value": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              }
            }
          }
        },
        {
          "id": "filterByValue",
          "options": {
            "filters": [
              {
                "config": {
                  "id": "equal",
                  "options": {
                    "value": "0"
                  }
                },
                "fieldName": "budget_id"
              }
            ],
            "match": "all",
            "type": "exclude"
          }
        }
      ],
      "type": "barchart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "53"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "value"
                  },
                  {
                    "options": {
                      "match": "null+nan",
                      "result": {
                        "index": 1,
                        "text": "Undefined"
                      }
                    },
                    "type": "special"
                  },
                  {
                    "options": {
                      "match": "empty",
                      "result": {
                        "index": 2,
                        "text": "Undefined"
                      }
                    },
                    "type": "special"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 0,
        "y": 62
      },
      "id": 39,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].53",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.data[*].31",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/networkequipment/?range=0-99999999999999999999&criteria[0][link]=AND&criteria[0][field]=53&criteria[0][searchtype]=equals&criteria[0][value]=",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Network equipment per supplier",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "1": {
                "aggregations": [],
                "operation": "aggregate"
              },
              "3": {
                "aggregations": [],
                "operation": "groupby"
              },
              "5": {
                "aggregations": [],
                "operation": "groupby"
              },
              "31": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "53": {
                "aggregations": [
                  "count"
                ],
                "operation": "groupby"
              },
              "57": {
                "aggregations": [],
                "operation": "groupby"
              },
              "A 57": {
                "aggregations": [
                  "sum"
                ],
                "operation": "groupby"
              },
              "B ID": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "B sort": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "manufacturers_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": []
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "53"
            },
            "properties": [
              {
                "id": "mappings",
                "value": [
                  {
                    "options": {
                      "0": {
                        "index": 0,
                        "text": "Undefined"
                      }
                    },
                    "type": "value"
                  },
                  {
                    "options": {
                      "match": "null+nan",
                      "result": {
                        "index": 1,
                        "text": "Undefined"
                      }
                    },
                    "type": "special"
                  },
                  {
                    "options": {
                      "match": "empty",
                      "result": {
                        "index": 2,
                        "text": "Undefined"
                      }
                    },
                    "type": "special"
                  }
                ]
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 8,
        "y": 62
      },
      "id": 38,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.data[*].53",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.data[*].31",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/search/computer/?range=0-99999999999999999999&criteria[0][link]=AND&criteria[0][field]=53&criteria[0][searchtype]=equals&criteria[0][value]=",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Computers per supplier",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "1": {
                "aggregations": [],
                "operation": "aggregate"
              },
              "3": {
                "aggregations": [],
                "operation": "groupby"
              },
              "5": {
                "aggregations": [],
                "operation": "groupby"
              },
              "31": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "53": {
                "aggregations": [
                  "count"
                ],
                "operation": "groupby"
              },
              "57": {
                "aggregations": [],
                "operation": "groupby"
              },
              "A 57": {
                "aggregations": [
                  "sum"
                ],
                "operation": "groupby"
              },
              "B ID": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "B sort": {
                "aggregations": [
                  "sum"
                ],
                "operation": "aggregate"
              },
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "manufacturers_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    },
    {
      "datasource": {
        "type": "marcusolsson-json-datasource",
        "uid": "${DS_ITSM-NG_API}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            }
          },
          "mappings": [
            {
              "options": {
                "0": {
                  "color": "red",
                  "index": 0,
                  "text": "Sans Type"
                }
              },
              "type": "value"
            }
          ]
        },
        "overrides": []
      },
      "gridPos": {
        "h": 8,
        "w": 8,
        "x": 16,
        "y": 62
      },
      "id": 33,
      "options": {
        "displayLabels": [
          "percent"
        ],
        "legend": {
          "displayMode": "list",
          "placement": "right",
          "showLegend": true,
          "values": []
        },
        "pieType": "pie",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.2.5",
      "targets": [
        {
          "cacheDurationSeconds": 300,
          "columns": [],
          "datasource": {
            "type": "marcusolsson-json-datasource",
            "uid": "${DS_ITSM-NG_API}"
          },
          "fields": [
            {
              "jsonPath": "$.*.id",
              "language": "jsonpath",
              "name": ""
            },
            {
              "jsonPath": "$.*.budgettypes_id",
              "language": "jsonpath",
              "name": ""
            }
          ],
          "filters": [],
          "format": "table",
          "global_query_id": "",
          "headers": [],
          "method": "GET",
          "queryParams": "",
          "refId": "A",
          "root_selector": "",
          "source": "url",
          "type": "json",
          "url": "https://github.com/yesoreyeram/grafana-infinity-datasource/blob/main/testdata/users.json",
          "urlPath": "/budget?expand_dropdowns=true",
          "url_options": {
            "data": "",
            "method": "GET"
          }
        }
      ],
      "title": "Budget per type",
      "transformations": [
        {
          "id": "groupBy",
          "options": {
            "fields": {
              "autoupdatesystems_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "budgettypes_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "id": {
                "aggregations": [
                  "count"
                ],
                "operation": "aggregate"
              },
              "locations_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "networks_id": {
                "aggregations": [],
                "operation": "groupby"
              },
              "states_id": {
                "aggregations": [],
                "operation": "groupby"
              }
            }
          }
        }
      ],
      "type": "piechart"
    }
  ],
  "refresh": false,
  "schemaVersion": 37,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": [
      {
        "current": {},
        "datasource": {
          "type": "marcusolsson-json-datasource",
          "uid": "${DS_ITSM-NG_API}"
        },
        "definition": "",
        "hide": 0,
        "includeAll": false,
        "multi": false,
        "name": "query0",
        "options": [],
        "query": "",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "type": "query"
      }
    ]
  },
  "time": {
    "from": "2022-01-01T06:31:34.000Z",
    "to": "2023-01-15T11:00:00.000Z"
  },
  "timepicker": {},
  "timezone": "",
  "title": "ITSM-NG complete dashboard",
  "uid": "AyODNh2Vk",
  "version": 73,
  "weekStart": "",
  "gnetId": 18033,
  "description": "A full featured dashboard to perform reporting on ITSM-NG."
}