Filter queries using expressions

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!

Hey Safouane, at the moment you could do that adding an additional column to your table where you would store: Quantity Consumed / Theoretical Quantity * 100. You can then base your query to filter this new column (<50%).
Please let me know if this solution works for you.

1 Like