{ "title": "Week over Week Analysis with Custom Fiscal Year", "desc": "", "source": "68e3cf71383aeadfc675cfcb", "type": "dashboard", "style": { "palette": { "name": "Vivid", "colors": [ "#00cee6", "#9b9bd7", "#6EDA55", "#fc7570", "#fbb755", "#218A8C" ] } }, "layout": { "instanceid": "00A6C-7D27-2C", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 64, "maxHeight": 1028, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "68e426d8d1f2916ada51d2c7", "height": "568px" } ], "width": 39.500393175209844, "stretchable": false, "pxlWidth": 647.998, "index": 0 }, { "elements": [ { "minHeight": 64, "maxHeight": 1028, "minWidth": 48, "maxWidth": 1028, "defaultWidth": 512, "widgetid": "68e42716d1f2916ada51d2d2", "height": "568px" } ], "width": 60.499606824790156, "stretchable": false, "pxlWidth": 992.48, "index": 1 } ] } ], "pxlWidth": 1640.49, "index": 0 } ] }, "original": null, "previewLayout": [], "oid": "68e426d8d1f2916ada51d2c5", "allowChangeSubscription": false, "dataExploration": false, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "defaultFilters": [ { "jaql": { "table": "Date", "column": "Fiscal Year", "dim": "[Date.Fiscal Year]", "datatype": "numeric", "columnTitle": "Fiscal Year", "tableTitle": "Date", "isDashboardFilter": true, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "locale": "en-us", "title": "Fiscal Year", "collapsed": true, "filter": { "explicit": true, "multiSelection": false, "members": [ "2025" ] } }, "instanceid": "625D7-AC14-5E", "isCascading": false, "disabled": false }, { "jaql": { "table": "Date", "column": "Fiscal Year to Compare", "dim": "[Date.Fiscal Year to Compare]", "datatype": "numeric", "columnTitle": "Fiscal Year to Compare", "tableTitle": "Date", "isDashboardFilter": true, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "locale": "en-us", "title": "Fiscal Year to Compare", "collapsed": true, "filter": { "explicit": true, "multiSelection": false, "members": [ 2024 ] } }, "instanceid": "C5A28-0125-5A", "isCascading": false, "locked": true, "disabled": false }, { "jaql": { "table": "Date", "column": "Fiscal Week Number", "dim": "[Date.Fiscal Week Number]", "datatype": "numeric", "columnTitle": "Fiscal Week Number", "tableTitle": "Date", "isDashboardFilter": true, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "locale": "en-us", "title": "Fiscal Week Number", "collapsed": true, "filter": { "explicit": true, "multiSelection": true, "members": [ "3" ] } }, "instanceid": "50B5E-10FD-97", "isCascading": false, "disabled": false } ], "editing": false, "filterRelations": [], "filterToDatasourceMapping": {}, "filters": [ { "jaql": { "table": "Date", "column": "Fiscal Year", "dim": "[Date.Fiscal Year]", "datatype": "numeric", "columnTitle": "Fiscal Year", "tableTitle": "Date", "isDashboardFilter": true, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "locale": "en-us", "title": "Fiscal Year", "collapsed": true, "filter": { "explicit": true, "multiSelection": false, "members": [ "2025" ] } }, "instanceid": "625D7-AC14-5E", "isCascading": false, "disabled": false }, { "jaql": { "table": "Date", "column": "Fiscal Year to Compare", "dim": "[Date.Fiscal Year to Compare]", "datatype": "numeric", "columnTitle": "Fiscal Year to Compare", "tableTitle": "Date", "isDashboardFilter": true, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "locale": "en-us", "title": "Fiscal Year to Compare", "collapsed": true, "filter": { "explicit": true, "multiSelection": false, "members": [ 2024 ] } }, "instanceid": "C5A28-0125-5A", "isCascading": false, "locked": true, "disabled": false }, { "jaql": { "table": "Date", "column": "Fiscal Week Number", "dim": "[Date.Fiscal Week Number]", "datatype": "numeric", "columnTitle": "Fiscal Week Number", "tableTitle": "Date", "isDashboardFilter": true, "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "locale": "en-us", "title": "Fiscal Week Number", "collapsed": true, "filter": { "explicit": true, "multiSelection": true, "members": [ "3", "4" ] } }, "instanceid": "50B5E-10FD-97", "isCascading": false, "disabled": false } ], "isPublic": null, "lastOpened": null, "parentFolder": "68e426e4d1f2916ada51d2d0", "script": "/*\nWelcome to your Dashboard's Script.\n\nTo learn how you can access the Widget and Dashboard objects, see the online documentation at https://developer.sisense.com/guides/customJs/extensions\n*/\n\n/************************************************** This script is used to synchronize the selections of a pair of Year (numeric) filters *************************************************/\n/** The second filter will be automatically set to one year prior to the first filter. E.g. if the first filter is set to 2025, the second filter will automatically be updated to 2024 ***/\n/************************************************** The script also replicates the disabled state from the first filter to the second filter **********************************************/\n\n//Specify the names of the filters, starting from the first filter. This is the only part of this script that requires your input.\nvar filterNames = ['Fiscal Year', 'Fiscal Year to Compare']\n\n//Every time a filter is changed, this code is executed\ndashboard.on('filterschanged',function(d) {\n\n\t//Find the first filter by name\n\tvar filter1FilterObject = dashboard.filters.$$items.find((item) => {\n\t\tif (item.jaql && item.jaql.title.indexOf(filterNames[0]) !== -1) {\n\t\t\treturn true;\n\t\t}\n\t});\n\n\t//Get the JAQL filter selection of the first filter\n\tvar filter1FilterObjectJAQL = filter1FilterObject.jaql;\n\n\t//Get the JAQL filter disabled state of the first filter\n\tvar filter1FilterObjectDisabled = filter1FilterObject.disabled;\n\n\t//Find the second filter by name\n\tvar filter2FilterObject = dashboard.filters.$$items.find((item) => {\n\t\tif (item.jaql && item.jaql.title.indexOf(filterNames[1]) !== -1) {\n\t\t\treturn true;\n\t\t}\n\t});\n\n\tif(typeof filter2FilterObject != 'undefined') {\n\t\tfilter2FilterObject.jaql.filter.members[0] = filter1FilterObjectJAQL.filter.members[0] - 1;\n\t\tfilter2FilterObject.disabled = filter1FilterObjectDisabled;\n\n\t}\n\n\t//Refresh the dashboard\n\tdashboard.refresh();\n\n});\n\n\n\n/*************************** This script is used to hide filters ***************************/\n/**************** Uncomment the script below to hide the second year filter ****************/\n\n/*\n\n//Specify the names of the filters to hide. This is the only part of this script that requires your input.\nconst filterTitles = ['Fiscal Year to Compare'];\n\ndashboard.on('initialized', (dash, args) => {\n\n\tdash.filters.$$items.forEach((item, index) => {\n\n\t\tif (filterTitles.includes(item.jaql.title)) {\n\n\t\t\tvar styles = `.global-filters .ew-content-host .ew-panel .ew-item-wrapper:nth-child(${index+2}) { \n\n\t\t\t\tdisplay: none;\n\n\t\t\t\t}`\n\n\t\t\tvar styleSheet = document.createElement(\"style\")\n\n\t\t\tstyleSheet.innerText = styles\n\n\t\t\tdocument.head.appendChild(styleSheet)\n\n\t\t}\n\n\t})\n\n})\n\n*/", "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "Revenue (Selected Weeks)", "type": "indicator", "subtype": "indicator/numeric", "oid": "68e426d8d1f2916ada51d2c7", "desc": null, "source": "68e3cf71383aeadfc675cfcd", "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [], "all": false }, "panels": [ { "name": "value", "items": [ { "jaql": { "type": "measure", "formula": "(sum([925EA-9A7]), [AEFE6-5CD])", "context": { "[925EA-9A7]": { "table": "Commerce", "column": "Revenue", "dim": "[Commerce.Revenue]", "datatype": "numeric", "columnTitle": "Revenue", "tableTitle": "Commerce", "agg": "sum", "title": "Total Revenue" }, "[AEFE6-5CD]": { "table": "Date", "column": "Fiscal Year", "dim": "[Date.Fiscal Year]", "datatype": "numeric", "columnTitle": "Fiscal Year", "tableTitle": "Date", "title": "@Fiscal Year" } }, "title": "Selected Year", "columnTitle": "(sum([Total Revenue]), [@Fiscal Year])" }, "instanceid": "31F58-B931-26", "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" }, "abbreviateAll": false }, "color": { "colorIndex": 0, "type": "color" } } } ] }, { "name": "secondary", "items": [ { "jaql": { "type": "measure", "formula": "(sum([6DC25-87A]), [FB01A-07D])", "context": { "[FB01A-07D]": { "table": "Date", "column": "Fiscal Year to Compare", "dim": "[Date.Fiscal Year to Compare]", "datatype": "numeric", "columnTitle": "Fiscal Year to Compare", "tableTitle": "Date", "title": "@Fiscal Year to Compare" }, "[6DC25-87A]": { "table": "Commerce", "column": "Revenue", "dim": "[Commerce.Revenue]", "datatype": "numeric", "columnTitle": "Revenue", "tableTitle": "Commerce", "agg": "sum", "title": "Total Revenue" } }, "title": "Previous Year", "columnTitle": "Formula" }, "instanceid": "EFB04-BE46-21", "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" }, "abbreviateAll": false } } } ] }, { "name": "min", "items": [] }, { "name": "max", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "dashboardid": "68e426d8d1f2916ada51d2c5", "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": true, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": true, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 3, "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 }, "instanceid": "FF8D8-B4C6-27", "options": { "dashboardFiltersMode": "filter", "selector": false, "disallowSelector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "supportsHierarchies": false }, "realTimeRefreshing": false, "style": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": true, "enabled": true }, "secondaryTitle": { "inactive": false, "enabled": true } }, "indicator/numeric": { "subtype": "simple", "skin": "vertical", "components": { "title": { "inactive": false, "enabled": true }, "icon": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } }, "indicator/gauge": { "subtype": "round", "skin": "1", "components": { "ticks": { "inactive": false, "enabled": true }, "labels": { "inactive": false, "enabled": true }, "title": { "inactive": false, "enabled": true }, "secondaryTitle": { "inactive": true, "enabled": true } } }, "narration": { "display": "above", "verbosity": "low", "labels": [] } }, "lastOpened": null }, { "title": "Revenue over Time (Week over Week)", "type": "chart/line", "subtype": "line/basic", "oid": "68e42716d1f2916ada51d2d2", "desc": null, "source": "68e3cf71383aeadfc675cfcd", "datasource": { "address": "LocalHost", "title": "Sample ECommerce - Custom Fiscal Year", "id": "localhost_aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "database": "aSampleIAAaECommerceIAAaLQAaIAAaCustomIAAaFiscalIAAaYear", "fullname": "localhost/Sample ECommerce - Custom Fiscal Year", "live": false }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [ "50B5E-10FD-97" ], "all": false }, "panels": [ { "name": "x-axis", "items": [ { "jaql": { "table": "Date", "column": "Fiscal Week Number", "dim": "[Date.Fiscal Week Number]", "datatype": "numeric", "columnTitle": "Fiscal Week Number", "tableTitle": "Date", "title": "Fiscal Week Number" }, "instanceid": "5F9D8-53EE-6C", "panel": "rows", "field": { "id": "[Date.Fiscal Week Number]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "(sum([925EA-9A7]), [AEFE6-5CD])", "context": { "[925EA-9A7]": { "table": "Commerce", "column": "Revenue", "dim": "[Commerce.Revenue]", "datatype": "numeric", "columnTitle": "Revenue", "tableTitle": "Commerce", "agg": "sum", "title": "Total Revenue" }, "[AEFE6-5CD]": { "table": "Date", "column": "Fiscal Year", "dim": "[Date.Fiscal Year]", "datatype": "numeric", "columnTitle": "Fiscal Year", "tableTitle": "Date", "title": "@Fiscal Year" } }, "title": "Selected Year", "columnTitle": "(sum([Total Revenue]), [@Fiscal Year])", "datatype": "numeric" }, "instanceid": "31F58-B931-26", "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" }, "abbreviateAll": false }, "color": { "colorIndex": 0, "type": "color" } }, "panel": "measures", "field": { "id": "(sum([925EA-9A7]), [AEFE6-5CD])", "index": 1 } }, { "jaql": { "type": "measure", "formula": "(sum([6DC25-87A]), [FB01A-07D])", "context": { "[FB01A-07D]": { "table": "Date", "column": "Fiscal Year to Compare", "dim": "[Date.Fiscal Year to Compare]", "datatype": "numeric", "columnTitle": "Fiscal Year to Compare", "tableTitle": "Date", "title": "@Fiscal Year to Compare" }, "[6DC25-87A]": { "table": "Commerce", "column": "Revenue", "dim": "[Commerce.Revenue]", "datatype": "numeric", "columnTitle": "Revenue", "tableTitle": "Commerce", "agg": "sum", "title": "Total Revenue" } }, "title": "Previous Year", "columnTitle": "Formula", "datatype": "numeric" }, "instanceid": "EFB04-BE46-21", "format": { "mask": { "abbreviations": { "t": true, "b": true, "m": true, "k": true }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" }, "abbreviateAll": false }, "color": { "colorIndex": 1, "type": "color" } }, "panel": "measures", "field": { "id": "(sum([6DC25-87A]), [FB01A-07D])", "index": 2 } } ] }, { "name": "break by", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": true, "displayToolbarRow": true, "displayHeaderRow": true, "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 }, "instanceid": "18C76-2582-68", "realTimeRefreshing": false, "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": true, "isIntervalEnabled": false }, "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": { "display": "above", "verbosity": "low", "labels": [ { "id": "fiscal_week_number", "title": "Fiscal Week Number", "singular": "Fiscal Week Number", "plural": "Fiscal Week Number" } ] } }, "options": { "dashboardFiltersMode": "filter", "selector": true, "triggersDomready": true, "autoUpdateOnEveryChange": true, "drillToAnywhere": true, "previousScrollerLocation": { "min": 0, "max": 52 }, "selectorLocked": false }, "dashboardid": "68e426d8d1f2916ada51d2c5" } ], "hierarchies": [] }