How do you incorporate standard deviation within gauge object segments?
How would I use Standard deviation with the segments of the gauge object.
I will have 4 segments, low - moderate - elevated and high where elevated is 1 standard deviation above moderate and high is 2 standard deviations over moderate. I have created a few gauge charts with segments, but not sure how to handle standard deviation with it.
Assuming a field named "Value", you can compute the lower bound as:
median(Value) + stdev(Value) * 1
I suspect this is not exactly what you want, because the gauge would aggregate something like sum(Value) and therefore would always exceed the bound. Is this a gauge in a straight table and you want the median & stdev to be per row? If so, then use
