Grafana example - BigQuery
The snippet can be accessed without any authentication.
Authored by
Antonio Gentile
Edited
grafana_bigquery.json 58.61 KiB
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"description": "Initial starting dashboard for video KPIs and QoE",
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": 1,
"iteration": 1670967397923,
"links": [],
"liveNow": false,
"panels": [
{
"gridPos": {
"h": 4,
"w": 24,
"x": 0,
"y": 0
},
"id": 17,
"options": {
"content": "<p align=\"center\">\n<H1 align=\"center\">\nDatazoom Sample Dashboard\n</h1>\n\n<font color=\"#005CB9\" face=\"courier\" size=\"5\">\n<h2>\nVideo Service KPIS grouped by Performance and QoE metrics\n</h2>\n</font>\n</p>\n\n",
"mode": "html"
},
"pluginVersion": "8.4.7",
"targets": [
{
"format": "time_series",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": false,
"rawSql": "SELECT\n time_column,\n value1\nFROM\n metric_table\nWHERE\n $__timeFilter(time_column)\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Video Service Dashboard",
"type": "text"
},
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 4
},
"id": 15,
"panels": [],
"title": "Usage Details",
"type": "row"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 0,
"y": 5
},
"id": 32,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT \n\tSUM(playbackDurationContent)/60000\nFROM (\n\t\tSELECT content_session_id,\n\t\t\tMAX(playback_duration_content_ms) as playbackDurationContent\n\t\tFROM crypto-catfish-317522.demo_index.JW_Gold\n\t\t WHERE $__timeFilter(timestamp)\n\n\t\tGROUP BY content_session_id\n\t)",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Content Minutes",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 4,
"y": 5
},
"id": 22,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n\tevent_type,\n\tCOUNT(*) AS events\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\nAND\n\tevent_type = 'media_request'\nAND\n\tmedia_type='content'\n\nGROUP BY\n\t1\nORDER BY events",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Content Requests",
"transformations": [],
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 8,
"y": 5
},
"id": 23,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n\tevent_type,\n\tCOUNT(*) AS events\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\nAND\n\tevent_type = 'playback_start'\nAND\n\tmedia_type='content'\n\nGROUP BY\n\t1\nORDER BY events\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Content Starts",
"transformations": [],
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "smooth",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"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": 12,
"w": 12,
"x": 12,
"y": 5
},
"id": 26,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "time_series",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n $__timeGroup(timestamp, $interval),\n count(distinct content_session_id) AS Viewers\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\n\nGROUP BY\n 1\nORDER BY\n 1 asc\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Concurrent Viewers over time",
"type": "timeseries"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 0,
"y": 11
},
"id": 36,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n\tCOUNT(DISTINCT app_session_id) AS app_sessions\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\n\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "App Sessions",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 4,
"y": 11
},
"id": 37,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n\tCOUNT(DISTINCT content_session_id) AS content_sessions\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\n\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Content Sessions",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 8,
"y": 11
},
"id": 38,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n\t(COUNT(DISTINCT content_session_id))*1 / (COUNT(DISTINCT app_session_id))*1\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\n\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Views per App Session",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": []
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 8,
"x": 0,
"y": 17
},
"id": 40,
"options": {
"legend": {
"displayMode": "table",
"placement": "right",
"values": [
"percent",
"value"
]
},
"pieType": "donut",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n count(content_session_id) AS Viewers,\n city AS TheCity\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\nAND\n \tevent_type = 'playback_start'\nAND\n\tmedia_type='content'\n\nGROUP BY\n 2\nORDER BY\n 1 DESC",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Popular Cities",
"type": "piechart"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": []
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 8,
"x": 8,
"y": 17
},
"id": 41,
"options": {
"legend": {
"displayMode": "table",
"placement": "right",
"values": [
"percent",
"value"
]
},
"pieType": "donut",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n count(content_session_id) AS Viewers,\n device_type AS TheDevice\nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\nAND\n \tevent_type = 'playback_start'\nAND\n\tmedia_type='content'\n\nGROUP BY\n 2\nORDER BY\n 1 DESC",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Popular Platforms",
"type": "piechart"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 8,
"x": 16,
"y": 17
},
"id": 13,
"options": {
"basemap": {
"config": {},
"type": "default"
},
"controls": {
"mouseWheelZoom": true,
"showAttribution": true,
"showDebug": false,
"showScale": false,
"showZoom": true
},
"layers": [
{
"config": {
"color": {
"fixed": "dark-green"
},
"fillOpacity": 0.4,
"shape": "circle",
"showLegend": true,
"size": {
"fixed": 5,
"max": 15,
"min": 2
}
},
"location": {
"mode": "auto"
},
"name": "Layer 1",
"type": "markers"
}
],
"view": {
"id": "north-america",
"lat": 40,
"lon": -100,
"zoom": 4
}
},
"pluginVersion": "8.4.7",
"targets": [
{
"dataset": "demo_index",
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"partitioned": false,
"partitionedField": "",
"project": "crypto-catfish-317522",
"rawQuery": false,
"rawSql": "SELECT\n time_column,\n value1\nFROM\n metric_table\nWHERE\n $__timeFilter(time_column)\n",
"refId": "A",
"select": [
[
{
"params": [
"latitude"
],
"type": "column"
}
],
[
{
"params": [
"longitude"
],
"type": "column"
}
]
],
"sharded": false,
"table": "JW_Gold",
"timeColumn": "timestamp",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Where are My Users",
"type": "geomap"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 23
},
"id": 49,
"options": {
"displayMode": "lcd",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "/^f0_$/",
"values": true
},
"showUnfilled": true
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n avg(startup_duration_content_ms)/1000.0,\n city\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\nAND\n event_type = 'playback_start'\n\nGROUP BY\n2\nORDER BY\n1\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Time to First Frame",
"type": "bargauge"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 12,
"y": 23
},
"id": 10,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"dataset": "demo_index",
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [
{
"params": [
"$__interval",
"none"
],
"type": "time"
}
],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"partitioned": false,
"partitionedField": "",
"project": "crypto-catfish-317522",
"rawQuery": true,
"rawSql": "SELECT\n avg(startup_duration_content_ms)/1000.0\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n event_type = 'playback_start'\nAND\n $__timeFilter(timestamp)\n",
"refId": "A",
"select": [
[
{
"params": [
"startup_duration_content_ms"
],
"type": "column"
},
{
"params": [
"avg"
],
"type": "aggregate"
}
]
],
"sharded": false,
"table": "JW_Gold",
"timeColumn": "timestamp",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
},
{
"name": "",
"params": [
"event_type",
"=",
"\"playback_start\""
],
"type": "expression"
}
]
}
],
"title": "First Frame Average",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 16,
"y": 29
},
"id": 33,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"dataset": "demo_index",
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [
{
"params": [
"$__interval",
"none"
],
"type": "time"
}
],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"partitioned": false,
"partitionedField": "",
"project": "crypto-catfish-317522",
"rawQuery": true,
"rawSql": "SELECT\n avg(stallDuration)/1000\nFROM (\n SELECT content_session_id,\n MAX(stall_duration_content_ms) as stallDuration\n FROM crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\nGROUP BY content_session_id \n)",
"refId": "A",
"select": [
[
{
"params": [
"startup_duration_content_ms"
],
"type": "column"
},
{
"params": [
"avg"
],
"type": "aggregate"
}
]
],
"sharded": false,
"table": "JW_Gold",
"timeColumn": "timestamp",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
},
{
"name": "",
"params": [
"event_type",
"=",
"\"playback_start\""
],
"type": "expression"
}
]
}
],
"title": "Stall Duration Average",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 20,
"y": 29
},
"id": 34,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"text": {},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"dataset": "demo_index",
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [
{
"params": [
"$__interval",
"none"
],
"type": "time"
}
],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"partitioned": false,
"partitionedField": "",
"project": "crypto-catfish-317522",
"rawQuery": true,
"rawSql": "SELECT\n((1 - CAST(SUM(CASE WHEN event_type = 'playback_start' and media_type='content' THEN 1 END) AS FLOAT64) / CAST(SUM(CASE WHEN event_type = 'media_request' and media_type='content' THEN 1 END) AS FLOAT64)) * 100) AS ebvs\n\nFROM crypto-catfish-317522.demo_index.JW_Gold\n\nWHERE\n $__timeFilter(timestamp)",
"refId": "A",
"select": [
[
{
"params": [
"startup_duration_content_ms"
],
"type": "column"
},
{
"params": [
"avg"
],
"type": "aggregate"
}
]
],
"sharded": false,
"table": "JW_Gold",
"timeColumn": "timestamp",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
},
{
"name": "",
"params": [
"event_type",
"=",
"\"playback_start\""
],
"type": "expression"
}
]
}
],
"title": "EBVS",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "smooth",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"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": 8,
"w": 12,
"x": 12,
"y": 35
},
"id": 44,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "time_series",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n $__timeGroup(timestamp, $interval),\n count(distinct content_session_id) AS Viewers\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\n\nGROUP BY\n 1\nORDER BY\n 1 asc\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Concurrent Viewers over time",
"type": "timeseries"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "smooth",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"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": 8,
"w": 12,
"x": 12,
"y": 43
},
"id": 45,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "time_series",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n $__timeGroup(timestamp, $interval),\n count(*) AS Requests\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\nAND\n event_type = 'media_request'\nAND\n media_type = 'content'\n \n\nGROUP BY\n 1\nORDER BY\n 1 asc\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Concurrent Requests over time",
"type": "timeseries"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "smooth",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"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": 8,
"w": 12,
"x": 12,
"y": 51
},
"id": 46,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "time_series",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n $__timeGroup(timestamp, $interval),\n count(*) AS Starts\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\nAND\n event_type = 'playback_start'\nAND\n media_type = 'content'\n \n\nGROUP BY\n 1\nORDER BY\n 1 asc\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Content Starts over time",
"type": "timeseries"
},
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 59
},
"id": 6,
"panels": [],
"title": "QoE",
"type": "row"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "Mbits"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 4,
"x": 0,
"y": 60
},
"id": 21,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "8.4.7",
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n avg(rendition_video_bitrate_kbps) AS playback_rate\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\n \n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Bitrate Average",
"type": "stat"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 20,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "smooth",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"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": 8,
"w": 15,
"x": 4,
"y": 60
},
"id": 30,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "time_series",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n $__timeGroup(timestamp, $interval),\n avg(rendition_video_bitrate_kbps)/1000\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\n\nGROUP by\n 1\nORDER BY\n time\n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Bitrate average",
"type": "timeseries"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "auto",
"displayMode": "auto"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "app_session_id"
},
"properties": [
{
"id": "custom.width",
"value": 283
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 5,
"x": 19,
"y": 60
},
"id": 4,
"options": {
"footer": {
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true,
"sortBy": []
},
"pluginVersion": "8.4.7",
"targets": [
{
"dataset": "demo_index",
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [
{
"params": [
"app_session_id"
],
"type": "column"
}
],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"partitioned": false,
"partitionedField": "",
"project": "crypto-catfish-317522",
"rawQuery": true,
"rawSql": "SELECT DISTINCT app_session_id\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\nLIMIT 500",
"refId": "A",
"select": [
[
{
"params": [
"app_session_id"
],
"type": "column"
}
]
],
"sharded": false,
"table": "JW_Gold",
"timeColumn": "timestamp",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "User Session IDs",
"type": "table"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"fillOpacity": 80,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineWidth": 1,
"scaleDistribution": {
"type": "linear"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 68
},
"id": 48,
"options": {
"barRadius": 0,
"barWidth": 0.97,
"groupWidth": 0.7,
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom"
},
"orientation": "auto",
"showValue": "auto",
"stacking": "none",
"tooltip": {
"mode": "single",
"sort": "none"
},
"xTickLabelRotation": 0,
"xTickLabelSpacing": 0
},
"targets": [
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"rawQuery": true,
"rawSql": "SELECT\n event_type,\n COUNT(*) as events\nFROM\n crypto-catfish-317522.demo_index.JW_Gold\nWHERE\n $__timeFilter(timestamp)\nGROUP BY\n 1\nORDER BY events \n",
"refId": "A",
"select": [
[
{
"params": [
"-- value --"
],
"type": "column"
}
]
],
"timeColumn": "-- time --",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Events",
"type": "barchart"
},
{
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "auto",
"displayMode": "auto"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 5,
"x": 19,
"y": 68
},
"id": 28,
"options": {
"footer": {
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true
},
"pluginVersion": "8.4.7",
"targets": [
{
"dataset": "demo_index",
"datasource": {
"type": "doitintl-bigquery-datasource",
"uid": "e2nCcBfnk"
},
"format": "table",
"group": [],
"hide": false,
"metricColumn": "none",
"orderByCol": "1",
"orderBySort": "1",
"partitioned": false,
"partitionedField": "",
"project": "crypto-catfish-317522",
"rawQuery": true,
"rawSql": "SELECT\n\ttimestamp as time,\n\tevent_type \nFROM\n\tcrypto-catfish-317522.demo_index.JW_Gold\nWHERE\n\t$__timeFilter(timestamp)\nLIMIT\n\t1000",
"refId": "A",
"select": [
[
{
"params": [
"event_type"
],
"type": "column"
}
]
],
"sharded": false,
"table": "JW_Gold",
"timeColumn": "timestamp",
"timeColumnType": "TIMESTAMP",
"where": [
{
"name": "$__timeFilter",
"params": [],
"type": "macro"
}
]
}
],
"title": "Player Events",
"type": "table"
}
],
"refresh": "",
"schemaVersion": 35,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
"auto": false,
"auto_count": 30,
"auto_min": "10s",
"current": {
"selected": false,
"text": "1m",
"value": "1m"
},
"hide": 0,
"label": "interval",
"name": "interval",
"options": [
{
"selected": true,
"text": "1m",
"value": "1m"
},
{
"selected": false,
"text": "10m",
"value": "10m"
},
{
"selected": false,
"text": "30m",
"value": "30m"
},
{
"selected": false,
"text": "1h",
"value": "1h"
},
{
"selected": false,
"text": "6h",
"value": "6h"
},
{
"selected": false,
"text": "12h",
"value": "12h"
},
{
"selected": false,
"text": "1d",
"value": "1d"
},
{
"selected": false,
"text": "7d",
"value": "7d"
},
{
"selected": false,
"text": "14d",
"value": "14d"
},
{
"selected": false,
"text": "30d",
"value": "30d"
}
],
"query": "1m,10m,30m,1h,6h,12h,1d,7d,14d,30d",
"refresh": 2,
"skipUrlSync": false,
"type": "interval"
}
]
},
"time": {
"from": "now-6h",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "Video Quality Dashboard",
"uid": "x_-D82Gnz",
"version": 41,
"weekStart": ""
}
Please register or sign in to comment