[druid-user] Filter on metrics

  • Is there a way to filter on metrics. I have a metric with a value range 0<test_metric<100
  • If it is not possible, is it possible to make this metric to dimension?

Elaborating further…
I have metrics by the name “plr”, the values of which are between 0 and 100 with granularity in second. We have aggregated metrics too over a minute and above.
I have to fetch the data with plr >= x, where x is {1,10,50,70,90,100}.

If I fetch all the data between the date range, I get only 10K rows and so was wondering if there is a way I can filter based on a condition on metrics.
Appreciate the response if anyone has come across this type of issue and how they have solved it…