{ "oid": "61bc8ee498f8b514782a6c16", "allowChangeSubscription": false, "dataExploration": false, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "defaultFilterRelations": null, "defaultFilters": [ { "jaql": { "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce", "lastBuildTime": "2020-06-09T15:50:07" }, "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand", "collapsed": true, "isDashboardFilter": true, "filter": { "explicit": false, "multiSelection": true, "all": true } }, "instanceid": "B8454-5175-15", "isCascading": false, "disabled": false } ], "desc": "", "editing": false, "filterToDatasourceMapping": {}, "filters": [ { "jaql": { "table": "Commerce", "column": "Date", "dim": "[Commerce.Date (Calendar)]", "datatype": "datetime", "merged": true, "isDashboardFilter": true, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "firstday": "mon", "locale": "en-us", "filter": { "level": "years", "explicit": true, "multiSelection": true, "members": [ "2012-01-01T00:00:00" ] }, "level": "years", "title": "Years in Date", "collapsed": true }, "instanceid": "01783-CBFC-2F", "isCascading": false }, { "jaql": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand", "isDashboardFilter": true, "collapsed": true, "locale": "en-us", "filter": { "contains": "a" } }, "instanceid": "75DFF-6AE1-74", "isCascading": false, "disabled": false }, { "jaql": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "title": "Category", "isDashboardFilter": true, "collapsed": true, "locale": "en-us", "filter": { "contains": "a" } }, "instanceid": "0B7A2-3FA1-19", "isCascading": false, "disabled": false }, { "jaql": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country", "isDashboardFilter": true, "collapsed": true, "locale": "en-us", "filter": { "contains": "a" } }, "instanceid": "F2FE5-18BB-7E", "isCascading": false, "disabled": false }, { "jaql": { "table": "Commerce", "column": "Age Range", "dim": "[Commerce.Age Range]", "datatype": "text", "merged": true, "isDashboardFilter": true, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "locale": "en-us", "filter": { "explicit": false, "multiSelection": true, "all": true }, "title": "Age Range", "collapsed": true }, "instanceid": "6F8C1-8A37-84", "isCascading": false }, { "jaql": { "table": "Commerce_New", "column": "Gender", "dim": "[Commerce_New.Gender]", "datatype": "text", "merged": true, "isDashboardFilter": true, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "locale": "en-us", "filter": { "explicit": false, "multiSelection": true, "all": true }, "title": "Gender", "collapsed": true }, "instanceid": "4C666-155C-E3", "isCascading": false } ], "isPublic": null, "lastOpened": null, "layout": { "instanceid": "67331-DC23-EC", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 68, "maxHeight": 969, "minWidth": 128, "maxWidth": 2048, "defaultWidth": 512, "widgetid": "61bc8ee498f8b514782a6c17", "height": "84px" } ], "width": 100, "stretchable": false, "pxlWidth": 1438.19, "index": 0 } ] }, { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "752px", "defaultWidth": 512, "widgetid": "61bc8ee498f8b514782a6c18", "autoHeight": "752px" } ], "width": 100, "stretchable": false, "pxlWidth": 1438.19, "index": 0 } ] } ], "pxlWidth": 1438.19, "index": 0 } ], "container": { "sizzle1740074791447": { "undefined": { "parentNode": [ 534.5956008354743, 27, true ] } } } }, "original": null, "parentFolder": "61c44b8583642f002bf1838b", "previewLayout": [], "settings": { "autoUpdateOnFiltersChange": true }, "source": "61c44eda83642f002bf186b0", "style": { "palette": { "name": "Vivid", "colors": [ "#00cee6", "#9b9bd7", "#6EDA55", "#fc7570", "#fbb755", "#218A8C" ] } }, "subscription": { "executionPerDay": 1, "schedule": "* * * * * *", "isDataChange": true, "type": "onUpdate", "reportType": { "inline": true }, "emailSettings": { "isEmail": true, "isPdf": false }, "context": { "dashboardid": "61bc8ee498f8b514782a6c16" }, "startAt": "2022-12-20", "tzName": "America/New_York", "timezone": 300, "active": false, "custom": false }, "title": "Blox - Free Search Bar (Three Columns)", "type": "dashboard", "filterRelations": [ { "datasource": "Sample ECommerce", "filterRelations": { "type": "LogicalExpression", "operator": "AND", "left": { "type": "LogicalExpression", "operator": "AND", "left": { "type": "LogicalExpression", "operator": "AND", "left": { "type": "Identifier", "instanceId": "01783-CBFC-2F" }, "right": { "type": "ParenthesizedLogicalExpression", "value": { "type": "LogicalExpression", "operator": "OR", "left": { "type": "LogicalExpression", "operator": "OR", "left": { "type": "Identifier", "instanceId": "75DFF-6AE1-74" }, "right": { "type": "Identifier", "instanceId": "0B7A2-3FA1-19" } }, "right": { "type": "Identifier", "instanceId": "F2FE5-18BB-7E" } } } }, "right": { "type": "Identifier", "instanceId": "6F8C1-8A37-84" } }, "right": { "type": "Identifier", "instanceId": "4C666-155C-E3" } } } ], "widgets": [ { "dashboardid": "61bc8ee498f8b514782a6c16", "oid": "61bc8ee498f8b514782a6c17", "custom": { "barcolumnchart": { "type": "BloX", "isTypeValid": false, "customMenuEnabled": false, "updateOnEveryChange": true, "addTotalOption": "No", "sortCategoriesOption": "Default", "sortBreakByOption": "Default", "currModalOpened": "None", "totalSeriesName": "Total" } }, "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "desc": null, "displayMenu": false, "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": 4, "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 }, "drilledDashboardDisplay": {}, "instanceid": "C68A3-C655-93", "metadata": { "ignore": { "dimensions": [], "all": true, "ids": [] }, "panels": [ { "name": "Items", "items": [ { "jaql": { "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand" }, "PanelName": "Brand", "instanceid": "63096-0B28-5D" }, { "jaql": { "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "title": "Category" }, "instanceid": "9A189-ED02-5B", "PanelName": "Category" }, { "jaql": { "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country" }, "instanceid": "5DE48-E6A0-0E", "PanelName": "Country" } ] }, { "name": "Values", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "options": { "dashboardFiltersMode": "filter", "selector": true, "title": false, "drillTarget": "dummy", "autoUpdateOnEveryChange": true, "triggersDomready": true }, "prevSortObjects": [], "query": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "format": "json", "isMaskedResult": true, "metadata": [ { "jaql": { "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand" }, "PanelName": "Brand", "instanceid": "63096-0B28-5D", "handlers": [] }, { "jaql": { "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "title": "Category" }, "instanceid": "9A189-ED02-5B", "PanelName": "Category", "handlers": [] }, { "jaql": { "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country" }, "instanceid": "5DE48-E6A0-0E", "PanelName": "Country", "handlers": [] } ], "m2mThresholdFlag": 0 }, "selection": null, "source": "61c4518883642f002bf194d7", "style": { "currentCard": { "style": {}, "script": "", "title": "", "titleStyle": [ { "display": "show" } ], "showCarousel": true, "carouselAnimation": { "showButtons": false }, "body": [ { "type": "Container" }, { "type": "ColumnSet", "separator": false, "spacing": "default", "columns": [ { "type": "Column", "width": "170px", "items": [ { "type": "TextBlock", "size": "small", "weight": "regular", "wrap": true, "text": "Search Brand", "style": { "color": "black", "padding-left": "10px", "margin-left": "10px", "backgroundColor": "white" } } ] }, { "type": "Column", "spacing": "none", "width": "175px", "items": [ { "type": "Container", "spacing": "none", "width": "150px", "items": [ { "type": "Input.Text", "id": "data.userInput", "class": "", "title": "New Input", "placeholder": "APPLES" } ] } ] }, { "type": "Column", "spacing": "none", "width": "100px", "items": [ { "type": "ActionSet", "margin": "0px", "padding": "0px", "actions": [ { "type": "SearchBar2", "title": "Search" } ] } ] }, { "type": "Column", "spacing": "", "width": "80px", "items": [ { "type": "ActionSet", "margin": "0px", "padding": "0px", "actions": [ { "type": "SearchClear2", "title": "Clear", "style": { "color": "white", "padding-left": "10px", "margin-left": "-11px", "backgroundColor": "grey" } } ] } ] } ] } ], "actions": [] }, "currentConfig": { "fontFamily": "Open Sans", "fontSizes": { "default": 14, "small": 16, "medium": 20, "large": 50, "extraLarge": 32 }, "fontWeights": { "default": 500, "light": 100, "bold": 1000 }, "containerStyles": { "default": { "backgroundColor": "#FFFFFF", "foregroundColors": { "default": { "normal": "#3a4356" }, "white": { "normal": "#ffffff" }, "grey": { "normal": "#9ea2ab" }, "orange": { "normal": "#f2B900" }, "yellow": { "normal": "#ffcb05" }, "black": { "normal": "#000000" }, "lightGreen": { "normal": "#3ADCCA" }, "green": { "normal": "#54a254" }, "red": { "normal": "#dd1111" }, "accent": { "normal": "#2E89FC" }, "good": { "normal": "#54a254" }, "warning": { "normal": "#e69500" }, "attention": { "normal": "#cc3300" } } } }, "imageSizes": { "default": 40, "small": 40, "medium": 80, "large": 160 }, "imageSet": { "imageSize": "medium", "maxImageHeight": 100 }, "actions": { "color": "white", "backgroundColor": "navy", "maxActions": 5, "spacing": "none", "buttonSpacing": 20, "actionsOrientation": "horizontal", "actionAlignment": "left", "showCard": { "actionMode": "inline", "inlineTopMargin": 16, "style": "default" } }, "spacing": { "default": 5, "none": 0, "small": 20, "medium": 60, "large": 20, "extraLarge": 40, "padding": 0 }, "separator": { "lineThickness": 3, "lineColor": "#ffcb05" }, "factSet": { "title": { "size": "default", "color": "default", "weight": "bold", "warp": true }, "value": { "size": "default", "color": "default", "weight": "default", "warp": true }, "spacing": 20 }, "supportsInteractivity": true, "imageBaseUrl": "" }, "currentCardName": "default", "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "brand", "title": "Brand", "singular": "Brand", "plural": "Brand" }, { "id": "category", "title": "Category", "singular": "Category", "plural": "Category" }, { "id": "country", "title": "Country", "singular": "Country", "plural": "Country" } ] } }, "subtype": "BloX", "title": "Search Bar! FASTER THAN A FILTER.", "type": "BloX", "wasRendered": false, "realTimeRefreshing": false }, { "dashboardid": "61bc8ee498f8b514782a6c16", "oid": "61bc8ee498f8b514782a6c18", "custom": { "barcolumnchart": { "type": "pivot", "isTypeValid": false, "customMenuEnabled": false, "updateOnEveryChange": true, "addTotalOption": "No", "sortCategoriesOption": "Default", "sortBreakByOption": "Default", "currModalOpened": "None", "totalSeriesName": "Total" } }, "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "desc": null, "displayMenu": false, "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": 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 }, "instanceid": "330CB-0759-FC", "metadata": { "ignore": { "dimensions": [], "all": false, "ids": [] }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country" }, "instanceid": "6B50C-BC98-FA", "panel": "rows", "field": { "id": "[Country.Country]", "index": 0 } }, { "jaql": { "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "title": "Category", "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" } }, "field": { "id": "[Category.Category]", "index": 1 }, "instanceid": "4ACA7-143D-91", "panel": "rows" }, { "jaql": { "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand", "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" } }, "field": { "id": "[Brand.Brand]", "index": 2 }, "instanceid": "E21EC-DDE2-D4", "panel": "rows" } ] }, { "name": "values", "items": [ { "jaql": { "table": "Commerce", "column": "Revenue", "dim": "[Commerce.Revenue]", "datatype": "numeric", "agg": "sum", "title": "Total Revenue" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color" } }, "field": { "id": "[Commerce.Revenue]_sum", "index": 3 }, "instanceid": "2CBFB-9E01-CB", "panel": "measures" } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "interactivePivot": { "enable": false }, "selectorLocked": false }, "prevSortObjects": [], "query": { "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "format": "pivot", "grandTotals": { "title": "Grand Total" }, "metadata": [ { "jaql": { "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country" }, "instanceid": "6B50C-BC98-FA", "panel": "rows", "field": { "id": "[Country.Country]", "index": 0 }, "handlers": [] }, { "jaql": { "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "title": "Category", "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" } }, "field": { "id": "[Category.Category]", "index": 1 }, "instanceid": "4ACA7-143D-91", "panel": "rows", "handlers": [] }, { "jaql": { "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand", "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" } }, "field": { "id": "[Brand.Brand]", "index": 2 }, "instanceid": "E21EC-DDE2-D4", "panel": "rows", "handlers": [] }, { "jaql": { "table": "Commerce", "column": "Revenue", "dim": "[Commerce.Revenue]", "datatype": "numeric", "agg": "sum", "title": "Total Revenue" }, "format": { "mask": { "abbreviations": { "t": false, "b": false, "m": false, "k": false }, "decimals": "auto", "currency": { "symbol": "$", "position": "pre" } }, "color": { "type": "color", "color": "transparent" } }, "field": { "id": "[Commerce.Revenue]_sum", "index": 3 }, "instanceid": "2CBFB-9E01-CB", "panel": "measures", "handlers": [ {}, {} ] }, { "jaql": { "table": "Commerce", "column": "Date", "dim": "[Commerce.Date (Calendar)]", "datatype": "datetime", "merged": true, "isDashboardFilter": true, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "firstday": "mon", "locale": "en-us", "filter": { "level": "years", "explicit": true, "multiSelection": true, "members": [ "2012-01-01T00:00:00" ] }, "level": "years", "title": "Years in Date", "collapsed": true }, "isCascading": false, "instanceid": "01783-CBFC-2F", "panel": "scope" }, { "jaql": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "table": "Brand", "column": "Brand", "dim": "[Brand.Brand]", "datatype": "text", "merged": true, "title": "Brand", "isDashboardFilter": true, "collapsed": true, "locale": "en-us", "filter": { "contains": "ab" } }, "disabled": false, "isCascading": false, "instanceid": "75DFF-6AE1-74", "panel": "scope" }, { "jaql": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "table": "Category", "column": "Category", "dim": "[Category.Category]", "datatype": "text", "merged": true, "title": "Category", "isDashboardFilter": true, "collapsed": true, "locale": "en-us", "filter": { "contains": "ab" } }, "disabled": false, "isCascading": false, "instanceid": "0B7A2-3FA1-19", "panel": "scope" }, { "jaql": { "datasource": { "address": "LocalHost", "title": "Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "database": "aSampleIAAaECommerce", "fullname": "LocalHost/Sample ECommerce" }, "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country", "isDashboardFilter": true, "collapsed": true, "locale": "en-us", "filter": { "contains": "ab" } }, "disabled": false, "isCascading": false, "instanceid": "F2FE5-18BB-7E", "panel": "scope" }, { "jaql": { "table": "Commerce", "column": "Age Range", "dim": "[Commerce.Age Range]", "datatype": "text", "merged": true, "isDashboardFilter": true, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "locale": "en-us", "filter": { "explicit": false, "multiSelection": true, "all": true }, "title": "Age Range", "collapsed": true }, "isCascading": false, "instanceid": "6F8C1-8A37-84", "panel": "scope" }, { "jaql": { "table": "Commerce_New", "column": "Gender", "dim": "[Commerce_New.Gender]", "datatype": "text", "merged": true, "isDashboardFilter": true, "datasource": { "title": "Sample ECommerce", "fullname": "LocalHost/Sample ECommerce", "id": "aLOCALHOST_aSAMPLEIAAaECOMMERCE", "address": "LocalHost", "database": "aSampleIAAaECommerce" }, "locale": "en-us", "filter": { "explicit": false, "multiSelection": true, "all": true }, "title": "Gender", "collapsed": true }, "isCascading": false, "instanceid": "4C666-155C-E3", "panel": "scope" } ], "m2mThresholdFlag": 0 }, "script": null, "script_old": null, "selection": null, "source": "61c4518883642f002bf194d8", "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": "category", "title": "Category", "singular": "Category", "plural": "Category" }, { "id": "brand", "title": "Brand", "singular": "Brand", "plural": "Brand" }, { "id": "country", "title": "Country", "singular": "Country", "plural": "Country" } ] }, "scroll": false }, "subtype": "pivot", "title": "Report", "type": "pivot2", "wasRendered": false, "realTimeRefreshing": false } ], "hierarchies": [ { "_id": "5deaa26b55f2cb08c43cb908", "title": "Test1", "alwaysIncluded": true, "levels": [ { "title": "Category", "table": "Category", "column": "Category", "datatype": "text", "dim": "[Category.Category]", "index": 0, "_id": "5deaa26b55f2cb08c43cb907" }, { "title": "Brand", "table": "Brand", "column": "Brand", "datatype": "text", "dim": "[Brand.Brand]", "index": 1, "_id": "5deaa26f55f2cb08c43cb90a" }, { "title": "Country", "table": "Country", "column": "Country", "datatype": "text", "dim": "[Country.Country]", "index": 2, "_id": "5deaa27555f2cb08c43cb90c" } ], "cubeId": "6142d757c80a065ff5a24ccc", "lastUpdated": "2023-12-17T10:23:52.992Z", "serverAddress": "LocalHost", "elasticubeTitle": "Sample ECommerce" }, { "_id": "6453ddcc04305f0033acb309", "title": "Country", "alwaysIncluded": true, "levels": [ { "title": "Country", "table": "Country", "column": "Country", "datatype": "text", "dim": "[Country.Country]", "index": 0, "_id": "6453ddcb04305f0033acb308" }, { "title": "Category", "table": "Category", "column": "Category", "datatype": "text", "dim": "[Category.Category]", "index": 1, "_id": "6453ddd104305f0033acb30b" }, { "title": "Brand", "table": "Brand", "column": "Brand", "datatype": "text", "dim": "[Brand.Brand]", "index": 2, "_id": "6453ddd504305f0033acb30d" } ], "cubeId": "6142d757c80a065ff5a24ccc", "lastUpdated": "2024-07-22T13:59:09.440Z", "serverAddress": "LocalHost", "elasticubeTitle": "Sample ECommerce" } ] }