Improve count aggregations #263
atomobianco
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
If I'm not mistaken, the following capabilities are missing, and I think would be quite useful:
count
aggregation on any type of column, be it numeric or string: sometimes I need to check if columns have empty cells, without applying filterscount
for unique values, as well on any type of column; maybe instead of creating a new operator, we could changeuniq
, which is currently used to give the eventual value of a column filled with the same valuecase when min(${subExpStr})=max(${subExpStr}) then min(${subExpStr}) else null end
This could become
count(DISTINCT "col_name") as "col_name"
; if there's only one value in the column you'll see the aggregation giving the value 1, and you can infer that any value displayed is the one repeated (aka the value given by currentuniq
operation)What is your take on this?
Beta Was this translation helpful? Give feedback.
All reactions