Hi Team,
I would like to make a query to return the results where the value in “quantity consumed” is less than 50% of “theoretical quantity”, and count them then using a count aggregation.
I couldn’t find a way to define a filter with an expression. Is there any workaround I can use for this use case ?
Much appreciated!
Safouane