How do I create a chart in Apache Superset that contains both the raw data and a rolling average?
How do I create a chart in Apache Superset that displays both raw data (line or bar) and a rolling average (line)?
I can figure out how to do this with legacy chart options (Line Chart/ Dual Line Chart/ Multiple Line Charts) but they are labelled Legacy or Deprecated. The new option seems to be Mixed Time-Series, but it doesn't look like this supports rolling averages.
This is possible in Superset v2.0.0. Select the chart template Mixed Chart, then complete the fields on the DATA tab: Shared query fields, Query A, Advanced Analytics Query A, Query B, Advanced Analytics Query B.
On one of the Advanced Analytics sections, specify mean for the ROLLING FUNCTION and values (probably the same) for PERIODS and MIN PERIODS.
Then on the CUSTOMIZE tab, select the SERIES TYPE for A and for B. That lets you mix bars and lines.
And you should get a chart like this:
- How to write custom javascript in superset which is installed in docker?
- Is it possible to install Apache superset on a ECS container
- Getting loader image instead of chart and doesn't contain complete data
- How to create handlebars in Superset and avoid error call to Function() blocked by CSP?
- Superset Add user with REST API
- Rbac superset enable role on dashboard
- Import dashboard in Apache Superset through REST API
- Default Login for Docker Image of Superset?
- Pinotdb error (pinotdb.exceptions.DatabaseError) {'errorCode': 150... when trying to initialize apache-pinot db from apache-superset
- superset keycloak integration on https
- Apache superset failing docker compose up install method
- PL/SQL to Superset/Trino - convert hexadecimal funcion
- create a dataset in sqllab query editor with parameters in Apache Superset
- Trying to start Apache Superset, and get "services.superset-node.env_file.0 must be a string"
- Superset on Kubernetes with Helm not using custom values file
- Using Superset helm chart with pre-existing postgres database
- How to get Superset Token?? (for use Rest api)
- Problem with positioning of charts in superset dashboard
- Superset enable jinja
- How to Apply a URL Filter in a Superset Dashboard
- Error while running "docker compose pull" in Apache Superset
- Can a Superset dataset use multiple data sources?
- connect superset to postgresql in a docker container - The port is closed
- How add a new map to chart "country_map" Apache Superset
- No data about SELECT queries in Superset in ClickHouse table system.processes
- Creating a Superset user programmatically
- Add dynamic categories to pie chart in Apache Superset?
- Take average from a delimited string in a single expression
- How to skip the Superset signin page
- Get proper usernames to populate on Superset with Azure SSO instead of ID string