{ "title": "Bell Curve Script Working: Cut down code", "desc": "", "source": null, "type": "dashboard", "style": { "name": "vivid", "palette": { "colors": [ "#00cee6", "#9b9bd7", "#6EDA55", "#fc7570", "#fbb755", "#218A8C" ], "name": "Vivid", "sortOrder": 10, "isSystem": true, "systemDefault": true } }, "layout": { "instanceid": "3ED09-A418-E9", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61dc8d84f901bf3740c5b18e", "height": "672px" } ], "width": 50, "stretchable": false, "pxlWidth": 659.65625, "index": 1 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61dc8d84f901bf3740c5b18f", "height": "672px" } ], "width": 100, "stretchable": false, "pxlWidth": 1979, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61dc8d84f901bf3740c5b18c", "height": "633px", "autoHeight": "633px" } ], "width": 100, "stretchable": false, "pxlWidth": 1979, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61dc8d84f901bf3740c5b18d", "height": "452px" } ], "width": 100, "stretchable": false, "pxlWidth": 1979, "index": 0 } ] } ], "pxlWidth": 1979, "index": 0 } ], "container": {} }, "original": null, "oid": "61dc8d84f901bf3740c5b18a", "dataExploration": false, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e" }, "filters": [ { "instanceid": "C9C31-1858-09", "isCascading": true, "levels": [ { "table": "Clients", "column": "Client_Name", "dim": "[Clients.Client_Name]", "datatype": "text", "title": "Client_Name", "collapsed": true, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e", "lastBuildTime": "2022-01-07T17:21:42.749Z" }, "panel": "scope", "filter": { "explicit": true, "userMultiSelect": false, "multiSelection": false, "members": [ "Church's Chicken AQA" ] } }, { "table": "Suppliers", "column": "Supplier_Name", "dim": "[Suppliers.Supplier_Name]", "datatype": "text", "title": "Supplier_Name", "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e", "lastBuildTime": "2022-01-07T17:21:42.749Z" }, "collapsed": true, "panel": "scope", "filter": { "explicit": true, "multiSelection": true, "members": [ "Brakebush - Irving TX" ] } }, { "table": "Products", "column": "Number_And_Item_Name", "dim": "[Products.Number_And_Item_Name]", "datatype": "text", "merged": true, "title": "Number_And_Item_Name", "collapsed": true, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e", "lastBuildTime": "2022-01-07T17:21:42.749Z" }, "panel": "scope", "filter": { "explicit": true, "multiSelection": true, "members": [ "5657 - Chicken Mega Bites - Raw Chicken Breast Chunks" ] } }, { "table": "Tests", "column": "Test_Name", "dim": "[Tests.Test_Name]", "datatype": "text", "title": "Test_Name", "collapsed": true, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e", "lastBuildTime": "2022-01-07T17:21:42.749Z" }, "filter": { "explicit": true, "multiSelection": true, "members": [ "Finished Bag Weight" ] } } ], "model": { "instanceid": "E708D-580E-8C", "__store": [ "[Clients.Client_Name]", "[Suppliers.Supplier_Name]", "[Products.Number_And_Item_Name]", "[Tests.Test_Name]" ] }, "disabled": false } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "parentFolder": "5f637cc4704654072c13ad7a", "filterToDatasourceMapping": {}, "widgets": [ { "title": "", "subtype": "pivot", "desc": null, "source": null, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Test Value" }, "field": { "id": "[Test_Results.Value1]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "[6F105-B27]", "context": { "[6F105-B27]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "count", "title": "# of unique id" }, "[8334B-DD7]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "countduplicates", "title": "# of id" } }, "title": "Frequency" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[6F105-B27]", "index": 1 } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([FA29B-94F]),ALL([FA29B-94F]))", "context": { "[FA29B-94F]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "MedianPerc" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(MEDIAN([FA29B-94F]),ALL([FA29B-94F]))", "index": 2 } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([02F95-599]),ALL([02F95-599]))+(STDEV([02F95-599]),ALL([02F95-599]))", "context": { "[02F95-599]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SD1" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(MEDIAN([02F95-599]),ALL([02F95-599]))+(STDEV([02F95-599]),ALL([02F95-599]))", "index": 3 } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([D5827-34A]),ALL([D5827-34A]))+2*(STDEV([D5827-34A]),ALL([D5827-34A]))", "context": { "[D5827-34A]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SD2" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(MEDIAN([D5827-34A]),ALL([D5827-34A]))+2*(STDEV([D5827-34A]),ALL([D5827-34A]))", "index": 4 } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([3C2D6-220]),ALL([3C2D6-220]))-(STDEV([3C2D6-220]),ALL([3C2D6-220]))", "context": { "[3C2D6-220]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SDMinus1" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(MEDIAN([3C2D6-220]),ALL([3C2D6-220]))-(STDEV([3C2D6-220]),ALL([3C2D6-220]))", "index": 5 } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([6D5F6-68C]),ALL([6D5F6-68C]))-2*(STDEV([6D5F6-68C]),ALL([6D5F6-68C]))", "context": { "[6D5F6-68C]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SDMinus2" }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "(MEDIAN([6D5F6-68C]),ALL([6D5F6-68C]))-2*(STDEV([6D5F6-68C]),ALL([6D5F6-68C]))", "index": 6 } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "61dc8d84f901bf3740c5b18c", "type": "pivot", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "test_value", "title": "Test Value", "singular": "Test Value", "plural": "Test Value" } ] } }, "instanceid": "82C26-F439-A8", "queryStartTime": "2022-01-03T14:32:03", "canEditFilters": true, "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "script": "/*\nWelcome to your Widget's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at https://developer.sisense.com/pages/viewpage.action?pageId=557127\n*/\n\nwidget.on('processresult',function(w,ev) {\n\n\tvar s = ev.result.series;\n\tvar MedianPerc = \"MedianPerc\";\n\tvar MedianPercVal;\n\tvar SD1 = \"SD1\";\n\tvar SD1Val;\n\tvar SDMinus1 = \"SDMinus1\"\n\tvar SDMinus1Val;\n\tvar SD2 = \"SD2\";\n\tvar SD2Val;\n\tvar SDMinus2 = \"SDMinus2\"\n\tvar SDMinus2Val;\n\n\t$.each(s, function(i, v) {\n\t\tswitch(v.name) {\n\t\t\tcase MedianPerc:\n\t\t\t\tMedianPercVal = (v.data[0].y);\n\t\t\t\tv.data = null\n\t\t\t\tbreak;\n\n\t\t\tcase SD1:\n\t\t\t\tSD1Val = v.data[0].y;\n\t\t\t\tv.data = null\n\t\t\t\tbreak;\n\n\t\t\tcase SDMinus1:\n\t\t\t\tSDMinus1Val = v.data[0].y;\n\t\t\t\tv.data = null\n\t\t\t\tbreak;\n\n\t\t\tcase SD2:\n\t\t\t\tSD2Val = v.data[0].y;\n\t\t\t\tv.data = null\n\t\t\t\tbreak;\n\n\t\t\tcase SDMinus2:\n\t\t\t\tSDMinus2Val = v.data[0].y;\n\t\t\t\tv.data = null\n\t\t\t\tbreak;\n\n\t\t}\n\t});\n\n\t// Fix highcharts bug\n\tHighcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {\n\t\tvar path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));\n\t\tif (path) {\n\t\t\tpath.flat = false;\n\t\t}\n\t\treturn path;\n\t});\n\n\tev.result.xAxis.plotLines= [\n\t\t{\n\t\t\tcolor: 'Red',\n\t\t\twidth: 2,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: MedianPercVal,\n\t\t\tlabel: {\n\t\t\t\ttext: \"Median\",\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"abelregular\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\tcolor: 'Blue',\n\t\t\twidth: 2,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SD1,\n\t\t\tlabel: {\n\t\t\t\ttext: \"1 SD\",\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"abelregular\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\tcolor: 'Blue',\n\t\t\twidth: 2,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SDMinus1Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"-1 SD\",\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"abelregular\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\tcolor: 'Grey',\n\t\t\twidth: 2,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SD2Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"2 SD\",// + ((SD2Val)/10).toFixed(2) +'%',\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"abelregular\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t},\n\t\t{\n\t\t\tcolor: 'Grey',\n\t\t\twidth: 2,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SDMinus2Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"-2 SD\",// + ((SDMinus2Val)/10).toFixed(2) +'%',\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"abelregular\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t}\n\t]\n\n\t//console.log(ev.result.xAxis.plotLines);\n})", "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "JumpTo", "displayFilterPane": false, "displayDashboardsPane": false, "displayToolbarRow": false, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": true, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": false }, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "61dc8d84f901bf3740c5b18a", "drawing": true }, { "title": "", "subtype": "line/spline", "desc": null, "source": null, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Test Value" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "[6F105-B27]", "context": { "[6F105-B27]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "count", "title": "# of unique id" }, "[8334B-DD7]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "countduplicates", "title": "# of id" } }, "title": "Frequency" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#6eda55" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(MEDIAN([FA29B-94F]),ALL([FA29B-94F]))", "context": { "[FA29B-94F]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "MedianPerc" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#ff0000" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(MEDIAN([02F95-599]),ALL([02F95-599]))+(STDEV([02F95-599]),ALL([02F95-599]))", "context": { "[02F95-599]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SD1" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#6EDA55", "type": "color" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(MEDIAN([D5827-34A]),ALL([D5827-34A]))+2*(STDEV([D5827-34A]),ALL([D5827-34A]))", "context": { "[D5827-34A]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SD2" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#fc7570", "type": "color" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(MEDIAN([3C2D6-220]),ALL([3C2D6-220]))-(STDEV([3C2D6-220]),ALL([3C2D6-220]))", "context": { "[3C2D6-220]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SDMinus1" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#fbb755", "type": "color" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "(MEDIAN([6D5F6-68C]),ALL([6D5F6-68C]))-2*(STDEV([6D5F6-68C]),ALL([6D5F6-68C]))", "context": { "[6D5F6-68C]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" } }, "title": "SDMinus2" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color_bkp": { "color": "#218A8C", "type": "color" }, "color": { "color": "#218A8C", "type": "color" } }, "disabled": false } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "61dc8d84f901bf3740c5b18d", "type": "chart/line", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "lineWidth": { "width": "bold" }, "legend": { "enabled": false, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true }, "y2Axis": { "inactive": true, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "test_value", "title": "Test Value", "singular": "Test Value", "plural": "Test Value" } ] } }, "instanceid": "C5699-086E-DE", "queryStartTime": "2022-01-07T14:15:33", "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "script": "var debug = false;\n\nfunction getAxisLocation(rangeArray,value) {\n for (let i=1 ; i< rangeArray.length; i++) {\n if (parseFloat(rangeArray[i-1]) <= value && value <= parseFloat(rangeArray[i])) {\n return (i-1) + (value-parseFloat(rangeArray[i-1])) / parseFloat((rangeArray[i])-rangeArray[i-1]);\n }\n }\n return -1;\n}\n\nwidget.on('processresult',function(w,ev) {\n\n\tvar widgetID = w._id;\n\tvar s = ev.result.series;\n\tvar MedianPerc = \"MedianPerc\";\n\tvar MedianPercVal;\n\tvar SD1 = \"SD1\";\n\tvar SD1Val;\n\tvar SDMinus1 = \"SDMinus1\"\n\tvar SDMinus1Val;\n\tvar SD2 = \"SD2\";\n\tvar SD2Val;\n\tvar SDMinus2 = \"SDMinus2\"\n\tvar SDMinus2Val;\n\t\t\n\t$.each(s, function(i, v) {\n\t\tswitch(v.name) {\n\t\t\tcase MedianPerc:\n\t\t\t\tMedianPercVal = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Median\" with a value of ' + (v.data[0].y) + ' - Placing at data point ' + MedianPercVal);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\n\n\t\t\tcase SD1:\n\t\t\t\tSD1Val = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"SD+1\" with a value of ' + v.data[0].y + ' - Placing at data point ' + SD1Val);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\n\n\t\t\tcase SDMinus1:\n\t\t\t\tSDMinus1Val = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"SD-1\" with a value of ' + v.data[0].y + ' - Placing at data point ' + SDMinus1Val);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\n\n\t\t\tcase SD2:\n\t\t\t\tSD2Val = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"SD+2\" with a value of ' + v.data[0].y + ' - Placing at data point ' + SD2Val);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\n\n\t\t\tcase SDMinus2:\n\t\t\t\tSDMinus2Val = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"SD-2\" with a value of ' + v.data[0].y + ' - Placing at data point ' + SDMinus2Val);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\n\n\t\t}\n\t});\n\n\t// Fix highcharts bug\n\tHighcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {\n\t\tvar path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));\n\t\tif (path) {\n\t\t\tpath.flat = false;\n\t\t}\n\t\treturn path;\n\t});\n\t\n\tev.result.xAxis.plotLines= [];\n\t\n\tif (MedianPercVal != -1) ev.result.xAxis.plotLines.push(\n\t\t{\n\t\t\tcolor: 'Red',\n\t\t\twidth: 1,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: MedianPercVal,\n\t\t\tlabel: {\n\t\t\t\ttext: \"Median\",\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t})\n\telse\n\t\tif (debug) console.log ('The \"Median\" line is out of the X Axis range - Skipping')\n\t\n\tif (SD1Val != -1) ev.result.xAxis.plotLines.push(\n\t\t{\n\t\t\tcolor: 'Blue',\n\t\t\twidth: 1,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SD1Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"1 SD\",\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t})\n\telse\n\t\tif (debug) console.log ('The \"SD +1\" line is out of the X Axis range - Skipping')\n\t\n\tif (SDMinus1Val != -1) ev.result.xAxis.plotLines.push(\n\t\t{\n\t\t\tcolor: 'Blue',\n\t\t\twidth: 1,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SDMinus1Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"-1 SD\",\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t})\n\telse\n\t\tif (debug) console.log ('The \"SD -1\" line is out of the X Axis range - Skipping')\n\t\n\tif (SD2Val != -1) ev.result.xAxis.plotLines.push(\n\t\t{\n\t\t\tcolor: 'Grey',\n\t\t\twidth: 1,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SD2Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"2 SD\",// + ((SD2Val)/10).toFixed(2) +'%',\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t})\n\telse\n\t\tif (debug) console.log ('The \"SD +2\" line is out of the X Axis range - Skipping')\n\t\n\tif (SDMinus2Val != -1) ev.result.xAxis.plotLines.push(\n\t\t{\n\t\t\tcolor: 'Grey',\n\t\t\twidth: 1,\n\t\t\tdashStyle: \"dash\",\n\t\t\tvalue: SDMinus2Val,\n\t\t\tlabel: {\n\t\t\t\ttext: \"-2 SD\",// + ((SDMinus2Val)/10).toFixed(2) +'%',\n\t\t\t\trotation:0,\n\t\t\t\ttextAlign: \"center\",\n\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\ty:15,\n\t\t\t\tx:-3\n\t\t\t}\n\t\t})\n\telse\n\t\tif (debug) console.log ('The \"SD -2\" line is out of the X Axis range - Skipping')\n})", "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "JumpTo", "displayFilterPane": false, "displayDashboardsPane": false, "displayToolbarRow": false, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": true, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": false }, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "dashboardid": "61dc8d84f901bf3740c5b18a" }, { "title": "Version with Cut Down Script", "subtype": "line/spline", "desc": null, "source": null, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Test Value" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } } } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "[32FA2-5C6]/([AA132-686], all([872B0-733]), all([2DFF0-20F]))", "context": { "[32FA2-5C6]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "count", "title": "# of unique id" }, "[AA132-686]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "countduplicates", "title": "# of id" }, "[2DFF0-20F]": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Value" }, "[872B0-733]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "title": "id" } }, "title": "Frequency%" }, "format": { "mask": { "decimals": 2, "percent": true, "percentMultiplier": 100 }, "color": { "type": "color", "color": "#c9c9ff" } }, "disabled": false, "singleSeriesType": "column", "y2": true }, { "jaql": { "type": "measure", "formula": "[6F105-B27]", "context": { "[6F105-B27]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "count", "title": "# of unique id" }, "[8334B-DD7]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "countduplicates", "title": "# of id" } }, "title": "Frequency" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#91ff77" } }, "disabled": false }, { "jaql": { "table": "Tests", "column": "Target", "dim": "[Tests.Target1]", "datatype": "numeric", "agg": "avg", "title": "Target" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#b2b2f7", "type": "color" } } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "61dc8d84f901bf3740c5b18e", "type": "chart/line", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "lineWidth": { "width": "bold" }, "legend": { "enabled": false, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true }, "y2Axis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": true, "templateMainYHasGridLines": true }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "test_value", "title": "Test Value", "singular": "Test Value", "plural": "Test Value" } ] } }, "instanceid": "C5699-086E-DE", "queryStartTime": "2022-01-10T14:40:28", "canEditFilters": true, "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "script": "\n\n//SETS THE OPACITY OF THE COLUMN CHART TO NEAR ZERO TO HIDE IT SO THE COLUMNS DON'T OBSCURE THE SD & MEDIAN LINES\nwidget.on('ready', function(se,ev){\n\t\n opacity = '0.01'\n\n $('.highcharts-series-group .highcharts-series', element).css('fill-opacity', opacity) //change opacity of bars\n $('.highcharts-legend .highcharts-legend-item', element).css('fill-opacity', opacity) //change opacity of legend\n\n}); \n\n//BELL CURVE CODE\nvar debug = true;\n\nfunction getMedian(sorted) {\n const middle = Math.floor(sorted.length / 2);\n\n if (sorted.length % 2 === 0)\n return (sorted[middle - 1] + sorted[middle]) / 2;\n else\n\t\treturn sorted[middle];\n}\n\nfunction getStandardDeviation(numArray) {\n const mean = numArray.reduce((s, n) => s + n) / numArray.length;\n const variance = numArray.reduce((s, n) => s + (n - mean) ** 2, 0) / (numArray.length - 1);\n return Math.sqrt(variance);\n}\n\nfunction getAxisLocation(rangeArray,value) {\n\t// Calculates the {value} relative location on the {rangeArray} axis\n for (let i=1 ; i< rangeArray.length; i++) {\n if (parseFloat(rangeArray[i-1]) <= value && value <= parseFloat(rangeArray[i])) {\n\t\t\t// If within the range of the datapoints [i-1] and [i]\n return (i-1) + (value-parseFloat(rangeArray[i-1])) / parseFloat((rangeArray[i])-rangeArray[i-1]);\n }\n }\n\t\n\t// The value isn't within the axis range\n return -1;\n}\n\n\nwidget.on('processresult',function(w,ev) {\n\n\tvar widgetID = w._id;\n\tvar sdLevels = 2;\n\tvar dataLabel = 'Frequency';\n\tvar Target = 'Target';\n\tvar TargetVal;\n\t\n\t//scan the \"Values\"\n\t$.each(ev.result.series, function(i, v) {\n\t\tswitch(v.name) {\n\t\t\tcase dataLabel:\n\t\t\t\tvalueArray = [];\n\t\t\t\tfor (let i = 0 ; i< v.data.length ; i++) {for (let j = 0 ; j < v.data[i].y ; j++ ) {valueArray.push(parseFloat(ev.result.xAxis.categories[i]))}};\n\t\t\t\tMedianVal = getMedian(valueArray);\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Median\" with a value of ' + MedianVal);\n\t\t\t\tStdevPVal = getStandardDeviation(valueArray);\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Population StDev\" with a value of ' + StdevPVal);\n\t\t\t\t\n\t\t case Target:\n\t\t\t\tTargetVal = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Target\" with a value of ' + v.data[0].y + ' - Placing at data point ' + TargetVal);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\t\n\t\t}\n\t});\n\t\n\t// Fix highcharts bug that prevents showing vertical line labels\n\t// Details: https://github.com/highcharts/highcharts/issues/8477\n\tHighcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {\n\t\tvar path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));\n\t\tif (path) {\n\t\t\tpath.flat = false;\n\t\t}\n\t\treturn path;\n\t});\n\t\n\t// Initialize the vertical lines array\n\tev.result.xAxis.plotLines = [];\n\t\n\t// Add the vertical lines\n\tfor (let i=-sdLevels;i<=sdLevels; i++) {\n\t\tValue = MedianVal + i * StdevPVal\n\t\tPosition = getAxisLocation(ev.result.xAxis.categories,Value);\n\t\t\n\t\tif (debug) console.log (widgetID + ' - Handling i=' + i +' Value=' + Value + ' Position=' + Position)\n\t\t\n\t\tswitch (Math.abs(i)) {\n\t\t\tcase 0:\n\t\t\t\tColor = 'Red'\n\t\t\t\tText = 'Median (' + Value.toFixed(2) + ')'\n\t\t\t\tbreak;\n\t\t\tcase 1:\n\t\t\t\tColor = 'Blue'\n\t\t\t\tText = i + 'SD (' + Value.toFixed(2) + ')'\n\t\t\t\tbreak;\n\t\t\tcase 2:\n\t\t\t\tColor = 'Grey'\n\t\t\t\tText = i + 'SD'\n\t\t\t\tbreak; \t\n\n\t\t}\n\t\t\t\n\n\t\tif (Position != -1) ev.result.xAxis.plotLines.push(\n\t\t\t{\n\t\t\t\tcolor: Color,\n\t\t\t\twidth: 1,\n\t\t\t\tdashStyle: \"dash\",\n\t\t\t\tvalue: Position,\n\t\t\t\tlabel: {\n\t\t\t\t\ttext: Text,\n\t\t\t\t\trotation:0,\n\t\t\t\t\ttextAlign: \"center\",\n\t\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\t\ty:15,\n\t\t\t\t\tx:-3\n\t\t\t\t}\n\t\t\t})\n\t\telse\n\t\t\tif (debug) console.log (widgetID + ' - The \"SD ' + i +'\" line is out of the X Axis range (' + Value + ') - Skipping')\n\t\t\t\n\t\tif (TargetVal != -1) ev.result.xAxis.plotLines.push(\n\t\t {\n\t\t\t\tcolor: 'Black',\n\t\t\t\twidth: 1,\n\t\t\t\t\tdashStyle: \"dash\",\n\t\t\t\t\tvalue: TargetVal,\n\t\t\t\t\tlabel: {\n\t\t\t\t\t\ttext: \"Target\",\n\t\t\t\t\t\trotation:0,\n\t\t\t\t\t\ttextAlign: \"center\",\n\t\t\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\t\t\tfontWeight: \"600\",\n\t\t\t\t\t\ty:15,\n\t\t\t\t\t\tx:-3\n\t\t\t}\n\t\t})\n\telse\n\t\tif (debug) console.log ('The \"Target\" line is out of the X Axis range - Skipping')\t\n\t\t\t\n \n\t}\n});\n\n", "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "JumpTo", "displayFilterPane": false, "displayDashboardsPane": false, "displayToolbarRow": false, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": true, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": false }, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "dashboardid": "61dc8d84f901bf3740c5b18a", "drawing": true }, { "title": "Version with Cut Down Script --NO COLUMN SERIES", "subtype": "line/spline", "desc": null, "source": null, "datasource": { "title": "AQA_Client_Test_Results_000", "fullname": "LocalHost/AQA_Client_Test_Results_000", "id": "aLOCALHOST_aAQAXwAaCLIENTXwAaTESTXwAaRESULTSXwAa000", "address": "LocalHost", "database": "aAQAXwAaClientXwAaTestXwAaResultsXwAa000", "oid": "778df7c6-6b3e-4076-a6e2-9a42b65f0f4e" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Test_Results", "column": "Value", "dim": "[Test_Results.Value1]", "datatype": "numeric", "title": "Test Value" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "number": { "separated": true } } } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "[6F105-B27]", "context": { "[6F105-B27]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "count", "title": "# of unique id" }, "[8334B-DD7]": { "table": "Test_Results", "column": "id", "dim": "[Test_Results.id]", "datatype": "numeric", "agg": "countduplicates", "title": "# of id" } }, "title": "Frequency" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "#91ff77" } }, "disabled": false }, { "jaql": { "table": "Tests", "column": "Target", "dim": "[Tests.Target1]", "datatype": "numeric", "agg": "avg", "title": "Target" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#b2b2f7", "type": "color" } } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "oid": "61dc8d84f901bf3740c5b18f", "type": "chart/line", "iconSmall": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "iconSmallWizard": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAYCAYAAAC8/X7cAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyNpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNS1jMDE0IDc5LjE1MTQ4MSwgMjAxMy8wMy8xMy0xMjowOToxNSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIChNYWNpbnRvc2gpIiB4bXBNTTpJbnN0YW5jZUlEPSJ4bXAuaWlkOkFDOTk4NjMxNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1IiB4bXBNTTpEb2N1bWVudElEPSJ4bXAuZGlkOkFDOTk4NjMyNzU1MTExRTM4QkE0QjUwRjg4NjAzOUM1Ij4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3RhbmNlSUQ9InhtcC5paWQ6QUM5OTg2MkY3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiIHN0UmVmOmRvY3VtZW50SUQ9InhtcC5kaWQ6QUM5OTg2MzA3NTUxMTFFMzhCQTRCNTBGODg2MDM5QzUiLz4gPC9yZGY6RGVzY3JpcHRpb24+IDwvcmRmOlJERj4gPC94OnhtcG1ldGE+IDw/eHBhY2tldCBlbmQ9InIiPz4Ed6mDAAACVUlEQVR42uyYzytmURjHXWPCbsTkHxAyG1Ga1SSr2chWJFnIu2AW76zFQkqzkCl2RLGXpYVSFhZIfkzZyMbPMRYkkVyfh0P3feec+97z3iMppz6d4znnfu/z3POcHy/P9/2ct1xyc956kRmAev+xVL/EO77UNtSDD9Wufc+LKfCRqgxEZ9fzvEvHgafob68uXDpJIXEc+mkewx/YgH/YJqDYhePwnz62CSiOFQAOfqCagz4oCnTlQwcsM6YkhvMZ9RlTEmcGfsD3kH6Z8pEYE2Cln2f4yoVKSKZrhNzeD3QnIjjRjEYPz50ZvnKKPrltrY9GD/WZaREPQFK1v8FXFVgBVXnE7bkKlmz0ccpa35RClYF2RaB9Z5EKYWOd6ZsCkByTLUuO6cEnIylxQ7UZQVzGbYX0a/VJJWt9bQA4Ok/1WXYB2r/Sun9HeMEUz52bOnH0WZ92Vvo8d25cxCqIK6orTde4yts2w6Nr8DOTBzjgRD83w57fCutwCDNQSmAy7e3QLadjYPhfGJKXM+Yi4p7fCutwCDNQSmAZ9RlzEbqNKuebqKYDphZZcNjrcFAW0KigDi3ROVH2qAeWVh97HQ4+66tD60Ff2VNK2F2oU2OrhRpYCaTaaZYHViR9nD7N9jpdYLDnO7qrOdEPC2BWYzsIfp2YxYl+WABjMAy36u8daCRlrh0FoNUnZaz0w7ZRWTBJFmkv9ae0+1DsohZkkkX6oJ92H8o6gAQOH5l+/ViUPQKe1NgTOHxk2JWs9Al4UhdAl6MPvAi6AJzre+//lXjlci/AAOnMDanQIR59AAAAAElFTkSuQmCC", "style": { "lineWidth": { "width": "bold" }, "legend": { "enabled": false, "position": "bottom" }, "seriesLabels": { "enabled": false, "rotation": 0 }, "markers": { "enabled": false, "fill": "filled", "size": "small" }, "xAxis": { "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "x2Title": { "enabled": false }, "gridLines": true, "isIntervalEnabled": false }, "yAxis": { "inactive": false, "enabled": true, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": true, "logarithmic": false, "isIntervalEnabled": true }, "y2Axis": { "inactive": true, "enabled": false, "ticks": true, "labels": { "enabled": true, "rotation": 0 }, "title": { "enabled": false }, "gridLines": false, "logarithmic": false, "isIntervalEnabled": false, "templateMainYHasGridLines": true }, "navigator": { "enabled": true }, "dataLimits": { "seriesCapacity": 50, "categoriesCapacity": 100000 }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "test_value", "title": "Test Value", "singular": "Test Value", "plural": "Test Value" } ] } }, "instanceid": "C5699-086E-DE", "queryStartTime": "2022-01-10T14:43:45", "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "design" }, "realTimeRefreshing": false, "script": "\n//BELL CURVE CODE\nvar debug = true;\n\nfunction getMedian(sorted) {\n const middle = Math.floor(sorted.length / 2);\n\n if (sorted.length % 2 === 0)\n return (sorted[middle - 1] + sorted[middle]) / 2;\n else\n\t\treturn sorted[middle];\n}\n\nfunction getStandardDeviation(numArray) {\n const mean = numArray.reduce((s, n) => s + n) / numArray.length;\n const variance = numArray.reduce((s, n) => s + (n - mean) ** 2, 0) / (numArray.length - 1);\n return Math.sqrt(variance);\n}\n\nfunction getAxisLocation(rangeArray,value) {\n\t// Calculates the {value} relative location on the {rangeArray} axis\n for (let i=1 ; i< rangeArray.length; i++) {\n if (parseFloat(rangeArray[i-1]) <= value && value <= parseFloat(rangeArray[i])) {\n\t\t\t// If within the range of the datapoints [i-1] and [i]\n return (i-1) + (value-parseFloat(rangeArray[i-1])) / parseFloat((rangeArray[i])-rangeArray[i-1]);\n }\n }\n\t\n\t// The value isn't within the axis range\n return -1;\n}\n\n\nwidget.on('processresult',function(w,ev) {\n\n\tvar widgetID = w._id;\n\tvar sdLevels = 2;\n\tvar dataLabel = 'Frequency';\n\tvar Target = 'Target';\n\tvar TargetVal;\n\t\n\t//scan the \"Values\"\n\t$.each(ev.result.series, function(i, v) {\n\t\tswitch(v.name) {\n\t\t\tcase dataLabel:\n\t\t\t\tvalueArray = [];\n\t\t\t\tfor (let i = 0 ; i< v.data.length ; i++) {for (let j = 0 ; j < v.data[i].y ; j++ ) {valueArray.push(parseFloat(ev.result.xAxis.categories[i]))}};\n\t\t\t\tMedianVal = getMedian(valueArray);\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Median\" with a value of ' + MedianVal);\n\t\t\t\tStdevPVal = getStandardDeviation(valueArray);\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Population StDev\" with a value of ' + StdevPVal);\n\t\t\t\t\n\t\t case Target:\n\t\t\t\tTargetVal = getAxisLocation(ev.result.xAxis.categories,v.data[0].y)\n\t\t\t\tif (debug) console.log (widgetID + ' - Found \"Target\" with a value of ' + v.data[0].y + ' - Placing at data point ' + TargetVal);\n\t\t\t\t\n\t\t\t\tv.data = null;\n\t\t\t\tbreak;\t\n\t\t}\n\t});\n\t\n\t// Fix highcharts bug that prevents showing vertical line labels\n\t// Details: https://github.com/highcharts/highcharts/issues/8477\n\tHighcharts.wrap(Highcharts.Axis.prototype, 'getPlotLinePath', function(proceed) {\n\t\tvar path = proceed.apply(this, Array.prototype.slice.call(arguments, 1));\n\t\tif (path) {\n\t\t\tpath.flat = false;\n\t\t}\n\t\treturn path;\n\t});\n\t\n\t// Initialize the vertical lines array\n\tev.result.xAxis.plotLines = [];\n\t\n\t// Add the vertical lines\n\tfor (let i=-sdLevels;i<=sdLevels; i++) {\n\t\tValue = MedianVal + i * StdevPVal\n\t\tPosition = getAxisLocation(ev.result.xAxis.categories,Value);\n\t\t\n\t\tif (debug) console.log (widgetID + ' - Handling i=' + i +' Value=' + Value + ' Position=' + Position)\n\t\t\n\t\tswitch (Math.abs(i)) {\n\t\t\tcase 0:\n\t\t\t\tColor = 'Red'\n\t\t\t\tText = 'Median (' + Value.toFixed(2) + ')'\n\t\t\t\tbreak;\n\t\t\tcase 1:\n\t\t\t\tColor = 'Blue'\n\t\t\t\tText = i + 'SD (' + Value.toFixed(2) + ')'\n\t\t\t\tbreak;\n\t\t\tcase 2:\n\t\t\t\tColor = 'Grey'\n\t\t\t\tText = i + 'SD'\n\t\t\t\tbreak; \t\n\n\t\t}\n\t\t\t\n\n\t\tif (Position != -1) ev.result.xAxis.plotLines.push(\n\t\t\t{\n\t\t\t\tcolor: Color,\n\t\t\t\twidth: 1,\n\t\t\t\tdashStyle: \"dash\",\n\t\t\t\tvalue: Position,\n\t\t\t\tlabel: {\n\t\t\t\t\ttext: Text,\n\t\t\t\t\trotation:0,\n\t\t\t\t\ttextAlign: \"center\",\n\t\t\t\t\tstyle:{fontFamily: \"Montserrat\"},\n\t\t\t\t\ty:15,\n\t\t\t\t\tx:-3\n\t\t\t\t}\n\t\t\t})\n\t\telse\n\t\t\tif (debug) console.log (widgetID + ' - The \"SD ' + i +'\" line is out of the X Axis range (' + Value + ') - Skipping')\n\t\t\t\n\t\t\n \n\t}\n});\n\n", "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "JumpTo", "displayFilterPane": false, "displayDashboardsPane": false, "displayToolbarRow": false, "displayHeaderRow": false, "volatile": false, "hideDrilledDashboards": true, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 1, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": false }, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "dashboardid": "61dc8d84f901bf3740c5b18a", "drawing": true } ], "hierarchies": [] }