Support Candlestick charts for histograms

[chrbayer84]

Histograms diagrams are supported by graphite but there is no nice way to display the key data in one chart. The only way to display this right now is by only using the point diagram type. A better way to display things like min/max, median and mean and stddev in one chart, see https://en.wikipedia.org/wiki/Candlestick_chart.

[torkelo]

Hope to add more advanced chart display options after summer when I have will work full time on grafana

[raulk]

+1

[gjgreen]

Any word on new chard types? I'm also interested in candlestick charts.

[Dieterbe]

this looks pretty neat, though i don't understand what it has to do with histograms.
note that if you get your series summarized by day, you basically can plot the same information, just styled a bit differently (through points/lines/areas whatever)

[raulk]

@Dieterbe yeah, I don't think they're related to histograms. OHLC Candlestick charts are widely used in financial markets. Supporting them in Grafana opens up yet a new use case.

[nhorlock]

For the example given (min max median) box plus are better, more generalised to statistics and more obvious in terms of the data series.
Candle stick charts tend to always refer to financial terms open close low and high and tend to relate as a serious.

+1 for box plots in one form or other

[netixen]

+1 for candle stick charts.
They might come from financial markets, but once you learn to read them you can use them for any time series data. Quite useful. I would replace charts where I plot first, last and median with OHLC in an instant.

[jachinte]

👍 I agree with @netixen, we use them for performance comparisons.

[digrich]

+1

[bltb]

There appears to be a flot candlestick plugin available. http://www.flotcharts.org/plugins/ I wonder how hard it would be to integrate... hmm...

[mobula9]

+1

[zfsamzfsam]

+1

[darinarrick]

+1. I'd love to be able to write a datasource to interface with a financial exchange and to create graphs in Grafana to show OHLC candlestick graphs.

[magick93]

+1

[timgaunt]

I'd like to see candlesticks -we use a lot of "time to process" data so it would be good to have a "Min" / "Max" view over time

[minhdanh]

+1

[cabrinha]

+1

[tuxmonteiro]

+1

[phemmer]

Guys, github has a reactions feature: https://github.com/blog/2119-add-reactions-to-pull-requests-issues-and-comments. There are potentially numerous people subscribed to the issue, and "+1" comments are just spam.
If you want to receive future updates, you can do so without commenting by clicking the "subscribe" button on the right.

[dddda212]

+1

[adiospeds]

any update on candle charts?

[bdonnahue]

I'm confused. @ilgizar Is this still a standalone feature or included in the main build and just not in the documentation? Is it stable?

[ilgizar]

@bdonnahue I closed my PR, and designed this as separate plugin. https://github.com/ilgizar/ilgizar-candlestick-panel Is it beta version, but workful.

[yati-sagade]

I think the groundwork needed for this this will also allow for adding confidence interval bands to line charts. Are there plans to absorb the linked plugin into the project?

[tux-00]

Any news ?

[iavael]

@yati-sagade Candlestick charts may be not quite suitable for showing confidence interval bands. The latter one has probabilistic nature and represents estimated error because of incompleteness of data while the true value is uncertain.
Candlestick bars on the other side are used to represent distribution of true vaules during each interval, so they don't have probabilistic nature.

[emmtte]

+1

[andyceo]

Any updates? Very useful and long-awaited feature!

[tux-00]

Maybe we can hope to have this feature with this work ? -> #21835

[leeoniya]

we just merged the alpha Market Trend panel in #40909. it currently expects the datasource / query to do the necessary windowing/aggregation into (OHLC/V), but we'll be adding raw price data aggregation in the frontend via a candlestick transform, or panel setting, or data format auto-detection (still TBD).

for those who have stuck around long enough to see this land, feedback / testing is very welcome :)

there is a related request for box/whisker plots [1], which is a close relative and will likely happen in the next few months.

[1] #3227

[m-o-e]

Looks fantastic, thanks! 🙏

Two feature requests that spring to mind:

• Min/max indicators in chart (yellow arrows)
• Current value in axis (blue arrow)

It's more space- and eyeball-efficient than the legend, esp.
when there's a grid of many charts on one page.

[rbjorklin]

Just tested this and it works very well, great work! 👍

I have two questions:

• How did you pull your bars together? (see the weekend gaps in my screenshot)
• When using Graph styles > Fill below to I'm unable to pick (base field name), is this intentional?

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last year. It will be closed in 30 days if no further activity occurs. Please feel free to leave a comment if you believe the issue is still relevant. Thank you for your contributions!