Hi there I want to select from a table only the measurements above or below a certain percentile.. i.e. use the output of the percentile() function as the value in a normal WHERE clause.
e.g. select * from agged_data where bytes_min > percentile(bytes_min, 20) currently the above query returns nothing. no error, no results. replacing "percentile(bytesmin, 20)" with the numeric value of : select percentile(bytes_min, 20) from agged_data works as expected. are we able to use functions as values like this ? I can't see how I can make a CQ to do the same thing either. cheers -ivan -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/78aa101b-261c-44dd-a64f-7549ec95ef05%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
