This is an automated email from the ASF dual-hosted git repository.
rusackas pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/superset.git
The following commit(s) were added to refs/heads/master by this push:
new 7c9c30db1d chore(examples): Touching up Vehicle Sales a bit (#32623)
7c9c30db1d is described below
commit 7c9c30db1d0c9cde6cd528f8b54d6c04b1536358
Author: Evan Rusackas <[email protected]>
AuthorDate: Fri Mar 14 09:31:02 2025 -0600
chore(examples): Touching up Vehicle Sales a bit (#32623)
---
.../configs/charts/Vehicle Sales/Items_Sold.yaml | 73 +++
.../Vehicle Sales/Items_by_Product_Line.yaml | 80 +++
.../Number_of_Deals_for_each_Combination.yaml | 9 +-
.../Overall_Sales_By_Product_Line.yaml | 9 +
.../Proportion_of_Revenue_by_Product_Line.yaml | 120 ++--
.../charts/Vehicle Sales/Quarterly_Sales.yaml | 133 +++--
.../Quarterly_Sales_By_Product_Line_113.yaml | 103 ++++
.../charts/Vehicle Sales/Revenue_by_Deal_Size.yaml | 50 +-
.../Seasonality_of_Revenue_per_Product_Line.yaml | 5 +
.../charts/Vehicle Sales/Total_Revenue.yaml | 48 +-
.../configs/dashboards/Sales_Dashboard.yaml | 650 ++++++++++++++++-----
.../datasets/examples/cleaned_sales_data.yaml | 106 +++-
12 files changed, 1083 insertions(+), 303 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..dfe68196d3
--- /dev/null
+++ b/superset/examples/configs/charts/Vehicle Sales/Items_Sold.yaml
@@ -0,0 +1,73 @@
+# 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: 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..9e13c5d952
--- /dev/null
+++ b/superset/examples/configs/charts/Vehicle Sales/Items_by_Product_Line.yaml
@@ -0,0 +1,80 @@
+# 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: 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..379b353cb7 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
@@ -15,6 +15,9 @@
# 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 +45,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..097805a17e 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
@@ -15,6 +15,9 @@
# 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 +64,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..56b9ab3326 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
@@ -15,60 +15,84 @@
# 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..f1169141c4 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Quarterly_Sales.yaml
@@ -15,71 +15,86 @@
# 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..46049fc1c0
--- /dev/null
+++ b/superset/examples/configs/charts/Vehicle
Sales/Quarterly_Sales_By_Product_Line_113.yaml
@@ -0,0 +1,103 @@
+# 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 (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..0f08edd3c8 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
@@ -15,6 +15,9 @@
# 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 +30,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 +64,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..5b91dd1c58 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
@@ -15,6 +15,9 @@
# 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 +56,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..073e396ca9 100644
--- a/superset/examples/configs/charts/Vehicle Sales/Total_Revenue.yaml
+++ b/superset/examples/configs/charts/Vehicle Sales/Total_Revenue.yaml
@@ -15,12 +15,15 @@
# 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 +44,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..6af9bdde6e 100644
--- a/superset/examples/configs/dashboards/Sales_Dashboard.yaml
+++ b/superset/examples/configs/dashboards/Sales_Dashboard.yaml
@@ -16,10 +16,10 @@
# 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 +27,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 +226,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 +238,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..d2136a9034 100644
--- a/superset/examples/configs/datasets/examples/cleaned_sales_data.yaml
+++ b/superset/examples/configs/datasets/examples/cleaned_sales_data.yaml
@@ -20,6 +20,7 @@ description: null
default_endpoint: null
offset: 0
cache_timeout: null
+catalog: null
schema: null
sql: null
params: null
@@ -27,6 +28,8 @@ 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 +38,7 @@ metrics:
expression: COUNT(*)
description: null
d3format: null
+ currency: null
extra: null
warning_text: null
columns:
@@ -43,251 +47,301 @@ 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
