Using Dataiku
Sort by:
1 - 7 of
7
- Hi, Using the Group recipe I can select most aggregations, but not the median. Is it not possible to calculate the median using Group?
Last answer by a_bouffardMight try the Window recipe trick indicated here https://community.dataiku.com/t5/Using-Dataiku-DSS/Calculating-Median/m-p/7529/highlight/true#M4069
- Hi, I have a customers list and page URL - i want to create a custom group by recipe where it counts the number of times a customer hit certain pages i.e. where pageurl like '%order%' Having issues cr…
Last answer by LievHi Data123,
There could be two ways of solving this.
1) Add a computed column (SQL) before the aggregations happen. This would look something like
CASE WHEN pageurl like '%order%' THEN 1 ELSE 0 ENDGive this column a name, then use the aggregation functions in the next section to use SUM
2) Use custom aggregates wrapping the computed column and aggregate in one go:
SUM(CASE WHEN pageurl like '%order%' THEN 1 ELSE 0 END)Hope this helps!
1 - 7 of
71