redash icon indicating copy to clipboard operation
redash copied to clipboard

Event annotations (deploys, downtimes, etc) as horizontal bars on graphs

Open arikfr opened this issue 12 years ago • 16 comments

arikfr avatar Oct 28 '13 14:10 arikfr

Event annotations can be generalized to "X Axis Annotations", for any X axis data type (dates, numbers, categories, whatever). While we're at it, Y axis annotations can be useful as well. Would be useful to visualize "red lines" clearly (values too high or too low).

eshel avatar Apr 24 '14 14:04 eshel

+1

dovahcrow avatar Aug 03 '16 01:08 dovahcrow

+1 Google Analytics integrates this really well and might be worth using as inspiration.

When there is an anomaly on a chart, everyone on our team ends up having to look up the cause and then usually forget and have to look up a few more times in the future.

Stats are most useful when explanations are accompanied.

Implementation ideas:

  • Perhaps allow to add to 1 chart or to all.
  • Or allow to enable annotation on a per chart basis.
  • Allowing to group events into categories could be useful too (e.g. tags, categories or keywords). This could avoid having too many annotations if you are part of a big org (e.g. Mozilla).

davismtl avatar Nov 21 '16 21:11 davismtl

+1 be able to drop a pin on a point of a chart and add a note or a url for commentary

mohitrao avatar Dec 06 '16 21:12 mohitrao

+1

JMbw avatar Sep 19 '17 19:09 JMbw

+1

benmiroglio avatar Feb 12 '18 18:02 benmiroglio

+1

armandoFanbot avatar Aug 27 '18 22:08 armandoFanbot

In terms of what this would look like, we have two good sources of inspiration. Mozilla uses Google Analytics and Amplitude which both have annotations.

Comparison

  • Google Analytics puts them under the chart as a list sorted by date in a collapsible menu
  • Amplitude puts vertical bars on the charts to show that there is an annotation for that date

davismtl avatar Sep 17 '18 16:09 davismtl

+1

thoechsmann avatar Sep 26 '18 13:09 thoechsmann

Some notes from discussing this feature during a team call:

  • The idea is that annotation are a comment anchored to some point in the chart (at the call we discussed X axis anchoring, but reviewing comments from issue, I see that Y axis anchoring definitely makes sense too).
  • Annotation are a form of comment that is anchored to some point in the visualization. They will be persisted forever, and if not visible from the chart (because the point is no longer in view) then they can be seen from the "comments" section.
  • As a follow up feature, we can implement unanchored comments, but should start from annotations.

arikfr avatar Jan 28 '19 13:01 arikfr

Supporting of 'Multiple Annotations' would be great for adding deployments and system changes markers to the graphs: https://plot.ly/python/text-and-annotations/#multiple-annotations

dlevison avatar Jun 04 '19 13:06 dlevison

Is there any work planned for this?

ribtoks avatar Jan 15 '23 14:01 ribtoks

Wondering the same here. Are there any plans to support annotations?

mavericohm avatar Jan 27 '23 02:01 mavericohm

I also would like event annotations.

When added please support area annotations along with the single line annotation.

The way I see it working with Redash is having an expected format for an 'event query' which would add the lines or areas to the graph.

fields expected:

date (x value) start date (x value) end (optional) color (maybe add opacity % too) text

jamiegs avatar Apr 15 '25 17:04 jamiegs

How is this feature still not there??

M-Elsaeed avatar Oct 10 '25 17:10 M-Elsaeed

As a workaround, may we use Scatter Chart with Data Label as the annotation ?

yoshiokatsuneo avatar Oct 11 '25 00:10 yoshiokatsuneo