You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@superset.apache.org by ru...@apache.org on 2025/03/12 15:03:52 UTC
(superset) branch update_sales_dashboard created (now 7c30df9e66)
This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a change to branch update_sales_dashboard
in repository https://gitbox.apache.org/repos/asf/superset.git
at 7c30df9e66 chore(examples):touching up Vehicle Sales a bit
This branch includes the following new commits:
new 7c30df9e66 chore(examples):touching up Vehicle Sales a bit
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
(superset) 01/01: chore(examples):touching up Vehicle Sales a bit
Posted by ru...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a commit to branch update_sales_dashboard
in repository https://gitbox.apache.org/repos/asf/superset.git
commit 7c30df9e66dfdb79e51cf379e22f741ad0ec412c
Author: Evan Rusackas <ev...@rusackas.com>
AuthorDate: Wed Mar 12 09:03:41 2025 -0600
chore(examples):touching up Vehicle Sales a bit
---
.../configs/charts/Vehicle Sales/Items_Sold.yaml | 57 ++
.../Vehicle Sales/Items_by_Product_Line.yaml | 64 ++
.../Number_of_Deals_for_each_Combination.yaml | 25 +-
.../Overall_Sales_By_Product_Line.yaml | 25 +-
.../Proportion_of_Revenue_by_Product_Line.yaml | 136 +++--
.../charts/Vehicle Sales/Quarterly_Sales.yaml | 149 +++--
.../Quarterly_Sales_By_Product_Line_113.yaml | 87 +++
.../charts/Vehicle Sales/Revenue_by_Deal_Size.yaml | 66 +-
.../Seasonality_of_Revenue_per_Product_Line.yaml | 21 +-
.../charts/Vehicle Sales/Total_Revenue.yaml | 64 +-
.../configs/dashboards/Sales_Dashboard.yaml | 666 ++++++++++++++++-----
.../datasets/examples/cleaned_sales_data.yaml | 125 ++--
12 files changed, 1036 insertions(+), 449 deletions(-)
diff --git a/superset/examples/configs/charts/Vehicle Sales/Items_Sold.yaml b/superset/examples/configs/charts/Vehicle Sales/Items_Sold.yaml
new file mode 100644
index 0000000000..2e18f5c9e0
--- /dev/null
+++ b/superset/examples/configs/charts/Vehicle Sales/Items_Sold.yaml
@@ -0,0 +1,57 @@
+slice_name: Items Sold
+description: null
+certified_by: null
+certification_details: null
+viz_type: big_number
+params:
+ datasource: 21__table
+ viz_type: big_number
+ slice_id: 115
+ x_axis: order_date
+ metric:
+ aggregate: SUM
+ column:
+ column_name: quantity_ordered
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 914
+ is_dttm: false
+ python_date_format: null
+ type: BIGINT
+ verbose_name: null
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ isNew: false
+ label: SUM(Sales)
+ optionName: metric_twq59hf4ej_g70qjfmehsq
+ sqlExpression: null
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: order_date
+ show_trend_line: true
+ start_y_axis_at_zero: true
+ color_picker:
+ a: 1
+ b: 135
+ g: 122
+ r: 0
+ header_font_size: 0.4
+ subheader_font_size: 0.15
+ y_axis_format: SMART_NUMBER
+ time_format: smart_date
+ rolling_type: cumsum
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"order_date","op":"TEMPORAL_RANGE","val":"No
+ filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[{"columnType":"BASE_AXIS","sqlExpression":"order_date","label":"order_date","expressionType":"SQL"}],"metrics":[{"aggregate":"SUM","column":{"column_name":"quantity_ordered","description":null,"expression":null,"filterable":true,"groupby":true,"id":914,"is_dttm":false,"python_date_format":null,"type":"BIGINT","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sa [...]
+ filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"order_date"}],"show_trend_line":true,"start_y_axis_at_zero":true,"color_picker":{"a":1,"b":135,"g":122,"r":0},"header_font_size":0.4,"subheader_font_size":0.15,"y_axis_format":"SMART_NUMBER","time_format":"smart_date","rolling_type":"cumsum","extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
+cache_timeout: null
+uuid: c3d643cd-fd6f-4659-a5b7-59402487a8d0
+version: 1.0.0
+dataset_uuid: e8623bb9-5e00-f531-506a-19607f5f8005
diff --git a/superset/examples/configs/charts/Vehicle Sales/Items_by_Product_Line.yaml b/superset/examples/configs/charts/Vehicle Sales/Items_by_Product_Line.yaml
new file mode 100644
index 0000000000..f593648e38
--- /dev/null
+++ b/superset/examples/configs/charts/Vehicle Sales/Items_by_Product_Line.yaml
@@ -0,0 +1,64 @@
+slice_name: Items by Product Line
+description: null
+certified_by: null
+certification_details: null
+viz_type: table
+params:
+ datasource: 21__table
+ viz_type: table
+ slice_id: 111
+ query_mode: aggregate
+ groupby:
+ - product_line
+ temporal_columns_lookup:
+ order_date: true
+ metrics:
+ - aggregate: SUM
+ column:
+ column_name: quantity_ordered
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 914
+ is_dttm: false
+ optionName: _col_QuantityOrdered
+ python_date_format: null
+ type: BIGINT
+ verbose_name: null
+ expressionType: SIMPLE
+ hasCustomLabel: true
+ isNew: false
+ label: '# of Products Sold'
+ optionName: metric_skdbciwba6g_z1r5w1pxlqj
+ sqlExpression: null
+ all_columns: []
+ percent_metrics: null
+ adhoc_filters:
+ - clause: WHERE
+ subject: order_date
+ operator: TEMPORAL_RANGE
+ comparator: No filter
+ expressionType: SIMPLE
+ order_by_cols: []
+ row_limit: null
+ order_desc: true
+ table_timestamp_format: smart_date
+ allow_render_html: true
+ show_cell_bars: true
+ color_pn: true
+ comparison_color_scheme: Green
+ comparison_type: values
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"order_date","op":"TEMPORAL_RANGE","val":"No
+ filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["product_line"],"metrics":[{"aggregate":"SUM","column":{"column_name":"quantity_ordered","description":null,"expression":null,"filterable":true,"groupby":true,"id":914,"is_dttm":false,"optionName":"_col_QuantityOrdered","python_date_format":null,"type":"BIGINT","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":true,"isNew":false,"label":"#
+ of Products Sold","optionName":"metric_skdbciwba6g_z1r5w1pxlqj","sqlExpression":null}],"orderby":[[{"aggregate":"SUM","column":{"column_name":"quantity_ordered","description":null,"expression":null,"filterable":true,"groupby":true,"id":914,"is_dttm":false,"optionName":"_col_QuantityOrdered","python_date_format":null,"type":"BIGINT","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":true,"isNew":false,"label":"#
+ of Products Sold","optionName":"metric_skdbciwba6g_z1r5w1pxlqj","sqlExpression":null},false]],"annotation_layers":[],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[],"time_offsets":[]}],"form_data":{"datasource":"21__table","viz_type":"table","slice_id":111,"query_mode":"aggregate","groupby":["product_line"],"temporal_columns_lookup":{"order_date":true},"metrics":[{"aggregate":"SUM","column":{"column_name":"quantity_ordere [...]
+ of Products Sold","optionName":"metric_skdbciwba6g_z1r5w1pxlqj","sqlExpression":null}],"all_columns":[],"percent_metrics":null,"adhoc_filters":[{"clause":"WHERE","subject":"order_date","operator":"TEMPORAL_RANGE","comparator":"No
+ filter","expressionType":"SIMPLE"}],"order_by_cols":[],"row_limit":null,"order_desc":true,"table_timestamp_format":"smart_date","allow_render_html":true,"show_cell_bars":true,"color_pn":true,"comparison_color_scheme":"Green","comparison_type":"values","extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
+cache_timeout: null
+uuid: b8b7ca30-6291-44b0-bc64-ba42e2892b86
+version: 1.0.0
+dataset_uuid: e8623bb9-5e00-f531-506a-19607f5f8005
diff --git a/superset/examples/configs/charts/Vehicle Sales/Number_of_Deals_for_each_Combination.yaml b/superset/examples/configs/charts/Vehicle Sales/Number_of_Deals_for_each_Combination.yaml
index 414b0f0f8a..ccd8af3947 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Number_of_Deals_for_each_Combination.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Number_of_Deals_for_each_Combination.yaml
@@ -1,20 +1,7 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Number of Deals (for each Combination)
+description: null
+certified_by: null
+certification_details: null
viz_type: heatmap_v2
params:
adhoc_filters: []
@@ -42,10 +29,12 @@ params:
viz_type: heatmap_v2
xscale_interval: null
value_bounds:
- - null
- - null
+ - null
+ - null
y_axis_format: SMART_NUMBER
yscale_interval: null
+ annotation_layers: []
+query_context: null
cache_timeout: null
uuid: bd20fc69-dd51-46c1-99b5-09e37a434bf1
version: 1.0.0
diff --git a/superset/examples/configs/charts/Vehicle Sales/Overall_Sales_By_Product_Line.yaml b/superset/examples/configs/charts/Vehicle Sales/Overall_Sales_By_Product_Line.yaml
index 82cedd6ff0..3602ccc25d 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Overall_Sales_By_Product_Line.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Overall_Sales_By_Product_Line.yaml
@@ -1,20 +1,7 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Overall Sales (By Product Line)
+description: null
+certified_by: null
+certification_details: null
viz_type: pie
params:
adhoc_filters: []
@@ -61,6 +48,12 @@ params:
time_range: No filter
url_params: {}
viz_type: pie
+ annotation_layers: []
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"time_range":"No
+ filter","granularity":"order_date","filters":[],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":["product_line"],"metrics":[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_3sk6pfj3m7i_64h77bs4sly","sqlExpression":null}],"annotation_layers":[],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{}}],"form_data":{"adhoc_filters":[],"annotation_layers":[],"color_scheme":"supersetColors","datasource":"21__table","donut":true,"granularity_sqla":"order_date","groupby":["product_line"],"innerR [...]
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_3sk6pfj3m7i_64h77bs4sly","sqlExpression":null},"number_format":"SMART_NUMBER","outerRadius":65,"queryFields":{"groupby":"groupby","metric":"metrics"},"row_limit":null,"show_labels":true,"show_labels_threshold":2,"show_legend":false,"slice_id":120,"time_range":"No
+ filter","url_params":{},"viz_type":"pie","force":false,"result_format":"json","result_type":"full"},"result_format":"json","result_type":"full"}'
cache_timeout: null
uuid: 09c497e0-f442-1121-c9e7-671e37750424
version: 1.0.0
diff --git a/superset/examples/configs/charts/Vehicle Sales/Proportion_of_Revenue_by_Product_Line.yaml b/superset/examples/configs/charts/Vehicle Sales/Proportion_of_Revenue_by_Product_Line.yaml
index 5ccb305b66..8951fdf1e7 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Proportion_of_Revenue_by_Product_Line.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Proportion_of_Revenue_by_Product_Line.yaml
@@ -1,74 +1,82 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Proportion of Revenue by Product Line
+description: null
+certified_by: null
+certification_details: null
viz_type: echarts_area
params:
- adhoc_filters: []
- annotation_layers: []
- bottom_margin: auto
- color_scheme: supersetColors
- comparison_type: values
- contribution: true
- datasource: 23__table
- granularity_sqla: order_date
- groupby:
- - product_line
- label_colors: {}
- line_interpolation: linear
+ datasource: 21__table
+ viz_type: echarts_area
+ slice_id: 116
+ x_axis: order_date
+ time_grain_sqla: P1M
+ x_axis_sort_asc: true
+ x_axis_sort_series: name
+ x_axis_sort_series_ascending: true
metrics:
- - aggregate: SUM
- column:
- column_name: sales
- description: null
- expression: null
- filterable: true
- groupby: true
- id: 917
- is_dttm: false
- optionName: _col_Sales
- python_date_format: null
- type: DOUBLE PRECISION
- verbose_name: null
- expressionType: SIMPLE
- hasCustomLabel: false
- isNew: false
- label: (Sales)
- optionName: metric_3is69ofceho_6d0ezok7ry6
- sqlExpression: null
- order_desc: true
- queryFields:
- groupby: groupby
- metrics: metrics
- rich_tooltip: true
- rolling_type: None
+ - aggregate: SUM
+ column:
+ column_name: sales
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 917
+ is_dttm: false
+ optionName: _col_Sales
+ python_date_format: null
+ type: DOUBLE PRECISION
+ verbose_name: null
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ isNew: false
+ label: (Sales)
+ optionName: metric_3is69ofceho_6d0ezok7ry6
+ sqlExpression: null
+ groupby:
+ - product_line
+ adhoc_filters:
+ - clause: WHERE
+ subject: order_date
+ operator: TEMPORAL_RANGE
+ comparator: '2003-01-01T00:00:00 : 2005-06-01T00:00:00'
+ expressionType: SIMPLE
row_limit: null
- show_brush: auto
+ truncate_metric: true
+ show_empty_columns: true
+ rolling_type: null
+ comparison_type: values
+ annotation_layers: []
+ forecastPeriods: 10
+ forecastInterval: 0.8
+ x_axis_title_margin: 15
+ y_axis_title_margin: 15
+ y_axis_title_position: Left
+ sort_series_type: sum
+ color_scheme: supersetColors
+ time_shift_color: true
+ seriesType: line
+ opacity: 0.2
+ stack: Stack
+ only_total: true
+ markerSize: 6
show_legend: true
- stacked_style: stack
- time_grain_sqla: P1M
- time_range: "2003-01-01T00:00:00 : 2005-06-01T00:00:00"
- url_params: {}
- viz_type: echarts_area
- x_axis_format: smart_date
- x_ticks_layout: auto
- y_axis_bounds:
- - null
- - null
+ legendType: scroll
+ legendOrientation: top
+ x_axis_time_format: smart_date
+ rich_tooltip: true
+ showTooltipTotal: true
+ tooltipTimeFormat: smart_date
y_axis_format: SMART_NUMBER
+ truncateXAxis: true
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"order_date","op":"TEMPORAL_RANGE","val":"2003-01-01T00:00:00
+ : 2005-06-01T00:00:00"}],"extras":{"time_grain_sqla":"P1M","having":"","where":""},"applied_time_extras":{},"columns":[{"timeGrain":"P1M","columnType":"BASE_AXIS","sqlExpression":"order_date","label":"order_date","expressionType":"SQL"},"product_line"],"metrics":[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_3is69ofceho_6d0ezok7ry6","sqlExpression":null}],"orderby":[[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_3is69ofceho_6d0ezok7ry6","sqlExpression":null},false]],"annotation_layers":[],"series_columns":["product_line"],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"time_offsets":[],"post_processing":[{"operation":"pivot","options":{"index":["order_date"],"columns":["product_line"],"aggregates":{"(Sales)":{"operato [...]
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_3is69ofceho_6d0ezok7ry6","sqlExpression":null}],"groupby":["product_line"],"adhoc_filters":[{"clause":"WHERE","subject":"order_date","operator":"TEMPORAL_RANGE","comparator":"2003-01-01T00:00:00
+ : 2005-06-01T00:00:00","expressionType":"SIMPLE"}],"row_limit":null,"truncate_metric":true,"show_empty_columns":true,"rolling_type":null,"comparison_type":"values","annotation_layers":[],"forecastPeriods":10,"forecastInterval":0.8,"x_axis_title_margin":15,"y_axis_title_margin":15,"y_axis_title_position":"Left","sort_series_type":"sum","color_scheme":"supersetColors","time_shift_color":true,"seriesType":"line","opacity":0.2,"stack":"Stack","only_total":true,"markerSize":6,"show_legend": [...]
cache_timeout: null
uuid: 08aff161-f60c-4cb3-a225-dc9b1140d2e3
version: 1.0.0
diff --git a/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales.yaml b/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales.yaml
index a575c47bed..2b06ac62e5 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales.yaml
@@ -1,85 +1,84 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Quarterly Sales
+description: null
+certified_by: null
+certification_details: null
viz_type: echarts_timeseries_bar
params:
- adhoc_filters: []
- annotation_layers: []
- bottom_margin: auto
- color_scheme: supersetColors
- comparison_type: null
- datasource: 23__table
- granularity_sqla: order_date
- groupby: []
- label_colors:
- Classic Cars: "#5AC189"
- Motorcycles: "#666666"
- Planes: "#FCC700"
- QuantityOrdered: "#454E7C"
- SUM(Sales): "#1FA8C9"
- Ships: "#A868B7"
- Trains: "#3CCCCB"
- Trucks and Buses: "#E04355"
- Vintage Cars: "#FF7F44"
- left_margin: auto
- line_interpolation: linear
+ datasource: 21__table
+ viz_type: echarts_timeseries_bar
+ slice_id: 118
+ x_axis: order_date
+ time_grain_sqla: P3M
+ x_axis_sort_asc: true
+ x_axis_sort_series: name
+ x_axis_sort_series_ascending: true
metrics:
- - aggregate: SUM
- column:
- column_name: sales
- description: null
- expression: null
- filterable: true
- groupby: true
- id: 917
- is_dttm: false
- optionName: _col_Sales
- python_date_format: null
- type: DOUBLE PRECISION
- verbose_name: null
- expressionType: SIMPLE
- hasCustomLabel: false
- isNew: false
- label: SUM(Sales)
- optionName: metric_tjn8bh6y44_7o4etwsqhal
- sqlExpression: null
- order_desc: true
- queryFields:
- groupby: groupby
- metrics: metrics
- rich_tooltip: true
- rolling_type: null
+ - aggregate: SUM
+ column:
+ column_name: sales
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 917
+ is_dttm: false
+ optionName: _col_Sales
+ python_date_format: null
+ type: DOUBLE PRECISION
+ verbose_name: null
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ isNew: false
+ label: SUM(Sales)
+ optionName: metric_tjn8bh6y44_7o4etwsqhal
+ sqlExpression: null
+ groupby:
+ - status
+ adhoc_filters:
+ - clause: WHERE
+ subject: order_date
+ operator: TEMPORAL_RANGE
+ comparator: No filter
+ expressionType: SIMPLE
row_limit: 10000
- show_brush: auto
- show_legend: false
- slice_id: 668
+ truncate_metric: true
+ show_empty_columns: true
+ rolling_type: null
time_compare: null
- time_grain_sqla: P3M
- time_range: No filter
- url_params: {}
- viz_type: echarts_timeseries_bar
- x_axis_format: "%m/%d/%Y"
- x_axis_label: Quarter starting
- x_ticks_layout: auto
- y_axis_bounds:
- - null
- - null
+ comparison_type: null
+ annotation_layers: []
+ forecastPeriods: 10
+ forecastInterval: 0.8
+ orientation: vertical
+ x_axis_title_margin: 15
+ y_axis_title_margin: 15
+ y_axis_title_position: Left
+ sort_series_type: sum
+ color_scheme: supersetColors
+ time_shift_color: true
+ stack: Stack
+ only_total: true
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ x_axis_time_format: smart_date
y_axis_format: null
- y_axis_label: Total Sales
+ y_axis_bounds:
+ - null
+ - null
+ truncateXAxis: true
+ rich_tooltip: true
+ showTooltipTotal: true
+ tooltipTimeFormat: smart_date
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"order_date","op":"TEMPORAL_RANGE","val":"No
+ filter"}],"extras":{"time_grain_sqla":"P3M","having":"","where":""},"applied_time_extras":{},"columns":[{"timeGrain":"P3M","columnType":"BASE_AXIS","sqlExpression":"order_date","label":"order_date","expressionType":"SQL"},"status"],"metrics":[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sales)","optionName":"metric_tjn8bh6y44_7o4etwsqhal","sqlExpression":null}],"orderby":[[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sales)","optionName":"metric_tjn8bh6y44_7o4etwsqhal","sqlExpression":null},false]],"annotation_layers":[],"row_limit":10000,"series_columns":["status"],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"time_offsets":[],"post_processing":[{"operation":"pivot","options":{"index":["order_date"],"columns":["status"],"aggregates":{"SUM(Sales) [...]
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sales)","optionName":"metric_tjn8bh6y44_7o4etwsqhal","sqlExpression":null}],"groupby":["status"],"adhoc_filters":[{"clause":"WHERE","subject":"order_date","operator":"TEMPORAL_RANGE","comparator":"No
+ filter","expressionType":"SIMPLE"}],"row_limit":10000,"truncate_metric":true,"show_empty_columns":true,"rolling_type":null,"time_compare":null,"comparison_type":null,"annotation_layers":[],"forecastPeriods":10,"forecastInterval":0.8,"orientation":"vertical","x_axis_title_margin":15,"y_axis_title_margin":15,"y_axis_title_position":"Left","sort_series_type":"sum","color_scheme":"supersetColors","time_shift_color":true,"stack":"Stack","only_total":true,"show_legend":true,"legendType":"scr [...]
cache_timeout: null
uuid: 692aca26-a526-85db-c94c-411c91cc1077
version: 1.0.0
diff --git a/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales_By_Product_Line_113.yaml b/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales_By_Product_Line_113.yaml
new file mode 100644
index 0000000000..25957e64c7
--- /dev/null
+++ b/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales_By_Product_Line_113.yaml
@@ -0,0 +1,87 @@
+slice_name: Quarterly Sales (By Product Line)
+description: null
+certified_by: null
+certification_details: null
+viz_type: echarts_timeseries_bar
+params:
+ datasource: 21__table
+ viz_type: echarts_timeseries_bar
+ slice_id: 113
+ x_axis: order_date
+ time_grain_sqla: P3M
+ metrics:
+ - aggregate: SUM
+ column:
+ column_name: sales
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 917
+ is_dttm: false
+ optionName: _col_Sales
+ python_date_format: null
+ type: DOUBLE PRECISION
+ verbose_name: null
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ isNew: false
+ label: SUM(Sales)
+ optionName: metric_tjn8bh6y44_7o4etwsqhal
+ sqlExpression: null
+ groupby:
+ - product_line
+ adhoc_filters:
+ - expressionType: SIMPLE
+ subject: order_date
+ operator: TEMPORAL_RANGE
+ comparator: No filter
+ clause: WHERE
+ sqlExpression: null
+ isExtra: false
+ isNew: false
+ datasourceWarning: false
+ filterOptionName: filter_skx80xwzof_2l0t7nomekl
+ order_desc: true
+ row_limit: 10000
+ truncate_metric: true
+ show_empty_columns: true
+ rolling_type: null
+ time_compare: null
+ comparison_type: null
+ annotation_layers: []
+ forecastPeriods: 10
+ forecastInterval: 0.8
+ orientation: vertical
+ x_axis_title_margin: 15
+ y_axis_title_margin: 15
+ y_axis_title_position: Left
+ sort_series_type: sum
+ color_scheme: supersetColors
+ time_shift_color: true
+ only_total: true
+ show_legend: true
+ legendType: scroll
+ legendOrientation: top
+ x_axis_time_format: smart_date
+ y_axis_format: null
+ y_axis_bounds:
+ - null
+ - null
+ truncateXAxis: true
+ rich_tooltip: true
+ showTooltipTotal: true
+ tooltipTimeFormat: smart_date
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"order_date","op":"TEMPORAL_RANGE","val":"No
+ filter"}],"extras":{"time_grain_sqla":"P3M","having":"","where":""},"applied_time_extras":{},"columns":[{"timeGrain":"P3M","columnType":"BASE_AXIS","sqlExpression":"order_date","label":"order_date","expressionType":"SQL"},"product_line"],"metrics":[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sales)","optionName":"metric_tjn8bh6y44_7o4etwsqhal","sqlExpression":null}],"orderby":[[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sales)","optionName":"metric_tjn8bh6y44_7o4etwsqhal","sqlExpression":null},false]],"annotation_layers":[],"row_limit":10000,"series_columns":["product_line"],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"time_offsets":[],"post_processing":[{"operation":"pivot","options":{"index":["order_date"],"columns":["product_line"],"aggregates": [...]
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"SUM(Sales)","optionName":"metric_tjn8bh6y44_7o4etwsqhal","sqlExpression":null}],"groupby":["product_line"],"adhoc_filters":[{"expressionType":"SIMPLE","subject":"order_date","operator":"TEMPORAL_RANGE","comparator":"No
+ filter","clause":"WHERE","sqlExpression":null,"isExtra":false,"isNew":false,"datasourceWarning":false,"filterOptionName":"filter_skx80xwzof_2l0t7nomekl"}],"order_desc":true,"row_limit":10000,"truncate_metric":true,"show_empty_columns":true,"rolling_type":null,"time_compare":null,"comparison_type":null,"annotation_layers":[],"forecastPeriods":10,"forecastInterval":0.8,"orientation":"vertical","x_axis_title_margin":15,"y_axis_title_margin":15,"y_axis_title_position":"Left","sort_series_t [...]
+cache_timeout: null
+uuid: db9609e4-9b78-4a32-87a7-4d9e19d51cd8
+version: 1.0.0
+dataset_uuid: e8623bb9-5e00-f531-506a-19607f5f8005
diff --git a/superset/examples/configs/charts/Vehicle Sales/Revenue_by_Deal_Size.yaml b/superset/examples/configs/charts/Vehicle Sales/Revenue_by_Deal_Size.yaml
index 7ab51d2eff..8107fd223e 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Revenue_by_Deal_Size.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Revenue_by_Deal_Size.yaml
@@ -1,20 +1,7 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Revenue by Deal Size
+description: null
+certified_by: null
+certification_details: null
viz_type: echarts_timeseries_bar
params:
adhoc_filters: []
@@ -27,30 +14,30 @@ params:
datasource: 23__table
granularity_sqla: order_date
groupby:
- - deal_size
+ - deal_size
label_colors: {}
left_margin: auto
line_interpolation: linear
metrics:
- - aggregate: SUM
- column:
- column_name: sales
- description: null
- expression: null
- filterable: true
- groupby: true
- id: 917
- is_dttm: false
- optionName: _col_Sales
- python_date_format: null
- type: DOUBLE PRECISION
- verbose_name: null
- expressionType: SIMPLE
- hasCustomLabel: false
- isNew: false
- label: (Sales)
- optionName: metric_3is69ofceho_6d0ezok7ry6
- sqlExpression: null
+ - aggregate: SUM
+ column:
+ column_name: sales
+ description: null
+ expression: null
+ filterable: true
+ groupby: true
+ id: 917
+ is_dttm: false
+ optionName: _col_Sales
+ python_date_format: null
+ type: DOUBLE PRECISION
+ verbose_name: null
+ expressionType: SIMPLE
+ hasCustomLabel: false
+ isNew: false
+ label: (Sales)
+ optionName: metric_3is69ofceho_6d0ezok7ry6
+ sqlExpression: null
order_desc: true
queryFields:
groupby: groupby
@@ -61,15 +48,16 @@ params:
show_brush: auto
show_legend: true
time_grain_sqla: P1M
- time_range: "2003-01-01T00:00:00 : 2005-06-01T00:00:00"
+ time_range: '2003-01-01T00:00:00 : 2005-06-01T00:00:00'
url_params: {}
viz_type: echarts_timeseries_bar
x_axis_format: smart_date
x_ticks_layout: auto
y_axis_bounds:
- - null
- - null
+ - null
+ - null
y_axis_format: SMART_NUMBER
+query_context: null
cache_timeout: null
uuid: f065a533-2e13-42b9-bd19-801a21700dff
version: 1.0.0
diff --git a/superset/examples/configs/charts/Vehicle Sales/Seasonality_of_Revenue_per_Product_Line.yaml b/superset/examples/configs/charts/Vehicle Sales/Seasonality_of_Revenue_per_Product_Line.yaml
index 3ecd5704ed..0cf3b81109 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Seasonality_of_Revenue_per_Product_Line.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Seasonality_of_Revenue_per_Product_Line.yaml
@@ -1,20 +1,7 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Seasonality of Revenue (per Product Line)
+description: null
+certified_by: null
+certification_details: null
viz_type: horizon
params:
adhoc_filters: []
@@ -53,6 +40,8 @@ params:
time_range: No filter
url_params: {}
viz_type: horizon
+ annotation_layers: []
+query_context: null
cache_timeout: null
uuid: cf0da099-b3ab-4d94-ab62-cf353ac3c611
version: 1.0.0
diff --git a/superset/examples/configs/charts/Vehicle Sales/Total_Revenue.yaml b/superset/examples/configs/charts/Vehicle Sales/Total_Revenue.yaml
index 0de8c449f8..7dce186b55 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Total_Revenue.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Total_Revenue.yaml
@@ -1,26 +1,13 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
slice_name: Total Revenue
-viz_type: big_number_total
+description: null
+certified_by: null
+certification_details: null
+viz_type: big_number
params:
- adhoc_filters: []
- datasource: 23__table
- granularity_sqla: order_date
- header_font_size: 0.4
+ datasource: 21__table
+ viz_type: big_number
+ slice_id: 114
+ x_axis: order_date
metric:
aggregate: SUM
column:
@@ -41,14 +28,35 @@ params:
label: (Sales)
optionName: metric_twq59hf4ej_g70qjfmehsq
sqlExpression: null
- queryFields:
- metric: metrics
- subheader: ''
+ adhoc_filters:
+ - clause: WHERE
+ comparator: No filter
+ expressionType: SIMPLE
+ operator: TEMPORAL_RANGE
+ subject: order_date
+ show_trend_line: true
+ start_y_axis_at_zero: true
+ color_picker:
+ a: 1
+ b: 135
+ g: 122
+ r: 0
+ header_font_size: 0.4
subheader_font_size: 0.15
- time_range: No filter
- url_params: {}
- viz_type: big_number_total
- y_axis_format: $,.2f
+ y_axis_format: .3s
+ currency_format:
+ symbolPosition: prefix
+ symbol: USD
+ time_format: smart_date
+ rolling_type: cumsum
+ extra_form_data: {}
+ dashboards:
+ - 9
+query_context: '{"datasource":{"id":21,"type":"table"},"force":false,"queries":[{"filters":[{"col":"order_date","op":"TEMPORAL_RANGE","val":"No
+ filter"}],"extras":{"having":"","where":""},"applied_time_extras":{},"columns":[{"columnType":"BASE_AXIS","sqlExpression":"order_date","label":"order_date","expressionType":"SQL"}],"metrics":[{"aggregate":"SUM","column":{"column_name":"sales","description":null,"expression":null,"filterable":true,"groupby":true,"id":917,"is_dttm":false,"optionName":"_col_Sales","python_date_format":null,"type":"DOUBLE
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_twq59hf4ej_g70qjfmehsq","sqlExpression":null}],"annotation_layers":[],"series_limit":0,"order_desc":true,"url_params":{},"custom_params":{},"custom_form_data":{},"post_processing":[{"operation":"pivot","options":{"index":["order_date"],"columns":[],"aggregates":{"(Sales)":{"operator":"mean"}},"drop_missing_columns":true}},{"operation":"cum","options":{"o [...]
+ PRECISION","verbose_name":null},"expressionType":"SIMPLE","hasCustomLabel":false,"isNew":false,"label":"(Sales)","optionName":"metric_twq59hf4ej_g70qjfmehsq","sqlExpression":null},"adhoc_filters":[{"clause":"WHERE","comparator":"No
+ filter","expressionType":"SIMPLE","operator":"TEMPORAL_RANGE","subject":"order_date"}],"show_trend_line":true,"start_y_axis_at_zero":true,"color_picker":{"a":1,"b":135,"g":122,"r":0},"header_font_size":0.4,"subheader_font_size":0.15,"y_axis_format":".3s","currency_format":{"symbolPosition":"prefix","symbol":"USD"},"time_format":"smart_date","rolling_type":"cumsum","extra_form_data":{},"dashboards":[9],"force":false,"result_format":"json","result_type":"full"},"result_format":"json","re [...]
cache_timeout: null
uuid: 7b12a243-88e0-4dc5-ac33-9a840bb0ac5a
version: 1.0.0
diff --git a/superset/examples/configs/dashboards/Sales_Dashboard.yaml b/superset/examples/configs/dashboards/Sales_Dashboard.yaml
index 439b763d0c..7306c469a7 100644
--- a/superset/examples/configs/dashboards/Sales_Dashboard.yaml
+++ b/superset/examples/configs/dashboards/Sales_Dashboard.yaml
@@ -1,25 +1,9 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
dashboard_title: Sales Dashboard
description: null
-css: ""
+css: ''
slug: null
-certified_by: ""
-certification_details: ""
+certified_by: ''
+certification_details: ''
published: true
uuid: 04f79081-fb49-7bac-7f14-cc76cd2ad93b
position:
@@ -27,195 +11,195 @@ position:
children: []
id: CHART-1NOOLm5YPs
meta:
- chartId: 2805
+ chartId: 115
height: 25
- sliceName: Total Items Sold
+ sliceName: Items Sold
sliceNameOverride: Total Products Sold
uuid: c3d643cd-fd6f-4659-a5b7-59402487a8d0
width: 2
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-Tyv02UA_6W
- - COLUMN-8Rp54B6ikC
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-Tyv02UA_6W
+ - COLUMN-8Rp54B6ikC
type: CHART
CHART-AYpv8gFi_q:
children: []
id: CHART-AYpv8gFi_q
meta:
- chartId: 2810
+ chartId: 112
height: 70
sliceName: Number of Deals (for each Combination)
uuid: bd20fc69-dd51-46c1-99b5-09e37a434bf1
width: 6
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-4fthLQmdX
- - ROW-0l1WcDzW3
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-4fthLQmdX
+ - ROW-0l1WcDzW3
type: CHART
CHART-KKT9BsnUst:
children: []
id: CHART-KKT9BsnUst
meta:
- chartId: 2806
- height: 59
+ chartId: 113
+ height: 50
sliceName: Quarterly Sales (By Product Line)
sliceNameOverride: Quarterly Revenue (By Product Line)
uuid: db9609e4-9b78-4a32-87a7-4d9e19d51cd8
- width: 7
+ width: 6
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-oAtmu5grZ
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-oAtmu5grZ
type: CHART
CHART-OJ9aWDmn1q:
children: []
id: CHART-OJ9aWDmn1q
meta:
- chartId: 2808
+ chartId: 116
height: 70
sliceName: Proportion of Revenue by Product Line
sliceNameOverride: Proportion of Monthly Revenue by Product Line
uuid: 08aff161-f60c-4cb3-a225-dc9b1140d2e3
width: 6
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-4fthLQmdX
- - ROW-0l1WcDzW3
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-4fthLQmdX
+ - ROW-0l1WcDzW3
type: CHART
CHART-YFg-9wHE7s:
children: []
id: CHART-YFg-9wHE7s
meta:
- chartId: 2811
+ chartId: 119
height: 49
sliceName: Seasonality of Revenue (per Product Line)
uuid: cf0da099-b3ab-4d94-ab62-cf353ac3c611
width: 6
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-4fthLQmdX
- - ROW-E7MDSGfnm
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-4fthLQmdX
+ - ROW-E7MDSGfnm
type: CHART
CHART-_LMKI0D3tj:
children: []
id: CHART-_LMKI0D3tj
meta:
- chartId: 2809
+ chartId: 117
height: 49
sliceName: Revenue by Deal Size
sliceNameOverride: Monthly Revenue by Deal SIze
uuid: f065a533-2e13-42b9-bd19-801a21700dff
width: 6
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-4fthLQmdX
- - ROW-E7MDSGfnm
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-4fthLQmdX
+ - ROW-E7MDSGfnm
type: CHART
CHART-id4RGv80N-:
children: []
id: CHART-id4RGv80N-
meta:
- chartId: 2807
- height: 59
- sliceName: Total Items Sold (By Product Line)
- sliceNameOverride: Total Products Sold (By Product Line)
+ chartId: 111
+ height: 50
+ sliceName: Items by Product Line
+ sliceNameOverride: Products Sold By Product Line
uuid: b8b7ca30-6291-44b0-bc64-ba42e2892b86
width: 2
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-oAtmu5grZ
- - COLUMN-G6_2DvG8aK
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-oAtmu5grZ
+ - COLUMN-G6_2DvG8aK
type: CHART
CHART-j24u8ve41b:
children: []
id: CHART-j24u8ve41b
meta:
- chartId: 670
- height: 59
+ chartId: 120
+ height: 50
sliceName: Overall Sales (By Product Line)
- sliceNameOverride: Total Revenue (By Product Line)
+ sliceNameOverride: Total Revenue By Product
uuid: 09c497e0-f442-1121-c9e7-671e37750424
width: 3
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-oAtmu5grZ
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-oAtmu5grZ
type: CHART
CHART-lFanAaYKBK:
children: []
id: CHART-lFanAaYKBK
meta:
- chartId: 2804
+ chartId: 114
height: 26
sliceName: Total Revenue
uuid: 7b12a243-88e0-4dc5-ac33-9a840bb0ac5a
width: 3
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-Tyv02UA_6W
- - COLUMN-8Rp54B6ikC
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-Tyv02UA_6W
+ - COLUMN-8Rp54B6ikC
type: CHART
CHART-vomBOiI7U9:
children: []
id: CHART-vomBOiI7U9
meta:
- chartId: 668
+ chartId: 118
height: 53
sliceName: Quarterly Sales
sliceNameOverride: Quarterly Revenue
uuid: 692aca26-a526-85db-c94c-411c91cc1077
- width: 7
+ width: 6
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-Tyv02UA_6W
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-Tyv02UA_6W
type: CHART
COLUMN-8Rp54B6ikC:
children:
- - CHART-lFanAaYKBK
- - CHART-1NOOLm5YPs
+ - CHART-lFanAaYKBK
+ - CHART-1NOOLm5YPs
id: COLUMN-8Rp54B6ikC
meta:
background: BACKGROUND_TRANSPARENT
- width: 2
+ width: 3
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-Tyv02UA_6W
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-Tyv02UA_6W
type: COLUMN
COLUMN-G6_2DvG8aK:
children:
- - CHART-id4RGv80N-
+ - CHART-id4RGv80N-
id: COLUMN-G6_2DvG8aK
meta:
background: BACKGROUND_TRANSPARENT
- width: 2
+ width: 3
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-oAtmu5grZ
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-oAtmu5grZ
type: COLUMN
DASHBOARD_VERSION_KEY: v2
GRID_ID:
children: []
id: GRID_ID
parents:
- - ROOT_ID
+ - ROOT_ID
type: GRID
HEADER_ID:
id: HEADER_ID
@@ -226,10 +210,9 @@ position:
children: []
id: MARKDOWN--AtDSWnapE
meta:
- code:
- "# \U0001F697 Vehicle Sales Dashboard \U0001F3CD\n\nThis example dashboard\
- \ provides insight into the business operations of vehicle seller. The dataset\
- \ powering this dashboard can be found [here on Kaggle](https://www.kaggle.com/kyanyoga/sample-sales-data).\n\
+ code: "# \U0001F697 Vehicle Sales \U0001F3CD\n\nThis example dashboard provides\
+ \ insight into the business operations of vehicle seller. The dataset powering\
+ \ this dashboard can be found [here on Kaggle](https://www.kaggle.com/kyanyoga/sample-sales-data).\n\
\n### Timeline\n\nThe dataset contains data on all orders from the 2003 and\
\ 2004 fiscal years, and some orders from 2005.\n\n### Products Sold\n\nThis\
\ shop mainly sells the following products:\n\n- \U0001F697 Classic Cars\n\
@@ -239,113 +222,498 @@ position:
height: 53
width: 3
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
- - ROW-Tyv02UA_6W
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
+ - ROW-Tyv02UA_6W
type: MARKDOWN
ROOT_ID:
children:
- - TABS-e5Ruro0cjP
+ - TABS-e5Ruro0cjP
id: ROOT_ID
type: ROOT
ROW-0l1WcDzW3:
children:
- - CHART-OJ9aWDmn1q
- - CHART-AYpv8gFi_q
+ - CHART-OJ9aWDmn1q
+ - CHART-AYpv8gFi_q
id: ROW-0l1WcDzW3
meta:
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-4fthLQmdX
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-4fthLQmdX
type: ROW
ROW-E7MDSGfnm:
children:
- - CHART-YFg-9wHE7s
- - CHART-_LMKI0D3tj
+ - CHART-YFg-9wHE7s
+ - CHART-_LMKI0D3tj
id: ROW-E7MDSGfnm
meta:
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-4fthLQmdX
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-4fthLQmdX
type: ROW
ROW-Tyv02UA_6W:
children:
- - COLUMN-8Rp54B6ikC
- - CHART-vomBOiI7U9
- - MARKDOWN--AtDSWnapE
+ - COLUMN-8Rp54B6ikC
+ - CHART-vomBOiI7U9
+ - MARKDOWN--AtDSWnapE
id: ROW-Tyv02UA_6W
meta:
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
type: ROW
ROW-oAtmu5grZ:
children:
- - COLUMN-G6_2DvG8aK
- - CHART-KKT9BsnUst
- - CHART-j24u8ve41b
+ - COLUMN-G6_2DvG8aK
+ - CHART-KKT9BsnUst
+ - CHART-j24u8ve41b
id: ROW-oAtmu5grZ
meta:
background: BACKGROUND_TRANSPARENT
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
- - TAB-d-E0Zc1cTH
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
+ - TAB-d-E0Zc1cTH
type: ROW
TAB-4fthLQmdX:
children:
- - ROW-0l1WcDzW3
- - ROW-E7MDSGfnm
+ - ROW-0l1WcDzW3
+ - ROW-E7MDSGfnm
id: TAB-4fthLQmdX
meta:
text: "\U0001F9ED Exploratory"
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
type: TAB
TAB-d-E0Zc1cTH:
children:
- - ROW-Tyv02UA_6W
- - ROW-oAtmu5grZ
+ - ROW-Tyv02UA_6W
+ - ROW-oAtmu5grZ
id: TAB-d-E0Zc1cTH
meta:
text: "\U0001F3AF Sales Overview"
parents:
- - ROOT_ID
- - TABS-e5Ruro0cjP
+ - ROOT_ID
+ - TABS-e5Ruro0cjP
type: TAB
TABS-e5Ruro0cjP:
children:
- - TAB-d-E0Zc1cTH
- - TAB-4fthLQmdX
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
id: TABS-e5Ruro0cjP
meta: {}
parents:
- - ROOT_ID
+ - ROOT_ID
type: TABS
metadata:
timed_refresh_immune_slices: []
expanded_slices: {}
refresh_frequency: 0
- default_filters: "{}"
+ default_filters: '{}'
color_scheme: supersetColors
label_colors:
- Medium: "#1FA8C9"
- Small: "#454E7C"
- Large: "#5AC189"
- SUM(SALES): "#1FA8C9"
- Classic Cars: "#454E7C"
- Vintage Cars: "#5AC189"
- Motorcycles: "#FF7F44"
- Trucks and Buses: "#666666"
- Planes: "#E04355"
- Ships: "#FCC700"
- Trains: "#A868B7"
+ Medium: '#1FA8C9'
+ Small: '#454E7C'
+ Large: '#5AC189'
+ SUM(SALES): '#1FA8C9'
+ Classic Cars: '#454E7C'
+ Vintage Cars: '#5AC189'
+ Motorcycles: '#FF7F44'
+ Trucks and Buses: '#666666'
+ Planes: '#E04355'
+ Ships: '#FCC700'
+ Trains: '#A868B7'
+ native_filter_configuration:
+ - id: NATIVE_FILTER-HX2lV--YaAZRQfJ_yfYB2
+ controlValues:
+ enableEmptyFilter: false
+ defaultToFirstItem: false
+ multiSelect: true
+ searchAllOptions: false
+ inverseSelection: false
+ name: Country
+ filterType: filter_select
+ targets:
+ - column:
+ name: country
+ datasetUuid: e8623bb9-5e00-f531-506a-19607f5f8005
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ - id: NATIVE_FILTER-oCF7UtoHuDIBg44q5peth
+ controlValues:
+ enableEmptyFilter: false
+ name: Order Quantity
+ filterType: filter_range
+ targets:
+ - column:
+ name: quantity_ordered
+ datasetUuid: e8623bb9-5e00-f531-506a-19607f5f8005
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ - id: NATIVE_FILTER-V_UJOthxN8gCeYSD0id9b
+ controlValues:
+ enableEmptyFilter: false
+ name: Time Range
+ filterType: filter_time
+ targets:
+ - {}
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ - id: NATIVE_FILTER-t8xOh3el1KBWWiCIF5hIN
+ controlValues:
+ enableEmptyFilter: false
+ name: Time Grain
+ filterType: filter_timegrain
+ targets:
+ - datasetUuid: e8623bb9-5e00-f531-506a-19607f5f8005
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ excluded: []
+ rootPath:
+ - ROOT_ID
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ - id: NATIVE_FILTER-9tGcTjqhNxOgX2AEPLVil
+ controlValues:
+ enableEmptyFilter: false
+ defaultToFirstItem: false
+ multiSelect: true
+ searchAllOptions: false
+ inverseSelection: false
+ name: Postal Code
+ filterType: filter_select
+ targets:
+ - column:
+ name: postal_code
+ datasetUuid: e8623bb9-5e00-f531-506a-19607f5f8005
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ - id: NATIVE_FILTER-pGnu5e_bg1IGz2wdzIuCA
+ controlValues:
+ enableEmptyFilter: false
+ defaultToFirstItem: false
+ multiSelect: true
+ searchAllOptions: false
+ inverseSelection: false
+ name: State
+ filterType: filter_select
+ targets:
+ - column:
+ name: state
+ datasetUuid: e8623bb9-5e00-f531-506a-19607f5f8005
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ - id: NATIVE_FILTER-EVb_e9pndL9UByuZt0z_w
+ controlValues:
+ enableEmptyFilter: false
+ name: MSRP
+ filterType: filter_range
+ targets:
+ - column:
+ name: msrp
+ datasetUuid: e8623bb9-5e00-f531-506a-19607f5f8005
+ defaultDataMask:
+ extraFormData: {}
+ filterState: {}
+ ownState: {}
+ cascadeParentIds: []
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ type: NATIVE_FILTER
+ description: ''
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ tabsInScope:
+ - TAB-d-E0Zc1cTH
+ - TAB-4fthLQmdX
+ shared_label_colors:
+ - Classic Cars
+ - Motorcycles
+ - Planes
+ - Ships
+ - Trains
+ - Trucks and Buses
+ - Vintage Cars
+ map_label_colors:
+ Shipped: '#1FA8C9'
+ Cancelled: '#454E7C'
+ On Hold: '#5AC189'
+ Resolved: '#FF7F44'
+ In Process: '#666666'
+ Disputed: '#E04355'
+ color_scheme_domain:
+ - '#1FA8C9'
+ - '#454E7C'
+ - '#5AC189'
+ - '#FF7F44'
+ - '#666666'
+ - '#E04355'
+ - '#FCC700'
+ - '#A868B7'
+ - '#3CCCCB'
+ - '#A38F79'
+ - '#8FD3E4'
+ - '#A1A6BD'
+ - '#ACE1C4'
+ - '#FEC0A1'
+ - '#B2B2B2'
+ - '#EFA1AA'
+ - '#FDE380'
+ - '#D3B3DA'
+ - '#9EE5E5'
+ - '#D1C6BC'
+ cross_filters_enabled: true
+ chart_configuration:
+ '111':
+ id: 111
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ '113':
+ id: 113
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 111
+ - 112
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
+ '116':
+ id: 116
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 117
+ - 118
+ - 119
+ - 120
+ '117':
+ id: 117
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 118
+ - 119
+ - 120
+ '118':
+ id: 118
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 119
+ - 120
+ '120':
+ id: 120
+ crossFilters:
+ scope: global
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ global_chart_configuration:
+ scope:
+ rootPath:
+ - ROOT_ID
+ excluded: []
+ chartsInScope:
+ - 111
+ - 112
+ - 113
+ - 114
+ - 115
+ - 116
+ - 117
+ - 118
+ - 119
+ - 120
version: 1.0.0
diff --git a/superset/examples/configs/datasets/examples/cleaned_sales_data.yaml b/superset/examples/configs/datasets/examples/cleaned_sales_data.yaml
index fcf91bc1a2..8cdf5222a2 100644
--- a/superset/examples/configs/datasets/examples/cleaned_sales_data.yaml
+++ b/superset/examples/configs/datasets/examples/cleaned_sales_data.yaml
@@ -1,32 +1,19 @@
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
table_name: cleaned_sales_data
main_dttm_col: order_date
description: null
default_endpoint: null
offset: 0
cache_timeout: null
-schema: null
+catalog: null
+schema: main
sql: null
params: null
template_params: null
filter_select_enabled: true
fetch_values_predicate: null
extra: null
+normalize_columns: false
+always_filter_main_dttm: false
uuid: e8623bb9-5e00-f531-506a-19607f5f8005
metrics:
- metric_name: count
@@ -35,6 +22,7 @@ metrics:
expression: COUNT(*)
description: null
d3format: null
+ currency: null
extra: null
warning_text: null
columns:
@@ -43,251 +31,300 @@ columns:
is_dttm: true
is_active: true
type: TIMESTAMP WITHOUT TIME ZONE
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: price_each
verbose_name: null
is_dttm: false
is_active: true
type: DOUBLE PRECISION
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: sales
verbose_name: null
is_dttm: false
is_active: true
type: DOUBLE PRECISION
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: address_line1
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: address_line2
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: contact_last_name
+ extra: null
+- column_name: order_line_number
verbose_name: null
is_dttm: false
is_active: true
- type: TEXT
+ type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: contact_first_name
+ extra: null
+- column_name: quantity_ordered
verbose_name: null
is_dttm: false
is_active: true
- type: TEXT
+ type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: quantity_ordered
+ extra: null
+- column_name: order_number
verbose_name: null
is_dttm: false
is_active: true
type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: year
+ extra: null
+- column_name: quarter
verbose_name: null
is_dttm: false
is_active: true
type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: postal_code
+ extra: null
+- column_name: year
verbose_name: null
is_dttm: false
is_active: true
- type: TEXT
+ type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: customer_name
+ extra: null
+- column_name: month
verbose_name: null
is_dttm: false
is_active: true
- type: TEXT
+ type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: deal_size
+ extra: null
+- column_name: msrp
verbose_name: null
is_dttm: false
is_active: true
- type: TEXT
+ type: BIGINT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: state
+ extra: null
+- column_name: contact_last_name
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: status
+ extra: null
+- column_name: contact_first_name
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: order_line_number
+ extra: null
+- column_name: postal_code
verbose_name: null
is_dttm: false
is_active: true
- type: BIGINT
+ type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: order_number
+ extra: null
+- column_name: customer_name
verbose_name: null
is_dttm: false
is_active: true
- type: BIGINT
+ type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: month
+ extra: null
+- column_name: deal_size
verbose_name: null
is_dttm: false
is_active: true
- type: BIGINT
+ type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: quarter
+ extra: null
+- column_name: product_code
verbose_name: null
is_dttm: false
is_active: true
- type: BIGINT
+ type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: msrp
+ extra: null
+- column_name: product_line
verbose_name: null
is_dttm: false
is_active: true
- type: BIGINT
+ type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: product_code
+ extra: null
+- column_name: state
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
-- column_name: product_line
+ extra: null
+- column_name: status
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: city
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: country
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: phone
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
- column_name: territory
verbose_name: null
is_dttm: false
is_active: true
type: TEXT
+ advanced_data_type: null
groupby: true
filterable: true
expression: null
description: null
python_date_format: null
+ extra: null
version: 1.0.0
database_uuid: a2dc77af-e654-49bb-b321-40f6b559a1ee
-data: https://raw.githubusercontent.com/apache-superset/examples-data/lowercase_columns_examples/datasets/examples/sales.csv