jaeW_at_Onyx Coach 
-
Re: COUNT(DISTINCT *) desconsidering only one filter
you cannot do a count distinct across all your cities even with a window function. the window function would calculate count distinct for EACH city, and then take the average, min or max as you've tr…1 -
Re: Is there a way to nest beast modes in another beast mode without exposing the full calculation
@MarkSnodgrass is correct there is no referential way to refer to pre-defined beast modes. @JustinB you generally should not nest aggregations inside a CASE statement. case when (sum(`Clicks`) / sum(…1 -
Re: Datacenter Autotags: Manual vs Scheduled, Append vs Replace
Being able to add tags based on dataset attributes that are accessible via DG datasets would aid in automating governance activities1 -
Re: Formula not summarizing in analyzer
@JustinB by building your aggregation INSIDE the CASE statement you're applying the CASE statement after aggregation. (i know that sounds like i said the same thing twice... point being, what you're …1 -
Re: Possible to filter on one dataset based on the results of another dataset in a page?
@user018766 "if I include a user details for every activity, the dataset will be too large" how do you know that statement is true? by too large do you mean "too many columns" or …1
