perspective icon indicating copy to clipboard operation
perspective copied to clipboard

Filtering on aggregated results (similar to SQL HAVING clause)

Open homam opened this issue 1 year ago • 0 comments

Feature Request

Description of Problem:

Is there a way to filter on the aggregated results? For example after breaking down by Category and Sub-Category, I want to only display rows that have more than N Sales.

This is equivalent to this SQL:

SELECT "Category", "Sub-Category", SUM("Sales")
FROM T
GROUP BY "Category", "Sub-Category"
HAVING SUM("Sales") > N
### Tasks

homam avatar Jul 19 '24 09:07 homam