Prevent applying filters in some of the charts
In Edit Dashboard , there is Filter Option :
In the filter option it is possible to select the filters to apply in each of the charts.
Days Interval Grouping in Bar Charts
In the customize tab you have an option to sort based on the series.
However you have to have the intervals sorted. In my example you can see that I add 1-<30 days, 2-30-60 days, etc.
I am not sure how you did the interval section. In my example :
1- I took your data and loaded in a table
CREATE TABLE sales_test ( customer VARCHAR(10) ,ammount NUMERIC(9, 2) ,sales_date DATETIME );
2- I created a view at the top of the table to calculate the interval with Sysdate() so it is updated
CREATE VIEW sales_test_interval AS SELECT * ,datediff('day', sales_date, sysdate()) AS sales_interval FROM sales_test;
3- I use Calculated fields in superset to put the interval in 'buckets'
CASE WHEN sales_interval <= 30 THEN '1- < 30 Days' WHEN sales_interval BETWEEN 31 AND 60 THEN '2- 30-60 days' WHEN sales_interval BETWEEN 61 AND 180 THEN '3- 60-180 days' WHEN sales_interval > 180 THEN '4-More 180 Days' END
How to avoid aggregation in the Database and do it in Superset
A query fails because the aggregation granularity is not supported by the driver. This issue should be reported so it is resolved but as workaround it is possible to avoid the aggregation in the database and use Superset to do the aggregation as the example provided
Create chart with 2 or more data sets
Superset supports 2 or more dataset in a chart only in the line charts and works as a combination of charts.
A- Create a line charts
Chart 1: Confirmed_test Chart
Chart 2 : Death_Test Charts
Chart 3 : recovered_test charts
B- Create a chart that combine the 3 charts ( 3 charts can come from different data sources )
1- Select a data source
2- Select Dual or Multiple Chart Line Charts
3- Select charts to present in X and Y axis
In this Chart it is not possible to see the query or Run in SQL Lab
Change the default limit of rows in charts
You can change the default limit in charts by just overwritting the values and select "Create New Value "