{ "title": "Sample Lead Generation", "oid": "61ced6969730c2090cfba457", "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, "height": "757px", "defaultWidth": 512, "widgetid": "61ced70c9730c2090cfba45a", "autoHeight": "757px" } ], "width": 100, "stretchable": false, "pxlWidth": 1237, "index": 0 } ] } ], "pxlWidth": 1237, "index": 0 } ], "container": {} }, "original": null, "dataExploration": false, "datasource": { "title": "Sample Retail", "fullname": "LocalHost/Sample Retail", "id": "aLOCALHOST_aSAMPLEIAAaRETAIL", "address": "LocalHost", "database": "aSampleIAAaRetail" }, "filters": [], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "", "subtype": "line/basic", "oid": "61ced70c9730c2090cfba45a", "desc": null, "source": null, "datasource": { "title": "Sample Retail", "fullname": "LocalHost/Sample Retail", "id": "aLOCALHOST_aSAMPLEIAAaRETAIL", "address": "LocalHost", "database": "aSampleIAAaRetail" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Fact_Purchase_Orders", "column": "StockedQty", "dim": "[Fact_Purchase_Orders.StockedQty]", "datatype": "numeric", "title": "StockedQty" } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "count([C1C14-901])", "context": { "[C1C14-901]": { "table": "Fact_Purchase_Orders", "column": "PurchaseOrderID", "dim": "[Fact_Purchase_Orders.PurchaseOrderID]", "datatype": "numeric", "title": "PurchaseOrderID" } }, "title": "Frequency" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#00cee6", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([91EF0-929]),ALL([91EF0-929]))", "context": { "[91EF0-929]": { "table": "Fact_Purchase_Orders", "column": "StockedQty", "dim": "[Fact_Purchase_Orders.StockedQty]", "datatype": "numeric", "title": "StockedQty" } }, "title": "MedianPerc" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#9b9bd7", "type": "color" } } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([4E6C6-34A]),ALL([4E6C6-34A]))+(STDEV([4E6C6-34A]),ALL([4E6C6-34A]))", "context": { "[4E6C6-34A]": { "table": "Fact_Purchase_Orders", "column": "StockedQty", "dim": "[Fact_Purchase_Orders.StockedQty]", "datatype": "numeric", "title": "StockedQty" } }, "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" } } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([0C179-F08]),ALL([0C179-F08]))+2*(STDEV([0C179-F08]),ALL([0C179-F08]))", "context": { "[0C179-F08]": { "table": "Fact_Purchase_Orders", "column": "StockedQty", "dim": "[Fact_Purchase_Orders.StockedQty]", "datatype": "numeric", "title": "StockedQty" } }, "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" } } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([916D2-FDB]),ALL([916D2-FDB]))-(STDEV([916D2-FDB]),ALL([916D2-FDB]))", "context": { "[916D2-FDB]": { "table": "Fact_Purchase_Orders", "column": "StockedQty", "dim": "[Fact_Purchase_Orders.StockedQty]", "datatype": "numeric", "title": "StockedQty" } }, "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" } } }, { "jaql": { "type": "measure", "formula": "(MEDIAN([B8BBB-A15]),ALL([B8BBB-A15]))-2*(STDEV([B8BBB-A15]),ALL([B8BBB-A15]))", "context": { "[B8BBB-A15]": { "table": "Fact_Purchase_Orders", "column": "StockedQty", "dim": "[Fact_Purchase_Orders.StockedQty]", "datatype": "numeric", "title": "StockedQty" } }, "title": "SDMinus2" }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#218A8C", "type": "color" } } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ] }, "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": true, "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": "stockedqty", "title": "StockedQty", "singular": "StockedQty", "plural": "StockedQty" } ] } }, "instanceid": "C5699-086E-DE", "queryStartTime": "2021-12-31T12:36:28", "drawing": true, "canEditFilters": true, "disableSelctor": false, "widgetTimingLoged": false, "continuousDates": false, "nullAsZero": false, "forcedRedraw": false, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": null, "max": null } }, "dashboardid": "61ced6969730c2090cfba457", "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: 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: \"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})" } ], "hierarchies": [] }