

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
class(), increment by standard deviation
want to show a chart with count of error on y, and standard deviation group of error on x
error is a field already in table, need to calculate standard deviation group on front end. I know i can do it in the back end, but i what to keep standard dev dynamic based on selected criteria.
outcome of the chart in table format:
say standard devation is 2, and mean is 20
stdev group error range
-1 18<=x<20
0 20
1 20<x<=22
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your buckets are not of equal size, which is not supported by the class function.
You can create two variables vSTD and vAVG:
=stdev(error)
=avg(error)
and then a chart with a calculated dimension
=class(error, vSTD, 'error', vAVG)
and an expression
=count(x)
to show a histogram with buckets of size of the standard deviation grouped around the mean value.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your buckets are not of equal size, which is not supported by the class function.
You can create two variables vSTD and vAVG:
=stdev(error)
=avg(error)
and then a chart with a calculated dimension
=class(error, vSTD, 'error', vAVG)
and an expression
=count(x)
to show a histogram with buckets of size of the standard deviation grouped around the mean value.
