Daily Management
Daily Management
{
  "__inputs": [
    {
      "name": "DS_AZURE_MONITOR - SAAS_INFRA",
      "label": "Azure Monitor - SaaS_Infra",
      "description": "",
      "type": "datasource",
      "pluginId": "grafana-azure-monitor-datasource",
      "pluginName": "Azure Monitor"
    },
    {
      "name": "DS_ODS_DATABASE",
      "label": "ODS Database",
      "description": "",
      "type": "datasource",
      "pluginId": "mssql",
      "pluginName": "Microsoft SQL Server"
    }
  ],
  "__elements": {},
  "__requires": [
    {
      "type": "panel",
      "id": "barchart",
      "name": "Bar chart",
      "version": ""
    },
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "9.3.2"
    },
    {
      "type": "datasource",
      "id": "grafana-azure-monitor-datasource",
      "name": "Azure Monitor",
      "version": "1.0.0"
    },
    {
      "type": "datasource",
      "id": "mssql",
      "name": "Microsoft SQL Server",
      "version": "1.0.0"
    },
    {
      "type": "panel",
      "id": "stat",
      "name": "Stat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "table",
      "name": "Table",
      "version": ""
    },
    {
      "type": "panel",
      "id": "timeseries",
      "name": "Time series",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "datasource",
          "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": [
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisGridShow": true,
            "axisLabel": "Time (Milliseconds)",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "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
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 24,
        "x": 0,
        "y": 0
      },
      "id": 21,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "timezone": [
          "America/New_York"
        ],
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.1.6",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "pageViews\r\n| where operation_Name contains \"indexing\" and $__timeFilter(timestamp)\r\n| summarize Duration = avg(duration) by bin(timestamp, 1h)\r\n| sort by timestamp asc\r\n",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "AvidCapture - Indexing Performance",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisCenteredZero": false,
            "axisColorMode": "text",
            "axisGridShow": true,
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "linear",
            "lineWidth": 1,
            "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
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 24,
        "x": 0,
        "y": 9
      },
      "id": 23,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "timezone": [
          "America/New_York"
        ],
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "9.1.6",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "pageViews\r\n| where operation_Name contains \"indexing\" and $__timeFilter(timestamp)\r\n| summarize Requests = count() by bin(timestamp, 1h)\r\n| sort by timestamp asc ",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "AvidCapture - Indexing Performance",
      "type": "timeseries"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "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",
                "value": null
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 9,
        "w": 24,
        "x": 0,
        "y": 18
      },
      "id": 22,
      "options": {
        "barRadius": 0,
        "barWidth": 0.97,
        "groupWidth": 0.7,
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "orientation": "auto",
        "showValue": "auto",
        "stacking": "none",
        "tooltip": {
          "mode": "single",
          "sort": "none"
        },
        "xTickLabelRotation": -45,
        "xTickLabelSpacing": 0
      },
      "pluginVersion": "9.1.6",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "pageViews\r\n| where operation_Name contains \"indexing\" and $__timeFilter(timestamp)\r\n| summarize avg(duration) by client_CountryOrRegion\r\n| sort by client_CountryOrRegion\r\n",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "AvidCapture - Indexing Performance",
      "type": "barchart"
    },
    {
      "datasource": {
        "type": "mssql",
        "uid": "${DS_ODS_DATABASE}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "auto",
            "displayMode": "auto",
            "inspect": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "LockedByUserID"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 143
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 24,
        "x": 0,
        "y": 27
      },
      "id": 20,
      "options": {
        "footer": {
          "fields": "",
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": true,
        "sortBy": [
          {
            "desc": true,
            "displayName": "OrganizationName"
          }
        ]
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "alias": "",
          "datasource": {
            "type": "mssql",
            "uid": "${DS_ODS_DATABASE}"
          },
          "editorMode": "code",
          "format": "table",
          "rawQuery": true,
          "rawSql": "SELECT tOrganization.OrganizationName, tInvoiceStage.BuyerID, tInvoiceStage.InvoiceStageID, tInvoiceStageQueue.QueueID, tInvoiceStage.ExternalInvoiceIdentifier, tInvoiceStage.InvoiceStageNumber, tInvoiceStage.InsertDateTime, tInvoiceStage.InvoiceStageProcessingStateLookupID \r\nFROM ordermanagement_trn.tInvoiceStage\r\ninner join ordermanagement_pfl.tOrganization\r\non ordermanagement_pfl.tOrganization.OrganizationID = ordermanagement_trn.tInvoiceStage.BuyerID\r\nINNER JOIN ordermanagement_trn.tInvoiceStageQueue\r\n        ON  tInvoiceStageQueue.InvoiceStageID = tInvoiceStage.InvoiceStageID\r\n            AND tInvoiceStageQueue.LastChangedByUserId = 127582 -- AvidCapture User\r\n            -- Initial Insert, Analysis, Router, Submission, Processed            \r\n            AND tInvoiceStageQueue.QueueID NOT IN(1,9,13,14,15,6)            \r\n             -- Go back 10 days            \r\n            AND tInvoiceStageQueue.InsertDateTime > DateAdd(DD,-7,GETDATE())\r\n     WHERE tInvoiceStage.InvoiceStageProcessingStateLookupID =78    -- Not in AvidInvoice   \r\n     AND TRY_CONVERT(UNIQUEIDENTIFIER, tInvoiceStage.ExternalInvoiceIdentifier) IS NOT NULL\r\n     AND tInvoiceStage.BuyerID != 3706257\r\n                        order by tInvoiceStage.InsertDateTime desc",
          "refId": "A",
          "sql": {
            "columns": [
              {
                "parameters": [],
                "type": "function"
              }
            ],
            "groupBy": [
              {
                "property": {
                  "type": "string"
                },
                "type": "groupBy"
              }
            ],
            "limit": 50
          }
        }
      ],
      "title": "Offramped Documents",
      "type": "table"
    },
    {
      "datasource": {
        "type": "datasource",
        "uid": "grafana"
      },
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 34
      },
      "id": 15,
      "targets": [
        {
          "datasource": {
            "type": "datasource",
            "uid": "grafana"
          },
          "refId": "A"
        }
      ],
      "title": "Split Stat Panels",
      "type": "row"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 0,
        "y": 35
      },
      "id": 16,
      "options": {
        "colorMode": "background",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [],
          "fields": "",
          "values": true
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents\r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId !in ($TrainingPortalIds)\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"], BuyerName = tostring(customDimensions[\"buyerName\"])\r\n| join kind = leftanti (customEvents\r\n      | where name contains \"Document Updated\" and $__timeFilter(timestamp)\r\n      | extend Timestamp = timestamp\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | project Timestamp, Escalation = tostring(customDimensions[\"escalationCategoryIssue\"]), DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| project CreateTimestamp, DocumentId = DocumentIdLeft, BuyerId, BuyerName\r\n| summarize count() by BuyerName",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs in Pending",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 8,
        "y": 35
      },
      "id": 17,
      "maxPerRow": 4,
      "options": {
        "colorMode": "background",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId !in ($TrainingPortalIds)\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"], BuyerName = tostring(customDimensions[\"buyerName\"])\r\n| join (customEvents\r\n      | where name contains \"Document Updated\" and $__timeFilter(timestamp)\r\n      | extend Timestamp = timestamp\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | project Timestamp, Escalation = tostring(customDimensions[\"escalationCategoryIssue\"]), DocumentIdRight\r\n      | summarize UpdateTime = max(Timestamp) by DocumentIdRight, Escalation\r\n      | project UpdateTime, DocumentIdRight, Escalation)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| project CreateTimestamp, DocumentId = DocumentIdLeft, BuyerId, Escalation, BuyerName\r\n| summarize count() by BuyerName",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs in QA",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 16,
        "y": 35
      },
      "id": 18,
      "maxPerRow": 4,
      "options": {
        "colorMode": "background",
        "graphMode": "area",
        "justifyMode": "center",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [],
          "fields": "/^PastSLA$/",
          "values": true
        },
        "text": {},
        "textMode": "value_and_name"
      },
      "pluginVersion": "9.3.2",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId !in ($TrainingPortalIds)\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"], BuyerName = tostring(customDimensions[\"buyerName\"])\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| extend TimeSinceCreation = now() - CreateTimestamp\r\n| project PastSla = TimeSinceCreation >= 1d, BuyerId, BuyerName\r\n| summarize PastSLA = countif(PastSla) by BuyerName",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs Missing SLA",
      "type": "stat"
    },
    {
      "collapsed": false,
      "datasource": {
        "type": "datasource",
        "uid": "grafana"
      },
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 40
      },
      "id": 8,
      "panels": [],
      "targets": [
        {
          "datasource": {
            "type": "datasource",
            "uid": "grafana"
          },
          "refId": "A"
        }
      ],
      "title": "Stat Panels",
      "type": "row"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 0,
        "y": 41
      },
      "id": 5,
      "options": {
        "colorMode": "background",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [],
          "fields": "",
          "values": true
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents\r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId !in ($TrainingPortalIds)\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"]\r\n| join kind = leftanti (customEvents\r\n      | where name contains \"Document Updated\" and $__timeFilter(timestamp)\r\n      | extend Timestamp = timestamp\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | project Timestamp, Escalation = tostring(customDimensions[\"escalationCategoryIssue\"]), DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| project CreateTimestamp, DocumentId = DocumentIdLeft, BuyerId\r\n| summarize count()",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs in Pending",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 8,
        "y": 41
      },
      "id": 11,
      "maxPerRow": 4,
      "options": {
        "colorMode": "background",
        "graphMode": "area",
        "justifyMode": "auto",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": true
        },
        "textMode": "auto"
      },
      "pluginVersion": "9.3.2",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId !in ($TrainingPortalIds)\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"]\r\n| join (customEvents\r\n      | where name contains \"Document Updated\" and $__timeFilter(timestamp)\r\n      | extend Timestamp = timestamp\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | project Timestamp, Escalation = tostring(customDimensions[\"escalationCategoryIssue\"]), DocumentIdRight\r\n      | summarize UpdateTime = max(Timestamp) by DocumentIdRight, Escalation\r\n      | project UpdateTime, DocumentIdRight, Escalation)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| project CreateTimestamp, DocumentId = DocumentIdLeft, BuyerId, Escalation\r\n| summarize count()\r\n",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs in QA",
      "type": "stat"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 5,
        "w": 8,
        "x": 16,
        "y": 41
      },
      "id": 4,
      "maxPerRow": 4,
      "options": {
        "colorMode": "background",
        "graphMode": "area",
        "justifyMode": "center",
        "orientation": "auto",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "/^PastSLA$/",
          "values": true
        },
        "text": {},
        "textMode": "value"
      },
      "pluginVersion": "9.3.2",
      "repeat": "TimeGrain",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId !in ($TrainingPortalIds)\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, BuyerName = customDimensions[\"buyerName\"], User = customDimensions[\"user\"]\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| extend TimeSinceCreation = now() - CreateTimestamp\r\n| project PastSla = TimeSinceCreation >= 1d, BuyerId\r\n| summarize PastSLA = countif(PastSla)",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs Missing SLA",
      "type": "stat"
    },
    {
      "collapsed": false,
      "datasource": {
        "type": "datasource",
        "uid": "grafana"
      },
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 46
      },
      "id": 10,
      "panels": [],
      "targets": [
        {
          "datasource": {
            "type": "datasource",
            "uid": "grafana"
          },
          "refId": "A"
        }
      ],
      "title": "Tables",
      "type": "row"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "auto",
            "displayMode": "auto",
            "inspect": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 60
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "HoursSinceCreation {BuyerId=\"3706256\", BuyerName=\"AvidCaptureTesting RumbleOn\", DocumentId=\"00558636-265e-4125-bc7e-39e6ae7a9c1e\", PastSla=\"false\", TimeSinceCreation=\"22:10:21.5669429\"}"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 210
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "HoursSinceCreation {BuyerId=\"3706256\", BuyerName=\"AvidCaptureTesting RumbleOn\", DocumentId=\"000c1ab3-c9f3-4d69-9cf6-ee9ddcbb4189\", PastSla=\"false\"}"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 277
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "BuyerName"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 280
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 24,
        "x": 0,
        "y": 47
      },
      "id": 6,
      "options": {
        "footer": {
          "fields": "",
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": true,
        "sortBy": []
      },
      "pluginVersion": "9.1.6",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId != \"3706256\" and BuyerId != \"3706258\" and BuyerId != \"3706257\"\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"], BuyerName = tostring(customDimensions[\"buyerName\"])\r\n| join kind = leftanti (customEvents\r\n      | where name contains \"Document Updated\" and $__timeFilter(timestamp)\r\n      | extend Timestamp = timestamp\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | project Timestamp, Escalation = tostring(customDimensions[\"escalationCategoryIssue\"]), DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| extend TimeSinceCreation = now() - CreateTimestamp\r\n| project PastSla = TimeSinceCreation >= 1d, HoursSinceCreation = TimeSinceCreation/1h, BuyerId, BuyerName\r\n| summarize Total = count(),\r\n      PastSLA = countif(PastSla),\r\n      1HourOrLessToSLA = countif(HoursSinceCreation >= 23 and HoursSinceCreation < 24),\r\n      2HoursToSLA = countif(HoursSinceCreation >= 22 and HoursSinceCreation < 23),\r\n      3HoursToSLA = countif(HoursSinceCreation >= 21 and HoursSinceCreation < 22),\r\n      4HoursToSLA = countif(HoursSinceCreation >= 20 and HoursSinceCreation < 21),\r\n      5HoursToSLA = countif(HoursSinceCreation >= 19 and HoursSinceCreation < 20),\r\n      6HoursToSLA = countif(HoursSinceCreation >= 18 and HoursSinceCreation < 19),\r\n      7HoursToSLA = countif(HoursSinceCreation >= 17 and HoursSinceCreation < 18),\r\n      8HoursToSLA = countif(HoursSinceCreation >= 16 and HoursSinceCreation < 17),\r\n      9HoursToSLA = countif(HoursSinceCreation >= 15 and HoursSinceCreation < 16),\r\n      10HoursToSLA = countif(HoursSinceCreation >= 14 and HoursSinceCreation < 15),\r\n      11HoursToSLA = countif(HoursSinceCreation >= 13 and HoursSinceCreation < 14),\r\n      12HoursToSLA = countif(HoursSinceCreation >= 12 and HoursSinceCreation < 13),\r\n      13HoursToSLA = countif(HoursSinceCreation >= 11 and HoursSinceCreation < 12),\r\n      14HoursToSLA = countif(HoursSinceCreation >= 10 and HoursSinceCreation < 11),\r\n      15HoursToSLA = countif(HoursSinceCreation >= 9 and HoursSinceCreation < 10),\r\n      16HoursOrLessToSLA = countif(HoursSinceCreation < 8) by BuyerName\r\n",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs in Pending",
      "type": "table"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "auto",
            "displayMode": "auto",
            "inspect": false
          },
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              },
              {
                "color": "red",
                "value": 60
              }
            ]
          }
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "HoursSinceCreation {BuyerId=\"3706256\", BuyerName=\"AvidCaptureTesting RumbleOn\", DocumentId=\"00558636-265e-4125-bc7e-39e6ae7a9c1e\", PastSla=\"false\", TimeSinceCreation=\"22:10:21.5669429\"}"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 210
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "HoursSinceCreation {BuyerId=\"3706256\", BuyerName=\"AvidCaptureTesting RumbleOn\", DocumentId=\"000c1ab3-c9f3-4d69-9cf6-ee9ddcbb4189\", PastSla=\"false\"}"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 277
              }
            ]
          },
          {
            "matcher": {
              "id": "byName",
              "options": "BuyerName"
            },
            "properties": [
              {
                "id": "custom.width",
                "value": 280
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 24,
        "x": 0,
        "y": 54
      },
      "id": 12,
      "options": {
        "footer": {
          "fields": "",
          "reducer": [
            "sum"
          ],
          "show": false
        },
        "showHeader": true,
        "sortBy": []
      },
      "pluginVersion": "9.1.6",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| extend BuyerId = tostring(customDimensions[\"buyerId\"])\r\n| where name contains \"Document Created\" and $__timeFilter(timestamp) and BuyerId != \"3706256\" and BuyerId != \"3706258\" and BuyerId != \"3706257\"\r\n| extend CreateTimestamp = timestamp\r\n| project CreateTimestamp, CreateDateTime = customDimensions[\"uploadDatetime\"], DocumentIdLeft = tostring(customDimensions[\"documentId\"]), BuyerId, User = customDimensions[\"user\"], BuyerName = tostring(customDimensions[\"buyerName\"])\r\n| join (customEvents\r\n      | where name contains \"Document Updated\" and $__timeFilter(timestamp)\r\n      | extend Timestamp = timestamp\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | project Timestamp, Escalation = tostring(customDimensions[\"escalationCategoryIssue\"]), DocumentIdRight\r\n      | summarize UpdateTime = max(Timestamp) by DocumentIdRight, Escalation\r\n      | project UpdateTime, DocumentIdRight, Escalation)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| join kind = leftanti (customEvents\r\n      | extend DocumentIdRight = tostring(customDimensions[\"documentId\"])\r\n      | where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n      | project DocumentIdRight)\r\n      on $left.DocumentIdLeft == $right.DocumentIdRight\r\n| extend TimeSinceCreation = now() - CreateTimestamp\r\n| project PastSla = TimeSinceCreation >= 1d, HoursSinceCreation = TimeSinceCreation/1h, BuyerId, BuyerName\r\n| summarize Total = count(),\r\n      PastSLA = countif(PastSla),\r\n      1HourOrLessToSLA = countif(HoursSinceCreation >= 23 and HoursSinceCreation < 24),\r\n      2HoursToSLA = countif(HoursSinceCreation >= 22 and HoursSinceCreation < 23),\r\n      3HoursToSLA = countif(HoursSinceCreation >= 21 and HoursSinceCreation < 22),\r\n      4HoursToSLA = countif(HoursSinceCreation >= 20 and HoursSinceCreation < 21),\r\n      5HoursToSLA = countif(HoursSinceCreation >= 19 and HoursSinceCreation < 20),\r\n      6HoursToSLA = countif(HoursSinceCreation >= 18 and HoursSinceCreation < 19),\r\n      7HoursToSLA = countif(HoursSinceCreation >= 17 and HoursSinceCreation < 18),\r\n      8HoursToSLA = countif(HoursSinceCreation >= 16 and HoursSinceCreation < 17),\r\n      9HoursToSLA = countif(HoursSinceCreation >= 15 and HoursSinceCreation < 16),\r\n      10HoursToSLA = countif(HoursSinceCreation >= 14 and HoursSinceCreation < 15),\r\n      11HoursToSLA = countif(HoursSinceCreation >= 13 and HoursSinceCreation < 14),\r\n      12HoursToSLA = countif(HoursSinceCreation >= 12 and HoursSinceCreation < 13),\r\n      13HoursToSLA = countif(HoursSinceCreation >= 11 and HoursSinceCreation < 12),\r\n      14HoursToSLA = countif(HoursSinceCreation >= 10 and HoursSinceCreation < 11),\r\n      15HoursToSLA = countif(HoursSinceCreation >= 9 and HoursSinceCreation < 10),\r\n      16HoursOrLessToSLA = countif(HoursSinceCreation < 8) by BuyerName\r\n",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "table"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Docs in QA",
      "type": "table"
    },
    {
      "datasource": {
        "type": "grafana-azure-monitor-datasource",
        "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
      },
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "palette-classic"
          },
          "custom": {
            "axisLabel": "",
            "axisPlacement": "auto",
            "barAlignment": 0,
            "drawStyle": "line",
            "fillOpacity": 0,
            "gradientMode": "none",
            "hideFrom": {
              "legend": false,
              "tooltip": false,
              "viz": false
            },
            "lineInterpolation": "smooth",
            "lineWidth": 1,
            "pointSize": 5,
            "scaleDistribution": {
              "type": "linear"
            },
            "showPoints": "auto",
            "spanNulls": false,
            "stacking": {
              "group": "A",
              "mode": "none"
            },
            "thresholdsStyle": {
              "mode": "off"
            }
          },
          "displayName": "${__field.labels.__values}",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green"
              }
            ]
          }
        },
        "overrides": []
      },
      "gridPos": {
        "h": 7,
        "w": 24,
        "x": 0,
        "y": 61
      },
      "id": 13,
      "options": {
        "legend": {
          "calcs": [],
          "displayMode": "list",
          "placement": "bottom",
          "showLegend": true
        },
        "tooltip": {
          "mode": "single",
          "sort": "none"
        }
      },
      "pluginVersion": "8.4.2",
      "repeatDirection": "h",
      "targets": [
        {
          "azureLogAnalytics": {
            "query": "customEvents \r\n| where name contains \"Document Submitted\" and $__timeFilter(timestamp)\r\n| summarize Submisions = count() by name, bin(timestamp, 1h)\r\n| order by timestamp asc",
            "resource": "/subscriptions/f4d2e617-aaed-4636-a6b2-b030cf0dc847/resourceGroups/Ax-Ae1-Pr-IDC-InvoiceIndexing-RG/providers/Microsoft.Insights/components/AX-Ae1-Pr-IDC-InvIndx-INSIGHTS",
            "resultFormat": "time_series"
          },
          "azureMonitor": {
            "dimensionFilters": [],
            "timeGrain": "auto"
          },
          "datasource": {
            "type": "grafana-azure-monitor-datasource",
            "uid": "${DS_AZURE_MONITOR - SAAS_INFRA}"
          },
          "queryType": "Azure Log Analytics",
          "refId": "A",
          "subscription": "d5d4da15-d34e-4cf3-a14b-e565ec53a1e5"
        }
      ],
      "title": "Submissions",
      "type": "timeseries"
    }
  ],
  "refresh": "",
  "schemaVersion": 37,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": [
      {
        "current": {
          "selected": true,
          "text": [
            "All"
          ],
          "value": [
            "$__all"
          ]
        },
        "hide": 0,
        "includeAll": true,
        "label": "TrainingPortalIds",
        "multi": true,
        "name": "TrainingPortalIds",
        "options": [
          {
            "selected": true,
            "text": "All",
            "value": "$__all"
          },
          {
            "selected": false,
            "text": "3706256",
            "value": "3706256"
          },
          {
            "selected": false,
            "text": "3706257",
            "value": "3706257"
          },
          {
            "selected": false,
            "text": "3706258",
            "value": "3706258"
          }
        ],
        "query": "3706256,3706257,3706258",
        "queryValue": "",
        "skipUrlSync": false,
        "type": "custom"
      }
    ]
  },
  "time": {
    "from": "now-7d",
    "to": "now"
  },
  "timepicker": {},
  "timezone": "",
  "title": "Daily Management",
  "uid": "5i5yJqPnk",
  "version": 73,
  "weekStart": "",
  "gnetId": 18549,
  "description": "Daily Management"
}