Hello!

I’m trying to figure out how to get CubeJS to send over standard error or standard deviation for a measure. What’s the best way to go about doing this?

I can do this:

```
measures: {
standardDeviation: {
sql: `stddev_samp(value)`,
type: `number`,
},
}
```

But I can’t use it with filters (which are important to my use-case):

```
measures: {
standardDeviation: {
filters: [{ sql: `${MeasureComponent}."measureId" = 1` }],
sql: `stddev_samp(value)`,
type: `number`,
},
}
```

(postgres generates the error `Error: column "measure_component.measureId" must appear in the GROUP BY clause or be used in an aggregate function`

)

Is there another way to do this? My apologies if there is an obvious sql solution here I’m not seeing (but I can’t do the normal sql trick of joining on a subquery, nor did I find a way to get windowing to work).