{ "title": "Sample ECommerce", "oid": "63618836545b0c0038868f31", "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": "F95A6-30F0-6E", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "380px", "defaultWidth": 512, "widgetid": "6361899e545b0c0038868f35", "autoHeight": "204px" } ], "width": 100, "stretchable": false, "pxlWidth": 825.328, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "6373ca6c545b0c0038868f4a", "height": "380px" } ], "width": 100, "stretchable": false, "pxlWidth": 1238, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 96, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "63744814545b0c0038868f53", "height": "380px" } ], "width": 100, "stretchable": false, "pxlWidth": 1238, "index": 0 } ] } ], "pxlWidth": 1238, "index": 0 } ], "container": {} }, "original": null, "dataExploration": false, "tenantId": "635ac8b249d22c001bf25310", "lastOpened": null, "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce" }, "filters": [ { "jaql": { "table": "Commerce", "column": "Date", "dim": "[Commerce.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "years", "collapsed": true, "title": "Years in Date", "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce" }, "isDashboardFilter": true, "firstday": "mon", "locale": "en-us", "filter": { "explicit": true, "multiSelection": true, "members": [ "2013-01-01T00:00:00" ] } }, "instanceid": "C4EBA-C2D8-05", "isCascading": false, "disabled": false }, { "jaql": { "table": "Commerce", "column": "Country ID", "dim": "[Commerce.Country ID]", "datatype": "numeric", "merged": true, "title": "Country ID", "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce" }, "collapsed": true, "isDashboardFilter": true, "firstday": "mon", "locale": "en-us", "filter": { "explicit": true, "multiSelection": true, "members": [ "1" ] } }, "instanceid": "F399B-330E-22", "isCascading": false, "disabled": false }, { "jaql": { "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce" }, "firstday": "mon", "locale": "en-us", "title": "Category", "collapsed": true, "isDashboardFilter": true, "filter": { "explicit": true, "multiSelection": true, "members": [ "Apple Mac Desktops", "Apple Mac Laptops" ] } }, "instanceid": "06CE1-D4F6-75", "isCascading": false, "disabled": false } ], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "filterToDatasourceMapping": {}, "widgets": [ { "title": "Starting", "type": "chart/line", "subtype": "line/basic", "oid": "6361899e545b0c0038868f35", "desc": null, "source": null, "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce", "lastBuildTime": "2021-04-20T11:54:27.528Z" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Commerce", "column": "Date", "dim": "[Commerce.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "weeks", "title": "Weeks in Date", "firstday": "mon" }, "instanceid": "A10A3-F62B-18", "panel": "rows", "field": { "id": "[Commerce.Date (Calendar)]_years", "index": 0 }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "dateAndTime": "MM/dd/y HH:mm", "isdefault": true }, "continuous": true }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity" }, "instanceid": "14DAD-C62F-36", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 1 }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#00cee6", "type": "color" } }, "statisticalModels": { "trend": { "isEnabled": true, "isViewerDisabled": true, "trendType": "linear", "ignoreAnomalies": false, "trendOnForecast": false, "compare": { "isEnabled": false, "period": "year" }, "isAccessible": true }, "anomaly": { "isAccessible": false }, "breakpoint": { "isAccessible": false } } }, { "jaql": { "type": "measure", "formula": "RSUM([C9571-F66])", "context": { "[C9571-F66]": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity (1)" } }, "title": "RSUM(Total Quantity (1))" }, "instanceid": "14DAD-C62F-36", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 1 }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#9b9bd7", "type": "color" } }, "statisticalModels": { "trend": { "isEnabled": true, "isViewerDisabled": true, "trendType": "linear", "ignoreAnomalies": false, "trendOnForecast": false, "compare": { "isEnabled": false, "period": "year" }, "isAccessible": true }, "anomaly": { "isAccessible": false }, "breakpoint": { "isAccessible": false } }, "originalJaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity (1)" }, "quickFunction": "RSUM" } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "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": true }, "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": "weeks_in_date", "title": "Weeks in Date", "singular": "Weeks in Date", "plural": "Weeks in Date" } ] } }, "instanceid": "5500F-3A88-65", "queryStartTime": "2022-11-15T12:20:35", "prevSortObjects": [], "widgetTimingLoged": false, "realTimeRefreshing": false, "drawing": true, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 1357189200000, "max": 1386219600000 }, "selectorLocked": false }, "dashboardid": "63618836545b0c0038868f31", "tenantId": "635ac8b249d22c001bf25310", "continuousDates": true, "disableSelctor": false, "forcedRedraw": false, "hasExcessiveSeries": false, "maxDate": 1386219600000, "minDate": 1357189200000, "nullAsZero": false, "tickLevel": "week", "dateLevel": "weeks", "showNulls": { "Weeks in Date": false, "Total Quantity": false, "RSUM(Total Quantity (1))": false, "Years in Date": false, "Country ID": false, "Category": false }, "tickInterval": 604800000, "lastOpened": null }, { "title": "Missing as Zero", "type": "chart/line", "subtype": "line/basic", "oid": "6373ca6c545b0c0038868f4a", "desc": null, "source": null, "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce", "lastBuildTime": "2021-04-20T11:54:27.528Z" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Commerce", "column": "Date", "dim": "[Commerce.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "weeks", "title": "Weeks in Date", "firstday": "mon" }, "instanceid": "A10A3-F62B-18", "panel": "rows", "field": { "id": "[Commerce.Date (Calendar)]_years", "index": 0 }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "dateAndTime": "MM/dd/y HH:mm", "isdefault": true }, "continuous": true }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity" }, "instanceid": "14DAD-C62F-36", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 1 }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#00cee6", "type": "color" }, "nullzero": true }, "statisticalModels": { "trend": { "isEnabled": true, "isViewerDisabled": true, "trendType": "linear", "ignoreAnomalies": false, "trendOnForecast": false, "compare": { "isEnabled": false, "period": "year" }, "isAccessible": true }, "anomaly": { "isAccessible": false }, "breakpoint": { "isAccessible": false } } }, { "jaql": { "type": "measure", "formula": "RSUM([C9571-F66])", "context": { "[C9571-F66]": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity (1)" } }, "title": "RSUM(Total Quantity (1))" }, "instanceid": "14DAD-C62F-36", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 1 }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#9b9bd7", "type": "color" }, "nullzero": true }, "statisticalModels": { "trend": { "isEnabled": true, "isViewerDisabled": true, "trendType": "linear", "ignoreAnomalies": false, "trendOnForecast": false, "compare": { "isEnabled": false, "period": "year" }, "isAccessible": true }, "anomaly": { "isAccessible": false }, "breakpoint": { "isAccessible": false } }, "originalJaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity (1)" }, "quickFunction": "RSUM" } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "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": true }, "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": "weeks_in_date", "title": "Weeks in Date", "singular": "Weeks in Date", "plural": "Weeks in Date" } ] } }, "instanceid": "5500F-3A88-65", "queryStartTime": "2022-11-15T12:21:01", "prevSortObjects": [], "widgetTimingLoged": false, "realTimeRefreshing": false, "tenantId": "635ac8b249d22c001bf25310", "continuousDates": true, "disableSelctor": false, "forcedRedraw": false, "hasExcessiveSeries": false, "maxDate": 1386219600000, "minDate": 1357189200000, "nullAsZero": false, "tickLevel": "week", "tickInterval": 604800000, "showNulls": { "Total Quantity": true, "Weeks in Date": false, "RSUM(Total Quantity (1))": true, "Years in Date": false, "Country ID": false, "Category": false }, "dateLevel": "weeks", "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 1357189200000, "max": 1386219600000 }, "selectorLocked": false }, "dashboardid": "63618836545b0c0038868f31", "drawing": true, "lastOpened": null }, { "title": "Starting with Script", "type": "chart/line", "subtype": "line/basic", "oid": "63744814545b0c0038868f53", "desc": null, "source": null, "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce", "lastBuildTime": "2021-04-20T11:54:27.528Z" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Commerce", "column": "Date", "dim": "[Commerce.Date (Calendar)]", "datatype": "datetime", "merged": true, "level": "weeks", "title": "Weeks in Date", "firstday": "mon" }, "instanceid": "A10A3-F62B-18", "panel": "rows", "field": { "id": "[Commerce.Date (Calendar)]_years", "index": 0 }, "format": { "mask": { "years": "yyyy", "quarters": "yyyy Q", "months": "MM/yyyy", "weeks": "ww yyyy", "days": "shortDate", "minutes": "HH:mm", "dateAndTime": "MM/dd/y HH:mm", "isdefault": true }, "continuous": true }, "hierarchies": [ "calendar", "calendar - weeks" ] } ] }, { "name": "values", "items": [ { "jaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity" }, "instanceid": "14DAD-C62F-36", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 1 }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#00cee6", "type": "color" } }, "statisticalModels": { "trend": { "isEnabled": true, "isViewerDisabled": true, "trendType": "linear", "ignoreAnomalies": false, "trendOnForecast": false, "compare": { "isEnabled": false, "period": "year" }, "isAccessible": true }, "anomaly": { "isAccessible": false }, "breakpoint": { "isAccessible": false } } }, { "jaql": { "type": "measure", "formula": "RSUM([C9571-F66])", "context": { "[C9571-F66]": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity (1)" } }, "title": "RSUM(Total Quantity (1))" }, "instanceid": "14DAD-C62F-36", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 1 }, "format": { "mask": { "type": "number", "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "color": "#9b9bd7", "type": "color" } }, "statisticalModels": { "trend": { "isEnabled": true, "isViewerDisabled": true, "trendType": "linear", "ignoreAnomalies": false, "trendOnForecast": false, "compare": { "isEnabled": false, "period": "year" }, "isAccessible": true }, "anomaly": { "isAccessible": false }, "breakpoint": { "isAccessible": false } }, "originalJaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity (1)" }, "quickFunction": "RSUM" } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "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": true }, "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": "weeks_in_date", "title": "Weeks in Date", "singular": "Weeks in Date", "plural": "Weeks in Date" } ] } }, "instanceid": "5500F-3A88-65", "queryStartTime": "2022-11-15T21:17:29", "prevSortObjects": [], "widgetTimingLoged": false, "realTimeRefreshing": false, "tenantId": "635ac8b249d22c001bf25310", "continuousDates": true, "disableSelctor": false, "forcedRedraw": false, "hasExcessiveSeries": false, "maxDate": 1386219600000, "minDate": 1357189200000, "nullAsZero": false, "tickLevel": "week", "dateLevel": "weeks", "showNulls": { "Weeks in Date": false, "Total Quantity": false, "RSUM(Total Quantity (1))": false, "Years in Date": false, "Country ID": false, "Category": false }, "tickInterval": 604800000, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 1357189200000, "max": 1386219600000 }, "selectorLocked": false }, "dashboardid": "63618836545b0c0038868f31", "drawing": true, "script": "widget.on(\"beforeviewloaded\",function(scope, args){\nargs.options.plotOptions.series.connectNulls = true;\n});", "lastOpened": null } ], "hierarchies": [] }