{ "title": "Sample ECommerce Ranking", "oid": "6374f411545b0c0038868f59", "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": "5AFD1-D9F0-52", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "724px", "defaultWidth": 512, "widgetid": "6374f805545b0c0038868f5f", "autoHeight": "724px" } ], "width": 100, "stretchable": false, "pxlWidth": 0, "index": 0 } ] } ], "pxlWidth": 0, "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": [], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "", "type": "pivot2", "subtype": "pivot2", "oid": "6374f805545b0c0038868f5f", "desc": null, "source": null, "datasource": { "fullname": "localhost/Sample ECommerce", "id": "localhost_aSampleIAAaECommerce", "address": "LocalHost", "database": "aSampleIAAaECommerce", "live": false, "title": "Sample ECommerce" }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "Country", "column": "Country", "dim": "[Country.Country]", "datatype": "text", "merged": true, "title": "Country" }, "instanceid": "6DFFF-E0A4-52", "panel": "rows", "field": { "id": "[Country.Country]", "index": 0 } }, { "jaql": { "table": "Commerce", "column": "Condition", "dim": "[Commerce.Condition]", "datatype": "text", "merged": true, "title": "Condition" }, "instanceid": "3A4FF-ED13-DD", "panel": "rows", "field": { "id": "[Commerce.Condition]", "index": 1 } } ] }, { "name": "values", "items": [ { "jaql": { "table": "Commerce", "column": "Quantity", "dim": "[Commerce.Quantity]", "datatype": "numeric", "agg": "sum", "title": "Total Quantity" }, "instanceid": "FA10B-C854-0C", "panel": "measures", "field": { "id": "[Commerce.Quantity]_sum", "index": 2 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [ { "jaql": { "table": "Country", "column": "Country", "dim": "[Country.Country]", "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", "filter": { "top": 10, "by": { "type": "measure", "formula": "IF(\n ([951DB-A96],[9485F-831]) >= 2\n ,1,NULL\n )", "context": { "[951DB-A96]": { "table": "Commerce", "column": "Condition", "dim": "[Commerce.Condition]", "datatype": "text", "merged": true, "agg": "count", "title": "# of unique Condition" }, "[9485F-831]": { "table": "Commerce", "column": "Condition", "dim": "[Commerce.Condition]", "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", "filter": { "explicit": true, "multiSelection": true, "members": [ "Refurbished", "Unspecified" ] }, "title": "Condition" } }, "title": "Formula" }, "rankingMessage": "IF(\n ([# of unique Condition],[Condition]) >= 2\n ,1,NULL\n )" }, "title": "Country", "collapsed": false }, "instanceid": "A8E85-AA91-5A", "panel": "scope" } ] } ], "usedFormulasMapping": {} }, "style": { "scroll": false, "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": "country", "title": "Country", "singular": "Country", "plural": "Country" }, { "id": "condition", "title": "Condition", "singular": "Condition", "plural": "Condition" } ] } }, "instanceid": "48352-3C36-B1", "queryStartTime": "2022-11-16T09:52:27", "prevSortObjects": [], "widgetTimingLoged": false, "drawing": true, "viewState": { "activeTab": "filters" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true }, "dashboardid": "6374f411545b0c0038868f59", "tenantId": "635ac8b249d22c001bf25310", "canEditFilters": true, "lastOpened": null } ], "hierarchies": [] }