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


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?

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

I am using InfluxQL