Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Filtering on aggregated results (similar to SQL HAVING clause) #2685

Open
homam opened this issue Jul 19, 2024 · 0 comments
Open

Filtering on aggregated results (similar to SQL HAVING clause) #2685

homam opened this issue Jul 19, 2024 · 0 comments
Labels
enhancement Feature requests or improvements

Comments

@homam
Copy link

homam commented Jul 19, 2024

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

Preview Give feedback
No tasks being tracked yet.
@timkpaine timkpaine added the enhancement Feature requests or improvements label Aug 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Feature requests or improvements
Projects
None yet
Development

No branches or pull requests

2 participants