You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm currently using the following for simple counts over the entire aggregated set.
.FIELD(xql.RAW('count(*) OVER() AS full_count'))
But for more complicated use cases, would be nice not to do this using the RAW method. Here is an example:
.FIELD(
COUNT(
CASE().WHEN(
AND(...thisPeriodCriteria),
COL(`sometable.id`),
),
)
.DISTINCT()
.OVER() <- would be nice if support for this would be added
.AS('full_count'),
)
The text was updated successfully, but these errors were encountered:
Thanks again for this great library!
I'm currently using the following for simple counts over the entire aggregated set.
.FIELD(xql.RAW('count(*) OVER() AS full_count'))
But for more complicated use cases, would be nice not to do this using the RAW method. Here is an example:
The text was updated successfully, but these errors were encountered: