What workaround can I use when computing standard deviation for a table which might have only one row

1

Hi,

I want to calculate standard deviation for different type of requests, but in some cases I might have a single row for a specific request type this causing a null value to be returned for standard deviation. Is there a workaround to replace this null value with 0?

2

Hello @ciprian,
Are you using InfluxQL or Flux?
If you’re using Flux you can use conditional logic in your query.

3

Hi,
I am using InfluxQL