Line plot + standard deviation

[ivo_marcelo-165]

Hi,

I would like to plot the mean of a given variable, together with a representation of variance, on a monthly basis. I can plot the mean easily using a line plot, but so far could not figure out how to represent the standard deviation in the same line plot. See an example below on the type of visualization I would like to achieve (either error bars or shaded area around the mean).

Is there a way to do this in Looker?

[brinbrin]

You want to build a time series, that will allow you to add error bars.

[idaok]

There's probably a better option but what I would do is..

Table calculation for mean,

Table calculation using mean to find upper and another to find lower... mean +/- stddev_pop({measure}).

This will give you 3 lines and perhaps it's possible to use area shading to get that going but haven't figure it out yet.