You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "JustineAssoulant (via GitHub)" <gi...@apache.org> on 2025/10/27 10:26:10 UTC
[I] Add avg on barchart with annotation or layers [superset]
JustineAssoulant opened a new issue, #35856:
URL: https://github.com/apache/superset/issues/35856
Hello,
I have a bar chart, and I would like to add a dashed or dotted line representing the average of my data. Can I use annotation layers to do that?
<img width="1095" height="498" alt="Image" src="https://github.com/user-attachments/assets/24f4e040-ede4-4733-8b48-0b7caab94800" />
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #35856:
URL: https://github.com/apache/superset/issues/35856#issuecomment-3450604342
<!-- Answer -->
Superset doesn't currently support dynamic annotation layers that automatically update with aggregate metrics like the average. The formula annotation for a horizontal line requires a constant value, so it won't update as your data changes.
A common workaround is to calculate the average in your SQL query or dataset and add it as a separate metric or series in your chart. This way, the average will update automatically as your data changes. You can then style this series as a line (if the chart type supports it) or use it for reference.
If you need the visual effect of a dashed or dotted average line and your chart type doesn't support adding a second series, you'll need to manually update the annotation value whenever your data changes. There isn't a built-in way to link the annotation layer to a dynamic aggregate from the chart data at this time [citation](https://github.com/apache/superset/blob/master/superset-frontend/src/explore/constants.ts).
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/021f09a6-f708-4bbc-915f-52bcddfd7d00?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu
b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35856)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #35856:
URL: https://github.com/apache/superset/issues/35856#issuecomment-3450575331
<!-- Answer -->
Yes, you can add a dashed or dotted average line to a bar chart in Superset using a formula annotation layer. First, manually calculate the average value of your data. Then, in the chart's "Annotations and Layers" section, add a formula annotation with `y=YOUR_AVERAGE_VALUE`. You can style the line as dashed or dotted in the annotation settings. Superset does not automatically calculate the average for you, so you need to enter the value yourself. Only horizontal (y=constant) lines are supported for bar charts, and formula annotations are the recommended method for this use case. Note that annotation values may appear in tooltips, and only formula annotations are reliably imported/exported in recent versions [citation](https://github.com/apache/superset/issues/31735) [citation](https://github.com/apache/superset/issues/32722) [citation](https://github.com/apache/superset/discussions/35153).
<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*
---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/30061ad3-fce5-42b6-a0c6-b89916be4ccf?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu
b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/35856)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #35856:
URL: https://github.com/apache/superset/issues/35856#issuecomment-3462733643
You can also do a Mixed Chart where one is the Bar and one is a Line with the average.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #35856:
URL: https://github.com/apache/superset/issues/35856#issuecomment-4721615019
Assuming resolved, since this has been silent... closing for now, but happy to revisit.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #35856:
URL: https://github.com/apache/superset/issues/35856#issuecomment-3462735004
Let me know if that resolves it, otherwise we may convert this to Q&A if you need help with the chart, or Ideas if you want to add a feature.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "JustineAssoulant (via GitHub)" <gi...@apache.org>.
JustineAssoulant commented on issue #35856:
URL: https://github.com/apache/superset/issues/35856#issuecomment-3450598984
The average will change so i cannot use a constant value
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Add avg on barchart with annotation or layers [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #35856: Add avg on barchart with annotation or layers
URL: https://github.com/apache/superset/issues/35856
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org