Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add an option to display stddev as a % around the mean #409

Closed
kettch opened this issue May 14, 2014 · 6 comments
Closed

Add an option to display stddev as a % around the mean #409

kettch opened this issue May 14, 2014 · 6 comments

Comments

@kettch
Copy link

kettch commented May 14, 2014

It would be great to be able to display the standard deviation as a range around the mean (that is a bar, or band, around the curve of the mean), rather than an absolute value.
It is much more readable to be able to see the mean and the range as a whole, and the evolution in time, instead of two values without any relation.

@torkelo
Copy link
Member

torkelo commented May 15, 2014

Could you describe in a little more detail what you mean? Do you want stddev in the graph? It would only be a straight line. Or do you want a moving stddev or based on a graphite function?

@kettch
Copy link
Author

kettch commented May 15, 2014

It's indeed pretty tricky to explain...

In addition to the 'mean' function in queries, there's also 'stddev'. Both will coalesce some data points in the DB into one point in the graph, applying the function. The problem is the way they are displayed in the graph.
Here's an example, quickly drawn in Excel, with the stddev expressed in %:
screen shot 2014-05-15 at 13 35 56

In terms of readability, this is really not the best that can be done. The stddev is relative to the mean, so it doesn't mean much by itself.

Some more readable ways would be to:

  • display a line for the mean, and trace, on each point, a bar showing the min and max of the deviation around it (half above, half below)
  • display a line for the mean, and a band (with inside color or not) around the curve for the mean. This is pretty similar to what's done with Bollinger Bands in financial graphs. (example below)
    screen shot 2014-05-15 at 13 37 17

That way, you have a line showing you the mean, since it is the main information on the graph, then a curve or bars around that curve to show how it deviates, with the absolute evolution over time.

@eliperelman
Copy link

Being able to plot the standard deviation of an entire graph as a fill with an upper and lower bound would help find mean points that are outliers of the standard deviation. +1 to some variation of the above.

@torkelo
Copy link
Member

torkelo commented Apr 17, 2015

needs to implemented in time series store (in query), before aggregation

@fsaf11
Copy link

fsaf11 commented Feb 15, 2017

Please, how to do it?

@yanivmo
Copy link

yanivmo commented Jul 19, 2017

It is possible to graph deviations around a metric using the "fill below" display option. See #940 for more details.

kminehart added a commit that referenced this issue Jul 15, 2022
* Fix XSS in runbook URL (#383)

* "Release: Updated versions in package to 8.3.8" (#385)

* Fix: Choose Lookup params per auth module v8.3.x (#401)

* Fix: Choose Lookup params per auth module

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: Prefer pointer to struct in lookup

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: user email for ldap

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: Use only login for lookup in LDAP

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: use user email for ldap

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

fix remaining test

fix nit picks

* update lock

* fix integration tests

* [v8.3.x] Merge 'release-8.3.9` branch (#404)

* Fix: Choose Lookup params per auth module

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: Prefer pointer to struct in lookup

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: user email for ldap

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: Use only login for lookup in LDAP

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

Fix: use user email for ldap

Co-authored-by: Karl Persson <kalle.persson@grafana.com>

fix remaining test

fix nit picks

(cherry picked from commit 09ca54d4665583b5648fea5726a19e0b58df4ec0)

* fix integration tests

(cherry picked from commit 16c3077bb39f41acacbef4b13c65c7c907c54de7)

* Release: Bump version to 8.3.9 (#403)

* Change bump-version.yml

* "Release: Updated versions in package to 8.3.9"

Co-authored-by: dsotirakis <dimitrios.sotirakis@grafana.com>

* Update yarn.lock

Co-authored-by: jguer <joao.guerreiro@grafana.com>
Co-authored-by: Grot (@grafanabot) <43478413+grafanabot@users.noreply.github.com>

* "Release: Updated versions in package to 8.3.10" (#409)

* Update grabpl

* update grabpl

* CI: Update `grabpl` version - remove `--no-pull-enterprise` flag (#47013)

* Update grabpl version

* Sign drone

* Remove --no-pull-enterprise flag

* Sign drone

* Update grabpl

* update drone, cherry-pick some ci updates

* update PR pipeline

Co-authored-by: George Robinson <george.robinson@grafana.com>
Co-authored-by: Grot (@grafanabot) <43478413+grafanabot@users.noreply.github.com>
Co-authored-by: Jguer <joao.guerreiro@grafana.com>
Co-authored-by: Dimitris Sotirakis <dimitrios.sotirakis@grafana.com>
Co-authored-by: Kevin Minehart <kmineh0151@gmail.com>
Co-authored-by: Dimitris Sotirakis <sotirakis.dim@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants