NickKalar/databricks_incidents
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
databricks_incidents/Incident Exploration.ipynb

2246 lines
107 KiB
Plaintext
Raw Permalink Blame History

{
"cells": [
{
"cell_type": "code",
"execution_count": 0,
"metadata": {
"application/vnd.databricks.v1+cell": {
"cellMetadata": {
"byteLimit": 2048000,
"rowLimit": 10000
},
"inputWidgets": {},
"nuid": "5b2cb513-1502-485d-847e-285fb2a59b48",
"showTitle": false,
"tableResultSettingsMap": {
"0": {
"dataGridStateBlob": "{\"version\":1,\"tableState\":{\"columnPinning\":{\"left\":[\"#row_number#\"],\"right\":[]},\"columnSizing\":{\"ci\":147},\"columnVisibility\":{}},\"settings\":{\"columns\":{}},\"syncTimestamp\":1763082393761}",
"filterBlob": null,
"queryPlanFiltersBlob": null,
"tableResultIndex": 0
}
},
"title": ""
}
},
"outputs": [
{
"output_type": "display_data",
"data": {
"text/html": [
"<style scoped>\n",
" .table-result-container {\n",
" max-height: 300px;\n",
" overflow: auto;\n",
" }\n",
" table, th, td {\n",
" border: 1px solid black;\n",
" border-collapse: collapse;\n",
" }\n",
" th, td {\n",
" padding: 5px;\n",
" }\n",
" th {\n",
" text-align: left;\n",
" }\n",
"</style><div class='table-result-container'><table class='table-result'><thead style='background-color: white'><tr><th>number</th><th>location</th><th>state</th><th>ci</th><th>priority</th><th>short_description</th><th>description</th><th>assignment_group</th><th>assigned_to</th><th>sys_created_on</th><th>resolved_at</th></tr></thead><tbody><tr><td>1000</td><td>Madison Ave</td><td>Cancelled</td><td>New Issue</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-11-13 07:32:56 PM</td><td>2025-11-13 11:51:30 PM</td></tr><tr><td>1007</td><td>Fifth Ave</td><td>Cancelled</td><td>New Issue</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-11-13 08:08:37 AM</td><td>2025-11-13 05:10:10 PM</td></tr><tr><td>1014</td><td>Bourbon St</td><td>On Hold</td><td>Cash Drawer iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-11-13 04:50:06 AM</td><td>null</td></tr><tr><td>1021</td><td>Santa Monica Blvd</td><td>Cancelled</td><td>Card Reader Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-11-12 07:13:40 PM</td><td>2025-11-13 07:33:11 AM</td></tr><tr><td>1028</td><td>Park Ave</td><td>Resolved</td><td>Printer iOS</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-11-12 07:31:01 AM</td><td>2025-11-13 04:59:04 AM</td></tr><tr><td>1035</td><td>Miccosukee Rd</td><td>On Hold</td><td>Connectivity iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-11-11 02:29:59 PM</td><td>null</td></tr><tr><td>1042</td><td>Magnolia Blvd</td><td>On Hold</td><td>Menu Issue iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-11-10 02:44:04 PM</td><td>null</td></tr><tr><td>1049</td><td>Canal St</td><td>On Hold</td><td>Receipt Printer</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-11-09 07:04:26 PM</td><td>null</td></tr><tr><td>1056</td><td>Pennsylvania Ave</td><td>Cancelled</td><td>Card Reader Android</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-11-09 08:04:09 AM</td><td>2025-11-10 03:59:51 AM</td></tr><tr><td>1063</td><td>Lombard St</td><td>Resolved</td><td>POS Hardware iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-11-08 08:38:25 AM</td><td>2025-11-09 05:42:33 AM</td></tr><tr><td>1070</td><td>Market St</td><td>Cancelled</td><td>KPS Hardware</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-11-08 06:09:42 AM</td><td>2025-11-09 05:42:00 AM</td></tr><tr><td>1077</td><td>DEN</td><td>Resolved</td><td>Card Reader Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-11-07 05:23:24 PM</td><td>2025-11-07 08:46:15 PM</td></tr><tr><td>1084</td><td>DEN</td><td>Cancelled</td><td>Connectivity iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-11-07 09:22:49 AM</td><td>2025-11-07 02:47:01 PM</td></tr><tr><td>1091</td><td>Pennsylvania Ave</td><td>Work In Progress</td><td>Printer iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-11-06 09:49:43 AM</td><td>null</td></tr><tr><td>1098</td><td>Madison Ave</td><td>Work In Progress</td><td>Order Accuracy Issue</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-11-05 12:39:57 PM</td><td>null</td></tr><tr><td>1105</td><td>Canal St</td><td>Resolved</td><td>Sticky Printer</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-11-04 10:57:31 PM</td><td>2025-11-05 02:10:19 AM</td></tr><tr><td>1112</td><td>Baker St</td><td>Cancelled</td><td>Card Reader iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-11-04 01:19:03 PM</td><td>2025-11-05 11:23:28 AM</td></tr><tr><td>1119</td><td>Miccosukee Rd</td><td>Resolved</td><td>Menu Issue Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-11-04 12:27:57 AM</td><td>2025-11-05 12:26:15 AM</td></tr><tr><td>1126</td><td>Canal St</td><td>Cancelled</td><td>Menu Issue Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-11-03 11:04:48 PM</td><td>2025-11-04 12:40:51 PM</td></tr><tr><td>1133</td><td>Broadway</td><td>Cancelled</td><td>Connectivity Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-11-03 06:05:49 AM</td><td>2025-11-04 01:16:54 AM</td></tr><tr><td>1140</td><td>Park Ave</td><td>Cancelled</td><td>Sticky Printer</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-11-02 07:26:49 AM</td><td>2025-11-02 06:37:40 PM</td></tr><tr><td>1147</td><td>Pennsylvania Ave</td><td>Resolved</td><td>Receipt Printer</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-11-01 04:23:39 PM</td><td>2025-11-02 11:50:20 AM</td></tr><tr><td>1154</td><td>Abbey Road</td><td>Resolved</td><td>Printer Android</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-31 07:41:46 PM</td><td>2025-10-31 11:45:15 PM</td></tr><tr><td>1161</td><td>Santa Monica Blvd</td><td>Cancelled</td><td>KPS Hardware</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-31 03:18:07 PM</td><td>2025-10-31 09:49:48 PM</td></tr><tr><td>1168</td><td>Broadway</td><td>Cancelled</td><td>New Issue</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-30 11:16:12 PM</td><td>2025-10-31 04:07:22 PM</td></tr><tr><td>1175</td><td>Bourbon St</td><td>Cancelled</td><td>Cash Drawer Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-30 05:23:52 AM</td><td>2025-10-30 08:21:55 PM</td></tr><tr><td>1182</td><td>MIA</td><td>Cancelled</td><td>Cash Drawer iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-29 05:59:37 AM</td><td>2025-10-29 06:03:34 PM</td></tr><tr><td>1189</td><td>Canal St</td><td>Resolved</td><td>Card Reader Android</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-28 11:16:53 AM</td><td>2025-10-29 04:58:03 AM</td></tr><tr><td>1196</td><td>Santa Monica Blvd</td><td>Cancelled</td><td>KPS Hardware</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-27 12:35:25 PM</td><td>2025-10-28 10:33:36 AM</td></tr><tr><td>1203</td><td>Magnolia Blvd</td><td>Resolved</td><td>Connectivity iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-26 09:57:28 PM</td><td>2025-10-27 07:48:28 AM</td></tr><tr><td>1210</td><td>Baker St</td><td>Cancelled</td><td>Connectivity iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-26 08:45:35 PM</td><td>2025-10-26 10:34:32 PM</td></tr><tr><td>1217</td><td>Broadway</td><td>Cancelled</td><td>Card Reader iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-26 03:38:04 AM</td><td>2025-10-26 09:50:10 PM</td></tr><tr><td>1224</td><td>Pennsylvania Ave</td><td>Cancelled</td><td>New Issue</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-25 05:30:25 PM</td><td>2025-10-25 06:07:23 PM</td></tr><tr><td>1231</td><td>Washington Ave</td><td>On Hold</td><td>Cash Drawer Android</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-24 06:12:58 PM</td><td>null</td></tr><tr><td>1238</td><td>Santa Monica Blvd</td><td>On Hold</td><td>Menu Issue iOS</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-24 09:51:59 AM</td><td>null</td></tr><tr><td>1245</td><td>MIA</td><td>On Hold</td><td>Connectivity iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-10-24 09:33:57 AM</td><td>null</td></tr><tr><td>1252</td><td>Pennsylvania Ave</td><td>On Hold</td><td>Connectivity iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-24 04:18:48 AM</td><td>null</td></tr><tr><td>1259</td><td>Los Vegas Strip</td><td>Resolved</td><td>Order Accuracy Issue</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-24 02:08:40 AM</td><td>2025-10-24 01:49:21 PM</td></tr><tr><td>1266</td><td>DEN</td><td>On Hold</td><td>Connectivity Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-10-23 08:20:56 PM</td><td>null</td></tr><tr><td>1273</td><td>MIA</td><td>On Hold</td><td>Card Reader iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-23 09:06:09 AM</td><td>null</td></tr><tr><td>1280</td><td>Lombard St</td><td>Resolved</td><td>Connectivity iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-22 04:14:35 PM</td><td>2025-10-23 12:21:51 PM</td></tr><tr><td>1287</td><td>DFW</td><td>Cancelled</td><td>Printer Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-22 01:14:02 PM</td><td>2025-10-23 08:03:14 AM</td></tr><tr><td>1294</td><td>Broadway</td><td>Cancelled</td><td>Connectivity Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-22 10:56:26 AM</td><td>2025-10-23 03:33:02 AM</td></tr><tr><td>1301</td><td>Wall St</td><td>Cancelled</td><td>Configuration Issue</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-22 07:59:54 AM</td><td>2025-10-22 07:43:18 PM</td></tr><tr><td>1308</td><td>Bourbon St</td><td>Resolved</td><td>Connectivity iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-21 03:38:28 PM</td><td>2025-10-22 02:22:02 PM</td></tr><tr><td>1315</td><td>Lombard St</td><td>Cancelled</td><td>Receipt Printer</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-21 06:52:45 AM</td><td>2025-10-22 12:22:44 AM</td></tr><tr><td>1322</td><td>Pennsylvania Ave</td><td>On Hold</td><td>Receipt Printer</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-20 11:21:10 PM</td><td>null</td></tr><tr><td>1329</td><td>Wall St</td><td>Resolved</td><td>POS Hardware iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-20 01:46:11 PM</td><td>2025-10-20 06:00:56 PM</td></tr><tr><td>1336</td><td>MIA</td><td>On Hold</td><td>Connectivity iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-20 06:10:30 AM</td><td>null</td></tr><tr><td>1343</td><td>DEN</td><td>Cancelled</td><td>Order Accuracy Issue</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-19 02:04:55 PM</td><td>2025-10-19 03:03:19 PM</td></tr><tr><td>1350</td><td>Los Vegas Strip</td><td>Cancelled</td><td>POS Hardware iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-18 08:36:53 PM</td><td>2025-10-19 12:07:24 PM</td></tr><tr><td>1357</td><td>Abbey Road</td><td>Resolved</td><td>Menu Issue Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-18 05:51:27 PM</td><td>2025-10-19 03:51:01 AM</td></tr><tr><td>1364</td><td>Wall St</td><td>Resolved</td><td>Order Accuracy Issue</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-17 07:48:00 PM</td><td>2025-10-17 10:54:26 PM</td></tr><tr><td>1371</td><td>Wall St</td><td>Cancelled</td><td>Bump Bar</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-17 02:01:53 AM</td><td>2025-10-17 12:20:31 PM</td></tr><tr><td>1378</td><td>Baker St</td><td>Resolved</td><td>Printer Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-16 02:05:15 AM</td><td>2025-10-16 10:28:01 AM</td></tr><tr><td>1385</td><td>DFW</td><td>Resolved</td><td>Connectivity Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-15 04:15:55 AM</td><td>2025-10-16 03:32:13 AM</td></tr><tr><td>1392</td><td>Los Vegas Strip</td><td>Cancelled</td><td>Connectivity Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-15 12:05:52 AM</td><td>2025-10-15 06:02:43 PM</td></tr><tr><td>1399</td><td>Washington Ave</td><td>Resolved</td><td>Sticky Printer</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-14 09:11:24 AM</td><td>2025-10-14 10:38:34 AM</td></tr><tr><td>1406</td><td>Bourbon St</td><td>Cancelled</td><td>Bump Bar</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-14 04:11:06 AM</td><td>2025-10-14 10:19:03 PM</td></tr><tr><td>1413</td><td>Market St</td><td>Resolved</td><td>Printer Android</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-13 08:04:31 AM</td><td>2025-10-13 09:47:22 AM</td></tr><tr><td>1420</td><td>Market St</td><td>Cancelled</td><td>Printer iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-12 03:16:23 PM</td><td>2025-10-13 03:18:28 AM</td></tr><tr><td>1427</td><td>DFW</td><td>Cancelled</td><td>KPS Hardware</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-11 06:55:14 PM</td><td>2025-10-12 11:26:14 AM</td></tr><tr><td>1434</td><td>Bourbon St</td><td>Cancelled</td><td>Menu Issue iOS</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-10-11 11:18:55 AM</td><td>2025-10-11 05:51:47 PM</td></tr><tr><td>1441</td><td>Wall St</td><td>Cancelled</td><td>Card Reader iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-11 02:57:09 AM</td><td>2025-10-11 06:02:54 PM</td></tr><tr><td>1448</td><td>Market St</td><td>Resolved</td><td>Order Accuracy Issue</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-11 01:12:16 AM</td><td>2025-10-11 05:33:15 PM</td></tr><tr><td>1455</td><td>LAX</td><td>Cancelled</td><td>Sticky Printer</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-10 04:13:09 PM</td><td>2025-10-10 11:25:09 PM</td></tr><tr><td>1462</td><td>Abbey Road</td><td>Resolved</td><td>Cash Drawer Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-10 06:38:45 AM</td><td>2025-10-10 11:16:11 AM</td></tr><tr><td>1469</td><td>Broadway</td><td>Resolved</td><td>POS Hardware iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-10 04:59:50 AM</td><td>2025-10-10 06:44:38 PM</td></tr><tr><td>1476</td><td>Canal St</td><td>Resolved</td><td>Printer iOS</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-09 02:08:11 PM</td><td>2025-10-10 06:56:02 AM</td></tr><tr><td>1483</td><td>Pennsylvania Ave</td><td>Resolved</td><td>Configuration Issue</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-09 03:50:56 AM</td><td>2025-10-09 11:18:49 AM</td></tr><tr><td>1490</td><td>Park Ave</td><td>Resolved</td><td>Cash Drawer Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-08 03:00:38 PM</td><td>2025-10-09 04:02:37 AM</td></tr><tr><td>1497</td><td>Madison Ave</td><td>Cancelled</td><td>New Issues iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-08 10:54:33 AM</td><td>2025-10-09 12:29:03 AM</td></tr><tr><td>1504</td><td>DFW</td><td>Cancelled</td><td>Printer Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-08 09:26:36 AM</td><td>2025-10-08 10:02:06 AM</td></tr><tr><td>1511</td><td>Wall St</td><td>Resolved</td><td>Menu Issue Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-08 03:33:24 AM</td><td>2025-10-08 11:37:53 PM</td></tr><tr><td>1518</td><td>Fifth Ave</td><td>Cancelled</td><td>Printer iOS</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-07 10:17:28 PM</td><td>2025-10-08 05:38:21 AM</td></tr><tr><td>1525</td><td>Lombard St</td><td>Resolved</td><td>Card Reader Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Jacob Yero</td><td>2025-10-07 09:24:37 PM</td><td>2025-10-07 09:38:13 PM</td></tr><tr><td>1532</td><td>Abbey Road</td><td>Cancelled</td><td>Order Accuracy Issue</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-10-07 07:45:54 AM</td><td>2025-10-07 01:11:47 PM</td></tr><tr><td>1539</td><td>Bourbon St</td><td>Resolved</td><td>POS Hardware iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-07 05:15:50 AM</td><td>2025-10-07 05:39:23 PM</td></tr><tr><td>1546</td><td>Canal St</td><td>Cancelled</td><td>Connectivity Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-06 11:44:40 PM</td><td>2025-10-07 05:33:58 AM</td></tr><tr><td>1553</td><td>LAX</td><td>Cancelled</td><td>POS Hardware Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-06 04:21:50 PM</td><td>2025-10-07 07:31:28 AM</td></tr><tr><td>1560</td><td>Park Ave</td><td>Cancelled</td><td>KPS Hardware</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-05 10:20:03 PM</td><td>2025-10-06 07:32:04 AM</td></tr><tr><td>1567</td><td>Lombard St</td><td>Resolved</td><td>New Issues iOS</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-10-05 05:27:36 PM</td><td>2025-10-05 11:57:24 PM</td></tr><tr><td>1574</td><td>Miccosukee Rd</td><td>Cancelled</td><td>New Issues Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-10-04 07:13:26 PM</td><td>2025-10-05 05:04:46 PM</td></tr><tr><td>1581</td><td>Fifth Ave</td><td>Cancelled</td><td>Connectivity Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-04 02:27:27 AM</td><td>2025-10-04 03:24:01 AM</td></tr><tr><td>1588</td><td>Washington Ave</td><td>Resolved</td><td>New Issue</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-03 02:58:14 PM</td><td>2025-10-04 09:09:08 AM</td></tr><tr><td>1595</td><td>LAX</td><td>Resolved</td><td>Receipt Printer</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-02 11:45:40 PM</td><td>2025-10-03 09:53:42 PM</td></tr><tr><td>1602</td><td>DEN</td><td>Cancelled</td><td>Cash Drawer Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-02 02:21:28 AM</td><td>2025-10-02 07:46:38 PM</td></tr><tr><td>1609</td><td>Washington Ave</td><td>Cancelled</td><td>Menu Issue iOS</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-10-01 04:36:45 PM</td><td>2025-10-02 02:00:55 PM</td></tr><tr><td>1616</td><td>Madison Ave</td><td>Cancelled</td><td>New Issue</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-10-01 12:03:51 PM</td><td>2025-10-02 05:48:53 AM</td></tr><tr><td>1623</td><td>Miccosukee Rd</td><td>Cancelled</td><td>Bump Bar</td><td>P2 - High</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-10-01 08:44:38 AM</td><td>2025-10-02 04:55:33 AM</td></tr><tr><td>1630</td><td>Fifth Ave</td><td>Resolved</td><td>POS Hardware iOS</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-09-30 04:31:29 PM</td><td>2025-09-30 06:04:33 PM</td></tr><tr><td>1637</td><td>Madison Ave</td><td>Cancelled</td><td>KPS Hardware</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-09-30 03:31:36 AM</td><td>2025-09-30 09:50:25 PM</td></tr><tr><td>1644</td><td>MIA</td><td>Resolved</td><td>POS Hardware Android</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Michelle Crawford</td><td>2025-09-29 02:49:25 PM</td><td>2025-09-30 04:05:53 AM</td></tr><tr><td>1651</td><td>Market St</td><td>Resolved</td><td>New Issue</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-09-29 05:43:10 AM</td><td>2025-09-29 08:57:40 PM</td></tr><tr><td>1658</td><td>Baker St</td><td>Resolved</td><td>Card Reader Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Jeff Singleton</td><td>2025-09-29 01:54:26 AM</td><td>2025-09-29 01:34:59 PM</td></tr><tr><td>1665</td><td>DFW</td><td>Cancelled</td><td>Connectivity Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L4</td><td>Nick Kalar</td><td>2025-09-28 06:52:25 AM</td><td>2025-09-28 02:58:05 PM</td></tr><tr><td>1672</td><td>Park Ave</td><td>Resolved</td><td>Connectivity Android</td><td>P4 - Low</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-09-27 01:13:50 PM</td><td>2025-09-27 03:38:51 PM</td></tr><tr><td>1679</td><td>Miccosukee Rd</td><td>Resolved</td><td>POS Hardware iOS</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-09-27 09:03:47 AM</td><td>2025-09-27 07:42:38 PM</td></tr><tr><td>1686</td><td>Miccosukee Rd</td><td>Cancelled</td><td>Order Accuracy Issue</td><td>P3 - Medium</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Adam Lee</td><td>2025-09-26 03:59:27 PM</td><td>2025-09-26 06:51:01 PM</td></tr><tr><td>1693</td><td>Los Vegas Strip</td><td>Resolved</td><td>Card Reader Android</td><td>P1 - Critical</td><td>Lorem ipsum</td><td>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</td><td>Managed Support L3</td><td>Kevin Von Stork</td><td>2025-09-26 05:43:27 AM</td><td>2025-09-26 01:17:18 PM</td></tr></tbody></table></div>"
]
},
"metadata": {
"application/vnd.databricks.v1+output": {
"addedWidgets": {},
"aggData": [],
"aggError": "",
"aggOverflow": false,
"aggSchema": [],
"aggSeriesLimitReached": false,
"aggType": "",
"arguments": {},
"columnCustomDisplayInfos": {},
"data": [
[
1000,
"Madison Ave",
"Cancelled",
"New Issue",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-11-13 07:32:56 PM",
"2025-11-13 11:51:30 PM"
],
[
1007,
"Fifth Ave",
"Cancelled",
"New Issue",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-11-13 08:08:37 AM",
"2025-11-13 05:10:10 PM"
],
[
1014,
"Bourbon St",
"On Hold",
"Cash Drawer iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-11-13 04:50:06 AM",
null
],
[
1021,
"Santa Monica Blvd",
"Cancelled",
"Card Reader Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-11-12 07:13:40 PM",
"2025-11-13 07:33:11 AM"
],
[
1028,
"Park Ave",
"Resolved",
"Printer iOS",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-11-12 07:31:01 AM",
"2025-11-13 04:59:04 AM"
],
[
1035,
"Miccosukee Rd",
"On Hold",
"Connectivity iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-11-11 02:29:59 PM",
null
],
[
1042,
"Magnolia Blvd",
"On Hold",
"Menu Issue iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-11-10 02:44:04 PM",
null
],
[
1049,
"Canal St",
"On Hold",
"Receipt Printer",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-11-09 07:04:26 PM",
null
],
[
1056,
"Pennsylvania Ave",
"Cancelled",
"Card Reader Android",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-11-09 08:04:09 AM",
"2025-11-10 03:59:51 AM"
],
[
1063,
"Lombard St",
"Resolved",
"POS Hardware iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-11-08 08:38:25 AM",
"2025-11-09 05:42:33 AM"
],
[
1070,
"Market St",
"Cancelled",
"KPS Hardware",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-11-08 06:09:42 AM",
"2025-11-09 05:42:00 AM"
],
[
1077,
"DEN",
"Resolved",
"Card Reader Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-11-07 05:23:24 PM",
"2025-11-07 08:46:15 PM"
],
[
1084,
"DEN",
"Cancelled",
"Connectivity iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-11-07 09:22:49 AM",
"2025-11-07 02:47:01 PM"
],
[
1091,
"Pennsylvania Ave",
"Work In Progress",
"Printer iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-11-06 09:49:43 AM",
null
],
[
1098,
"Madison Ave",
"Work In Progress",
"Order Accuracy Issue",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-11-05 12:39:57 PM",
null
],
[
1105,
"Canal St",
"Resolved",
"Sticky Printer",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-11-04 10:57:31 PM",
"2025-11-05 02:10:19 AM"
],
[
1112,
"Baker St",
"Cancelled",
"Card Reader iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-11-04 01:19:03 PM",
"2025-11-05 11:23:28 AM"
],
[
1119,
"Miccosukee Rd",
"Resolved",
"Menu Issue Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-11-04 12:27:57 AM",
"2025-11-05 12:26:15 AM"
],
[
1126,
"Canal St",
"Cancelled",
"Menu Issue Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-11-03 11:04:48 PM",
"2025-11-04 12:40:51 PM"
],
[
1133,
"Broadway",
"Cancelled",
"Connectivity Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-11-03 06:05:49 AM",
"2025-11-04 01:16:54 AM"
],
[
1140,
"Park Ave",
"Cancelled",
"Sticky Printer",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-11-02 07:26:49 AM",
"2025-11-02 06:37:40 PM"
],
[
1147,
"Pennsylvania Ave",
"Resolved",
"Receipt Printer",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-11-01 04:23:39 PM",
"2025-11-02 11:50:20 AM"
],
[
1154,
"Abbey Road",
"Resolved",
"Printer Android",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-31 07:41:46 PM",
"2025-10-31 11:45:15 PM"
],
[
1161,
"Santa Monica Blvd",
"Cancelled",
"KPS Hardware",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-31 03:18:07 PM",
"2025-10-31 09:49:48 PM"
],
[
1168,
"Broadway",
"Cancelled",
"New Issue",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-30 11:16:12 PM",
"2025-10-31 04:07:22 PM"
],
[
1175,
"Bourbon St",
"Cancelled",
"Cash Drawer Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-30 05:23:52 AM",
"2025-10-30 08:21:55 PM"
],
[
1182,
"MIA",
"Cancelled",
"Cash Drawer iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-29 05:59:37 AM",
"2025-10-29 06:03:34 PM"
],
[
1189,
"Canal St",
"Resolved",
"Card Reader Android",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-28 11:16:53 AM",
"2025-10-29 04:58:03 AM"
],
[
1196,
"Santa Monica Blvd",
"Cancelled",
"KPS Hardware",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-27 12:35:25 PM",
"2025-10-28 10:33:36 AM"
],
[
1203,
"Magnolia Blvd",
"Resolved",
"Connectivity iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-26 09:57:28 PM",
"2025-10-27 07:48:28 AM"
],
[
1210,
"Baker St",
"Cancelled",
"Connectivity iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-26 08:45:35 PM",
"2025-10-26 10:34:32 PM"
],
[
1217,
"Broadway",
"Cancelled",
"Card Reader iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-26 03:38:04 AM",
"2025-10-26 09:50:10 PM"
],
[
1224,
"Pennsylvania Ave",
"Cancelled",
"New Issue",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-25 05:30:25 PM",
"2025-10-25 06:07:23 PM"
],
[
1231,
"Washington Ave",
"On Hold",
"Cash Drawer Android",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-24 06:12:58 PM",
null
],
[
1238,
"Santa Monica Blvd",
"On Hold",
"Menu Issue iOS",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-24 09:51:59 AM",
null
],
[
1245,
"MIA",
"On Hold",
"Connectivity iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-10-24 09:33:57 AM",
null
],
[
1252,
"Pennsylvania Ave",
"On Hold",
"Connectivity iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-24 04:18:48 AM",
null
],
[
1259,
"Los Vegas Strip",
"Resolved",
"Order Accuracy Issue",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-24 02:08:40 AM",
"2025-10-24 01:49:21 PM"
],
[
1266,
"DEN",
"On Hold",
"Connectivity Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-10-23 08:20:56 PM",
null
],
[
1273,
"MIA",
"On Hold",
"Card Reader iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-23 09:06:09 AM",
null
],
[
1280,
"Lombard St",
"Resolved",
"Connectivity iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-22 04:14:35 PM",
"2025-10-23 12:21:51 PM"
],
[
1287,
"DFW",
"Cancelled",
"Printer Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-22 01:14:02 PM",
"2025-10-23 08:03:14 AM"
],
[
1294,
"Broadway",
"Cancelled",
"Connectivity Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-22 10:56:26 AM",
"2025-10-23 03:33:02 AM"
],
[
1301,
"Wall St",
"Cancelled",
"Configuration Issue",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-22 07:59:54 AM",
"2025-10-22 07:43:18 PM"
],
[
1308,
"Bourbon St",
"Resolved",
"Connectivity iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-21 03:38:28 PM",
"2025-10-22 02:22:02 PM"
],
[
1315,
"Lombard St",
"Cancelled",
"Receipt Printer",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-21 06:52:45 AM",
"2025-10-22 12:22:44 AM"
],
[
1322,
"Pennsylvania Ave",
"On Hold",
"Receipt Printer",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-20 11:21:10 PM",
null
],
[
1329,
"Wall St",
"Resolved",
"POS Hardware iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-20 01:46:11 PM",
"2025-10-20 06:00:56 PM"
],
[
1336,
"MIA",
"On Hold",
"Connectivity iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-20 06:10:30 AM",
null
],
[
1343,
"DEN",
"Cancelled",
"Order Accuracy Issue",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-19 02:04:55 PM",
"2025-10-19 03:03:19 PM"
],
[
1350,
"Los Vegas Strip",
"Cancelled",
"POS Hardware iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-18 08:36:53 PM",
"2025-10-19 12:07:24 PM"
],
[
1357,
"Abbey Road",
"Resolved",
"Menu Issue Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-18 05:51:27 PM",
"2025-10-19 03:51:01 AM"
],
[
1364,
"Wall St",
"Resolved",
"Order Accuracy Issue",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-17 07:48:00 PM",
"2025-10-17 10:54:26 PM"
],
[
1371,
"Wall St",
"Cancelled",
"Bump Bar",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-17 02:01:53 AM",
"2025-10-17 12:20:31 PM"
],
[
1378,
"Baker St",
"Resolved",
"Printer Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-16 02:05:15 AM",
"2025-10-16 10:28:01 AM"
],
[
1385,
"DFW",
"Resolved",
"Connectivity Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-15 04:15:55 AM",
"2025-10-16 03:32:13 AM"
],
[
1392,
"Los Vegas Strip",
"Cancelled",
"Connectivity Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-15 12:05:52 AM",
"2025-10-15 06:02:43 PM"
],
[
1399,
"Washington Ave",
"Resolved",
"Sticky Printer",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-14 09:11:24 AM",
"2025-10-14 10:38:34 AM"
],
[
1406,
"Bourbon St",
"Cancelled",
"Bump Bar",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-14 04:11:06 AM",
"2025-10-14 10:19:03 PM"
],
[
1413,
"Market St",
"Resolved",
"Printer Android",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-13 08:04:31 AM",
"2025-10-13 09:47:22 AM"
],
[
1420,
"Market St",
"Cancelled",
"Printer iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-12 03:16:23 PM",
"2025-10-13 03:18:28 AM"
],
[
1427,
"DFW",
"Cancelled",
"KPS Hardware",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-11 06:55:14 PM",
"2025-10-12 11:26:14 AM"
],
[
1434,
"Bourbon St",
"Cancelled",
"Menu Issue iOS",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-10-11 11:18:55 AM",
"2025-10-11 05:51:47 PM"
],
[
1441,
"Wall St",
"Cancelled",
"Card Reader iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-11 02:57:09 AM",
"2025-10-11 06:02:54 PM"
],
[
1448,
"Market St",
"Resolved",
"Order Accuracy Issue",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-11 01:12:16 AM",
"2025-10-11 05:33:15 PM"
],
[
1455,
"LAX",
"Cancelled",
"Sticky Printer",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-10 04:13:09 PM",
"2025-10-10 11:25:09 PM"
],
[
1462,
"Abbey Road",
"Resolved",
"Cash Drawer Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-10 06:38:45 AM",
"2025-10-10 11:16:11 AM"
],
[
1469,
"Broadway",
"Resolved",
"POS Hardware iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-10 04:59:50 AM",
"2025-10-10 06:44:38 PM"
],
[
1476,
"Canal St",
"Resolved",
"Printer iOS",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-09 02:08:11 PM",
"2025-10-10 06:56:02 AM"
],
[
1483,
"Pennsylvania Ave",
"Resolved",
"Configuration Issue",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-09 03:50:56 AM",
"2025-10-09 11:18:49 AM"
],
[
1490,
"Park Ave",
"Resolved",
"Cash Drawer Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-08 03:00:38 PM",
"2025-10-09 04:02:37 AM"
],
[
1497,
"Madison Ave",
"Cancelled",
"New Issues iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-08 10:54:33 AM",
"2025-10-09 12:29:03 AM"
],
[
1504,
"DFW",
"Cancelled",
"Printer Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-08 09:26:36 AM",
"2025-10-08 10:02:06 AM"
],
[
1511,
"Wall St",
"Resolved",
"Menu Issue Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-08 03:33:24 AM",
"2025-10-08 11:37:53 PM"
],
[
1518,
"Fifth Ave",
"Cancelled",
"Printer iOS",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-07 10:17:28 PM",
"2025-10-08 05:38:21 AM"
],
[
1525,
"Lombard St",
"Resolved",
"Card Reader Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Jacob Yero",
"2025-10-07 09:24:37 PM",
"2025-10-07 09:38:13 PM"
],
[
1532,
"Abbey Road",
"Cancelled",
"Order Accuracy Issue",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-10-07 07:45:54 AM",
"2025-10-07 01:11:47 PM"
],
[
1539,
"Bourbon St",
"Resolved",
"POS Hardware iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-07 05:15:50 AM",
"2025-10-07 05:39:23 PM"
],
[
1546,
"Canal St",
"Cancelled",
"Connectivity Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-06 11:44:40 PM",
"2025-10-07 05:33:58 AM"
],
[
1553,
"LAX",
"Cancelled",
"POS Hardware Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-06 04:21:50 PM",
"2025-10-07 07:31:28 AM"
],
[
1560,
"Park Ave",
"Cancelled",
"KPS Hardware",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-05 10:20:03 PM",
"2025-10-06 07:32:04 AM"
],
[
1567,
"Lombard St",
"Resolved",
"New Issues iOS",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-10-05 05:27:36 PM",
"2025-10-05 11:57:24 PM"
],
[
1574,
"Miccosukee Rd",
"Cancelled",
"New Issues Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-10-04 07:13:26 PM",
"2025-10-05 05:04:46 PM"
],
[
1581,
"Fifth Ave",
"Cancelled",
"Connectivity Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-04 02:27:27 AM",
"2025-10-04 03:24:01 AM"
],
[
1588,
"Washington Ave",
"Resolved",
"New Issue",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-03 02:58:14 PM",
"2025-10-04 09:09:08 AM"
],
[
1595,
"LAX",
"Resolved",
"Receipt Printer",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-02 11:45:40 PM",
"2025-10-03 09:53:42 PM"
],
[
1602,
"DEN",
"Cancelled",
"Cash Drawer Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-02 02:21:28 AM",
"2025-10-02 07:46:38 PM"
],
[
1609,
"Washington Ave",
"Cancelled",
"Menu Issue iOS",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-10-01 04:36:45 PM",
"2025-10-02 02:00:55 PM"
],
[
1616,
"Madison Ave",
"Cancelled",
"New Issue",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-10-01 12:03:51 PM",
"2025-10-02 05:48:53 AM"
],
[
1623,
"Miccosukee Rd",
"Cancelled",
"Bump Bar",
"P2 - High",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-10-01 08:44:38 AM",
"2025-10-02 04:55:33 AM"
],
[
1630,
"Fifth Ave",
"Resolved",
"POS Hardware iOS",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-09-30 04:31:29 PM",
"2025-09-30 06:04:33 PM"
],
[
1637,
"Madison Ave",
"Cancelled",
"KPS Hardware",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-09-30 03:31:36 AM",
"2025-09-30 09:50:25 PM"
],
[
1644,
"MIA",
"Resolved",
"POS Hardware Android",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Michelle Crawford",
"2025-09-29 02:49:25 PM",
"2025-09-30 04:05:53 AM"
],
[
1651,
"Market St",
"Resolved",
"New Issue",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-09-29 05:43:10 AM",
"2025-09-29 08:57:40 PM"
],
[
1658,
"Baker St",
"Resolved",
"Card Reader Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Jeff Singleton",
"2025-09-29 01:54:26 AM",
"2025-09-29 01:34:59 PM"
],
[
1665,
"DFW",
"Cancelled",
"Connectivity Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L4",
"Nick Kalar",
"2025-09-28 06:52:25 AM",
"2025-09-28 02:58:05 PM"
],
[
1672,
"Park Ave",
"Resolved",
"Connectivity Android",
"P4 - Low",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-09-27 01:13:50 PM",
"2025-09-27 03:38:51 PM"
],
[
1679,
"Miccosukee Rd",
"Resolved",
"POS Hardware iOS",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-09-27 09:03:47 AM",
"2025-09-27 07:42:38 PM"
],
[
1686,
"Miccosukee Rd",
"Cancelled",
"Order Accuracy Issue",
"P3 - Medium",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Adam Lee",
"2025-09-26 03:59:27 PM",
"2025-09-26 06:51:01 PM"
],
[
1693,
"Los Vegas Strip",
"Resolved",
"Card Reader Android",
"P1 - Critical",
"Lorem ipsum",
"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
"Managed Support L3",
"Kevin Von Stork",
"2025-09-26 05:43:27 AM",
"2025-09-26 01:17:18 PM"
]
],
"datasetInfos": [],
"dbfsResultPath": null,
"isJsonSchema": true,
"metadata": {},
"overflow": false,
"plotOptions": {
"customPlotOptions": {},
"displayType": "table",
"pivotAggregation": null,
"pivotColumns": null,
"xColumns": null,
"yColumns": null
},
"removedWidgets": [],
"schema": [
{
"metadata": "{}",
"name": "number",
"type": "\"integer\""
},
{
"metadata": "{}",
"name": "location",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "state",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "ci",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "priority",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "short_description",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "description",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "assignment_group",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "assigned_to",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "sys_created_on",
"type": "\"string\""
},
{
"metadata": "{}",
"name": "resolved_at",
"type": "\"string\""
}
],
"type": "table"
}
},
"output_type": "display_data"
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"Databricks visualization. Run in Databricks to view."
]
},
"metadata": {
"application/vnd.databricks.v1.subcommand+json": {
"baseErrorDetails": null,
"bindings": {},
"collapsed": false,
"command": "%python\n__backend_agg_display_orig = display\n__backend_agg_dfs = []\ndef __backend_agg_display_new(df):\n __backend_agg_df_modules = [\"pandas.core.frame\", \"databricks.koalas.frame\", \"pyspark.sql.dataframe\", \"pyspark.pandas.frame\", \"pyspark.sql.connect.dataframe\"]\n if (type(df).__module__ in __backend_agg_df_modules and type(df).__name__ == 'DataFrame') or isinstance(df, list):\n __backend_agg_dfs.append(df)\n\ndisplay = __backend_agg_display_new\n\ndef __backend_agg_user_code_fn():\n import base64\n exec(base64.standard_b64decode(\"Y2F0YWxvZyA9ICJhbmFseXRpY3MiCnNjaGVtYSA9ICJpbmNpZGVudHMiCnBhdGhfdm9sdW1lID0gIi9Wb2x1bWVzLyIgKyBjYXRhbG9nICsgIi8iICsgc2NoZW1hICsgIi9jdXJyZW50LyIKZmlsZV9uYW1lID0gImluY2lkZW50LmNzdiIKdGFibGVfbmFtZSA9ICJpbmNpZGVudHMiCnBhdGhfdGFibGUgPSBjYXRhbG9nICsgIi4iICsgc2NoZW1hCgpkZiA9IHNwYXJrLnJlYWQuY3N2KEYie3BhdGhfdm9sdW1lfS97ZmlsZV9uYW1lfSIsCiAgICAgICAgICAgICAgICAgICAgaGVhZGVyPVRydWUsCiAgICAgICAgICAgICAgICAgICAgaW5mZXJTY2hlbWE9VHJ1ZSwKICAgICAgICAgICAgICAgICAgICBzZXA9IiwiKQoKZGlzcGxheShkZikK\").decode())\n\ntry:\n # run user code\n __backend_agg_user_code_fn()\n\n #reset display function\n display = __backend_agg_display_orig\n\n if len(__backend_agg_dfs) > 0:\n # create a temp view\n if type(__backend_agg_dfs[0]).__module__ == \"databricks.koalas.frame\":\n # koalas dataframe\n __backend_agg_dfs[0].to_spark().createOrReplaceTempView(\"DatabricksViewca33f70\")\n elif type(__backend_agg_dfs[0]).__module__ == \"pandas.core.frame\" or isinstance(__backend_agg_dfs[0], list):\n # pandas dataframe\n spark.createDataFrame(__backend_agg_dfs[0]).createOrReplaceTempView(\"DatabricksViewca33f70\")\n else:\n __backend_agg_dfs[0].createOrReplaceTempView(\"DatabricksViewca33f70\")\n #run backend agg\n display(spark.sql(\"\"\"WITH q AS (select * from DatabricksViewca33f70) SELECT `location`,COUNT(`number`) `column_cb45671d401`,`priority` FROM q GROUP BY `location`,`priority`\"\"\"))\n else:\n displayHTML(\"dataframe no longer exists. If you're using dataframe.display(), use display(dataframe) instead.\")\n\n\nfinally:\n spark.sql(\"drop view if exists DatabricksViewca33f70\")\n display = __backend_agg_display_orig\n del __backend_agg_display_new\n del __backend_agg_display_orig\n del __backend_agg_dfs\n del __backend_agg_user_code_fn\n\n",
"commandTitle": "Priority breakdown by Location",
"commandType": "auto",
"commandVersion": 0,
"commentThread": [],
"commentsVisible": false,
"contentSha256Hex": null,
"customPlotOptions": {
"redashChart": [
{
"key": "type",
"value": "CHART"
},
{
"key": "options",
"value": {
"alignYAxesAtZero": true,
"coefficient": 1,
"columnConfigurationMap": {
"series": {
"column": "priority",
"id": "column_cb45671d403"
},
"x": {
"column": "location",
"id": "column_cb45671d399"
},
"y": [
{
"column": "number",
"id": "column_cb45671d401",
"transform": "COUNT"
}
]
},
"dateTimeFormat": "DD/MM/YYYY HH:mm",
"direction": {
"type": "counterclockwise"
},
"error_y": {
"type": "data",
"visible": true
},
"globalSeriesType": "column",
"isAggregationOn": true,
"legend": {
"traceorder": "normal"
},
"missingValuesAsZero": true,
"numberFormat": "0,0.[00000]",
"percentFormat": "0[.]00%",
"series": {
"error_y": {
"type": "data",
"visible": true
},
"stacking": null
},
"seriesOptions": {
"column_cb45671d401": {
"type": "column",
"yAxis": 0
}
},
"showDataLabels": false,
"sizemode": "diameter",
"sortX": true,
"sortY": true,
"swappedAxes": false,
"textFormat": "",
"useAggregationsUi": true,
"valuesOptions": {},
"version": 2,
"xAxis": {
"labels": {
"enabled": true
},
"type": "-"
},
"yAxis": [
{
"type": "-"
},
{
"opposite": true,
"type": "-"
}
]
}
}
]
},
"datasetPreviewNameToCmdIdMap": {},
"diffDeletes": [],
"diffInserts": [],
"displayType": "redashChart",
"error": null,
"errorDetails": null,
"errorSummary": null,
"errorTraceType": null,
"finishTime": 0,
"globalVars": {},
"guid": "",
"height": "auto",
"hideCommandCode": false,
"hideCommandResult": false,
"iPythonMetadata": null,
"inputWidgets": {},
"isLockedInExamMode": false,
"latestAssumeRoleInfo": null,
"latestUser": "a user",
"latestUserId": null,
"listResultMetadata": null,
"metadata": {},
"nuid": "07353c2c-c26d-443c-8ce4-a0293931bc86",
"origId": 0,
"parentHierarchy": [],
"pivotAggregation": null,
"pivotColumns": null,
"position": 2.0,
"resultDbfsErrorMessage": null,
"resultDbfsStatus": "INLINED_IN_TREE",
"results": null,
"showCommandTitle": false,
"startTime": 0,
"state": "input",
"streamStates": {},
"subcommandOptions": {
"queryPlan": {
"groups": [
{
"column": "location",
"type": "column"
},
{
"column": "priority",
"type": "column"
}
],
"selects": [
{
"column": "location",
"type": "column"
},
{
"alias": "column_cb45671d401",
"args": [
{
"column": "number",
"type": "column"
}
],
"function": "COUNT",
"type": "function"
},
{
"column": "priority",
"type": "column"
}
]
}
},
"submitTime": 0,
"subtype": "tableResultSubCmd.visualization",
"tableResultIndex": 0,
"tableResultSettingsMap": {},
"useConsistentColors": false,
"version": "CommandV1",
"width": "auto",
"workflows": [],
"xColumns": null,
"yColumns": null
}
},
"output_type": "display_data"
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"Databricks visualization. Run in Databricks to view."
]
},
"metadata": {
"application/vnd.databricks.v1.subcommand+json": {
"baseErrorDetails": null,
"bindings": {},
"collapsed": false,
"command": "%python\n__backend_agg_display_orig = display\n__backend_agg_dfs = []\ndef __backend_agg_display_new(df):\n __backend_agg_df_modules = [\"pandas.core.frame\", \"databricks.koalas.frame\", \"pyspark.sql.dataframe\", \"pyspark.pandas.frame\", \"pyspark.sql.connect.dataframe\"]\n if (type(df).__module__ in __backend_agg_df_modules and type(df).__name__ == 'DataFrame') or isinstance(df, list):\n __backend_agg_dfs.append(df)\n\ndisplay = __backend_agg_display_new\n\ndef __backend_agg_user_code_fn():\n import base64\n exec(base64.standard_b64decode(\"Y2F0YWxvZyA9ICJhbmFseXRpY3MiCnNjaGVtYSA9ICJpbmNpZGVudHMiCnBhdGhfdm9sdW1lID0gIi9Wb2x1bWVzLyIgKyBjYXRhbG9nICsgIi8iICsgc2NoZW1hICsgIi9jdXJyZW50LyIKZmlsZV9uYW1lID0gImluY2lkZW50LmNzdiIKdGFibGVfbmFtZSA9ICJpbmNpZGVudHMiCnBhdGhfdGFibGUgPSBjYXRhbG9nICsgIi4iICsgc2NoZW1hCgpkZiA9IHNwYXJrLnJlYWQuY3N2KEYie3BhdGhfdm9sdW1lfS97ZmlsZV9uYW1lfSIsCiAgICAgICAgICAgICAgICAgICAgaGVhZGVyPVRydWUsCiAgICAgICAgICAgICAgICAgICAgaW5mZXJTY2hlbWE9VHJ1ZSwKICAgICAgICAgICAgICAgICAgICBzZXA9IiwiKQoKZGlzcGxheShkZikK\").decode())\n\ntry:\n # run user code\n __backend_agg_user_code_fn()\n\n #reset display function\n display = __backend_agg_display_orig\n\n if len(__backend_agg_dfs) > 0:\n # create a temp view\n if type(__backend_agg_dfs[0]).__module__ == \"databricks.koalas.frame\":\n # koalas dataframe\n __backend_agg_dfs[0].to_spark().createOrReplaceTempView(\"DatabricksViewcc9a009\")\n elif type(__backend_agg_dfs[0]).__module__ == \"pandas.core.frame\" or isinstance(__backend_agg_dfs[0], list):\n # pandas dataframe\n spark.createDataFrame(__backend_agg_dfs[0]).createOrReplaceTempView(\"DatabricksViewcc9a009\")\n else:\n __backend_agg_dfs[0].createOrReplaceTempView(\"DatabricksViewcc9a009\")\n #run backend agg\n display(spark.sql(\"\"\"WITH q AS (select * from DatabricksViewcc9a009) SELECT `ci`,COUNT(`number`) `column_cb45671d406`,`priority` FROM q GROUP BY `ci`,`priority`\"\"\"))\n else:\n displayHTML(\"dataframe no longer exists. If you're using dataframe.display(), use display(dataframe) instead.\")\n\n\nfinally:\n spark.sql(\"drop view if exists DatabricksViewcc9a009\")\n display = __backend_agg_display_orig\n del __backend_agg_display_new\n del __backend_agg_display_orig\n del __backend_agg_dfs\n del __backend_agg_user_code_fn\n\n",
"commandTitle": "Priority Breakdown by CI",
"commandType": "auto",
"commandVersion": 0,
"commentThread": [],
"commentsVisible": false,
"contentSha256Hex": null,
"customPlotOptions": {
"redashChart": [
{
"key": "type",
"value": "CHART"
},
{
"key": "options",
"value": {
"alignYAxesAtZero": true,
"coefficient": 1,
"columnConfigurationMap": {
"series": {
"column": "priority",
"id": "column_cb45671d408"
},
"x": {
"column": "ci",
"id": "column_cb45671d404"
},
"y": [
{
"column": "number",
"id": "column_cb45671d406",
"transform": "COUNT"
}
]
},
"dateTimeFormat": "DD/MM/YYYY HH:mm",
"direction": {
"type": "counterclockwise"
},
"error_y": {
"type": "data",
"visible": true
},
"globalSeriesType": "column",
"isAggregationOn": true,
"legend": {
"traceorder": "normal"
},
"missingValuesAsZero": true,
"numberFormat": "0,0.[00000]",
"percentFormat": "0[.]00%",
"series": {
"error_y": {
"type": "data",
"visible": true
},
"stacking": null
},
"seriesOptions": {
"column_cb45671d406": {
"type": "column",
"yAxis": 0
}
},
"showDataLabels": false,
"sizemode": "diameter",
"sortX": true,
"sortY": true,
"swappedAxes": false,
"textFormat": "",
"useAggregationsUi": true,
"valuesOptions": {},
"version": 2,
"xAxis": {
"labels": {
"enabled": true
},
"type": "-"
},
"yAxis": [
{
"type": "-"
},
{
"opposite": true,
"type": "-"
}
]
}
}
]
},
"datasetPreviewNameToCmdIdMap": {},
"diffDeletes": [],
"diffInserts": [],
"displayType": "redashChart",
"error": null,
"errorDetails": null,
"errorSummary": null,
"errorTraceType": null,
"finishTime": 0,
"globalVars": {},
"guid": "",
"height": "auto",
"hideCommandCode": false,
"hideCommandResult": false,
"iPythonMetadata": null,
"inputWidgets": {},
"isLockedInExamMode": false,
"latestAssumeRoleInfo": null,
"latestUser": "a user",
"latestUserId": null,
"listResultMetadata": null,
"metadata": {},
"nuid": "c00af826-4091-4882-93e9-0671b4fe1530",
"origId": 0,
"parentHierarchy": [],
"pivotAggregation": null,
"pivotColumns": null,
"position": 3.0,
"resultDbfsErrorMessage": null,
"resultDbfsStatus": "INLINED_IN_TREE",
"results": null,
"showCommandTitle": false,
"startTime": 0,
"state": "input",
"streamStates": {},
"subcommandOptions": {
"queryPlan": {
"groups": [
{
"column": "ci",
"type": "column"
},
{
"column": "priority",
"type": "column"
}
],
"selects": [
{
"column": "ci",
"type": "column"
},
{
"alias": "column_cb45671d406",
"args": [
{
"column": "number",
"type": "column"
}
],
"function": "COUNT",
"type": "function"
},
{
"column": "priority",
"type": "column"
}
]
}
},
"submitTime": 0,
"subtype": "tableResultSubCmd.visualization",
"tableResultIndex": 0,
"tableResultSettingsMap": {},
"useConsistentColors": false,
"version": "CommandV1",
"width": "auto",
"workflows": [],
"xColumns": null,
"yColumns": null
}
},
"output_type": "display_data"
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"Databricks visualization. Run in Databricks to view."
]
},
"metadata": {
"application/vnd.databricks.v1.subcommand+json": {
"baseErrorDetails": null,
"bindings": {},
"collapsed": false,
"command": "catalog = \"analytics\"\nschema = \"incidents\"\npath_volume = \"/Volumes/\" + catalog + \"/\" + schema + \"/current/\"\nfile_name = \"incident.csv\"\ntable_name = \"incidents\"\npath_table = catalog + \".\" + schema\n\ndf = spark.read.csv(F\"{path_volume}/{file_name}\",\n header=True,\n inferSchema=True,\n sep=\",\")\n\ndisplay(df)\n",
"commandTitle": "Incident Total",
"commandType": "auto",
"commandVersion": 0,
"commentThread": [],
"commentsVisible": false,
"contentSha256Hex": null,
"customPlotOptions": {
"redashChart": [
{
"key": "type",
"value": "COUNTER"
},
{
"key": "options",
"value": {
"countRow": true,
"counterColName": "location",
"counterLabel": "Total Incidents",
"rowNumber": 1,
"stringDecChar": ".",
"stringDecimal": 0,
"stringThouSep": ",",
"targetRowNumber": 1,
"tooltipFormat": "0,0.000"
}
}
]
},
"datasetPreviewNameToCmdIdMap": {},
"diffDeletes": [],
"diffInserts": [],
"displayType": "redashChart",
"error": null,
"errorDetails": null,
"errorSummary": null,
"errorTraceType": null,
"finishTime": 0,
"globalVars": {},
"guid": "",
"height": "auto",
"hideCommandCode": false,
"hideCommandResult": false,
"iPythonMetadata": null,
"inputWidgets": {},
"isLockedInExamMode": false,
"latestAssumeRoleInfo": null,
"latestUser": "a user",
"latestUserId": null,
"listResultMetadata": null,
"metadata": {},
"nuid": "168e0315-d11b-42fa-8573-d69313478259",
"origId": 0,
"parentHierarchy": [],
"pivotAggregation": null,
"pivotColumns": null,
"position": 4.0,
"resultDbfsErrorMessage": null,
"resultDbfsStatus": "INLINED_IN_TREE",
"results": null,
"showCommandTitle": false,
"startTime": 0,
"state": "input",
"streamStates": {},
"subcommandOptions": {},
"submitTime": 0,
"subtype": "tableResultSubCmd.visualization",
"tableResultIndex": 0,
"tableResultSettingsMap": {},
"useConsistentColors": false,
"version": "CommandV1",
"width": "auto",
"workflows": [],
"xColumns": null,
"yColumns": null
}
},
"output_type": "display_data"
},
{
"output_type": "display_data",
"data": {
"text/plain": [
"Databricks visualization. Run in Databricks to view."
]
},
"metadata": {
"application/vnd.databricks.v1.subcommand+json": {
"baseErrorDetails": null,
"bindings": {},
"collapsed": false,
"command": "%python\n__backend_agg_display_orig = display\n__backend_agg_dfs = []\ndef __backend_agg_display_new(df):\n __backend_agg_df_modules = [\"pandas.core.frame\", \"databricks.koalas.frame\", \"pyspark.sql.dataframe\", \"pyspark.pandas.frame\", \"pyspark.sql.connect.dataframe\"]\n if (type(df).__module__ in __backend_agg_df_modules and type(df).__name__ == 'DataFrame') or isinstance(df, list):\n __backend_agg_dfs.append(df)\n\ndisplay = __backend_agg_display_new\n\ndef __backend_agg_user_code_fn():\n import base64\n exec(base64.standard_b64decode(\"Y2F0YWxvZyA9ICJhbmFseXRpY3MiCnNjaGVtYSA9ICJpbmNpZGVudHMiCnBhdGhfdm9sdW1lID0gIi9Wb2x1bWVzLyIgKyBjYXRhbG9nICsgIi8iICsgc2NoZW1hICsgIi9jdXJyZW50LyIKZmlsZV9uYW1lID0gImluY2lkZW50LmNzdiIKdGFibGVfbmFtZSA9ICJpbmNpZGVudHMiCnBhdGhfdGFibGUgPSBjYXRhbG9nICsgIi4iICsgc2NoZW1hCgpkZiA9IHNwYXJrLnJlYWQuY3N2KEYie3BhdGhfdm9sdW1lfS97ZmlsZV9uYW1lfSIsCiAgICAgICAgICAgICAgICAgICAgaGVhZGVyPVRydWUsCiAgICAgICAgICAgICAgICAgICAgaW5mZXJTY2hlbWE9VHJ1ZSwKICAgICAgICAgICAgICAgICAgICBzZXA9IiwiKQoKZGlzcGxheShkZikK\").decode())\n\ntry:\n # run user code\n __backend_agg_user_code_fn()\n\n #reset display function\n display = __backend_agg_display_orig\n\n if len(__backend_agg_dfs) > 0:\n # create a temp view\n if type(__backend_agg_dfs[0]).__module__ == \"databricks.koalas.frame\":\n # koalas dataframe\n __backend_agg_dfs[0].to_spark().createOrReplaceTempView(\"DatabricksViewe34daae\")\n elif type(__backend_agg_dfs[0]).__module__ == \"pandas.core.frame\" or isinstance(__backend_agg_dfs[0], list):\n # pandas dataframe\n spark.createDataFrame(__backend_agg_dfs[0]).createOrReplaceTempView(\"DatabricksViewe34daae\")\n else:\n __backend_agg_dfs[0].createOrReplaceTempView(\"DatabricksViewe34daae\")\n #run backend agg\n display(spark.sql(\"\"\"WITH q AS (select * from DatabricksViewe34daae) SELECT `priority`,COUNT(`priority`) `column_cb45671d426` FROM q GROUP BY `priority`\"\"\"))\n else:\n displayHTML(\"dataframe no longer exists. If you're using dataframe.display(), use display(dataframe) instead.\")\n\n\nfinally:\n spark.sql(\"drop view if exists DatabricksViewe34daae\")\n display = __backend_agg_display_orig\n del __backend_agg_display_new\n del __backend_agg_display_orig\n del __backend_agg_dfs\n del __backend_agg_user_code_fn\n\n",
"commandTitle": "Priority Count",
"commandType": "auto",
"commandVersion": 0,
"commentThread": [],
"commentsVisible": false,
"contentSha256Hex": null,
"customPlotOptions": {
"redashChart": [
{
"key": "type",
"value": "CHART"
},
{
"key": "options",
"value": {
"alignYAxesAtZero": true,
"coefficient": 1,
"columnConfigurationMap": {
"x": {
"column": "priority",
"id": "column_cb45671d428"
},
"y": [
{
"column": "priority",
"id": "column_cb45671d426",
"transform": "COUNT"
}
]
},
"dateTimeFormat": "DD/MM/YYYY HH:mm",
"direction": {
"type": "counterclockwise"
},
"error_y": {
"type": "data",
"visible": true
},
"globalSeriesType": "column",
"isAggregationOn": true,
"legend": {
"traceorder": "normal"
},
"missingValuesAsZero": true,
"numberFormat": "0,0.[00000]",
"percentFormat": "0[.]00%",
"series": {
"error_y": {
"type": "data",
"visible": true
},
"stacking": null
},
"seriesOptions": {
"column_cb45671d426": {
"type": "column",
"yAxis": 0
}
},
"showDataLabels": false,
"sizemode": "diameter",
"sortX": true,
"sortY": true,
"swappedAxes": false,
"textFormat": "",
"useAggregationsUi": true,
"valuesOptions": {},
"version": 2,
"xAxis": {
"labels": {
"enabled": true
},
"type": "-"
},
"yAxis": [
{
"type": "-"
},
{
"opposite": true,
"type": "-"
}
]
}
}
]
},
"datasetPreviewNameToCmdIdMap": {},
"diffDeletes": [],
"diffInserts": [],
"displayType": "redashChart",
"error": null,
"errorDetails": null,
"errorSummary": null,
"errorTraceType": null,
"finishTime": 0,
"globalVars": {},
"guid": "",
"height": "auto",
"hideCommandCode": false,
"hideCommandResult": false,
"iPythonMetadata": null,
"inputWidgets": {},
"isLockedInExamMode": false,
"latestAssumeRoleInfo": null,
"latestUser": "a user",
"latestUserId": null,
"listResultMetadata": null,
"metadata": {},
"nuid": "2a53ecbb-10cc-4d36-9871-5f306dc2e97d",
"origId": 0,
"parentHierarchy": [],
"pivotAggregation": null,
"pivotColumns": null,
"position": 5.0,
"resultDbfsErrorMessage": null,
"resultDbfsStatus": "INLINED_IN_TREE",
"results": null,
"showCommandTitle": false,
"startTime": 0,
"state": "input",
"streamStates": {},
"subcommandOptions": {
"queryPlan": {
"groups": [
{
"column": "priority",
"type": "column"
}
],
"selects": [
{
"column": "priority",
"type": "column"
},
{
"alias": "column_cb45671d426",
"args": [
{
"column": "priority",
"type": "column"
}
],
"function": "COUNT",
"type": "function"
}
]
}
},
"submitTime": 0,
"subtype": "tableResultSubCmd.visualization",
"tableResultIndex": 0,
"tableResultSettingsMap": {},
"useConsistentColors": false,
"version": "CommandV1",
"width": "auto",
"workflows": [],
"xColumns": null,
"yColumns": null
}
},
"output_type": "display_data"
}
],
"source": [
"catalog = \"analytics\"\n",
"schema = \"incidents\"\n",
"path_volume = \"/Volumes/\" + catalog + \"/\" + schema + \"/current/\"\n",
"file_name = \"incident.csv\"\n",
"table_name = \"incidents\"\n",
"path_table = catalog + \".\" + schema\n",
"\n",
"df = spark.read.csv(F\"{path_volume}/{file_name}\",\n",
" header=True,\n",
" inferSchema=True,\n",
" sep=\",\")\n",
"\n",
"display(df)\n"
]
},
{
"cell_type": "code",
"execution_count": 0,
"metadata": {
"application/vnd.databricks.v1+cell": {
"cellMetadata": {
"byteLimit": 2048000,
"rowLimit": 10000
},
"inputWidgets": {},
"nuid": "adfecac8-b8f7-4e2e-b253-7c68852d885b",
"showTitle": false,
"tableResultSettingsMap": {},
"title": ""
}
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"<bound method DataFrame.printSchema of DataFrame[number: int, location: string, state: string, Configuration Item: string, priority: string, short_description: string, description: string, assignment_group: string, assigned_to: string, sys_created_on: string, resolved_at: string]>"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = df.withColumnRenamed(\"ci\", \"Configuration Item\")\n",
"df.printSchema"
]
}
],
"metadata": {
"application/vnd.databricks.v1+notebook": {
"computePreferences": null,
"dashboards": [
{
"elements": [
{
"dashboardResultIndex": 0,
"elementNUID": "5b2cb513-1502-485d-847e-285fb2a59b48",
"elementType": "command",
"guid": "36b3f001-bad6-4a5e-9c85-6cd53211a6de",
"options": null,
"position": {
"height": 6,
"width": 12,
"x": 0,
"y": 0,
"z": null
},
"resultIndex": null
},
{
"dashboardResultIndex": null,
"elementNUID": "2a53ecbb-10cc-4d36-9871-5f306dc2e97d",
"elementType": "command",
"guid": "7b57a5f4-e00d-4fb0-96be-fb0daff7ae02",
"options": null,
"position": {
"height": 6,
"width": 12,
"x": 0,
"y": 6,
"z": null
},
"resultIndex": null
},
{
"dashboardResultIndex": null,
"elementNUID": "c00af826-4091-4882-93e9-0671b4fe1530",
"elementType": "command",
"guid": "9559ffb3-7a2c-4ddb-be98-55eaa5fc9979",
"options": null,
"position": {
"height": 7,
"width": 15,
"x": 0,
"y": 12,
"z": null
},
"resultIndex": null
},
{
"dashboardResultIndex": null,
"elementNUID": "168e0315-d11b-42fa-8573-d69313478259",
"elementType": "command",
"guid": "abbc4842-164e-480b-a4b9-98186980de06",
"options": null,
"position": {
"height": 6,
"width": 12,
"x": 0,
"y": 19,
"z": null
},
"resultIndex": null
},
{
"dashboardResultIndex": null,
"elementNUID": "07353c2c-c26d-443c-8ce4-a0293931bc86",
"elementType": "command",
"guid": "f9017bc2-ac6a-4f83-998e-e84b17f7ed70",
"options": null,
"position": {
"height": 9,
"width": 15,
"x": 0,
"y": 25,
"z": null
},
"resultIndex": null
}
],
"globalVars": {},
"guid": "",
"layoutOption": {
"grid": true,
"stack": true
},
"nuid": "963c8a25-8df6-42de-a5a6-65365c964f60",
"origId": 7970433637806911,
"title": "Dashboard View",
"version": "DashboardViewV1",
"width": 1024
}
],
"environmentMetadata": {
"base_environment": "",
"environment_version": "4"
},
"inputWidgetPreferences": null,
"language": "python",
"notebookMetadata": {
"pythonIndentUnit": 4
},
"notebookName": "Incident Exploration",
"widgets": {}
},
"language_info": {
"name": "python"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Reference in New Issue View Git Blame Copy Permalink