-
Group recipe aggregating median
Hi, Using the Group recipe I can select most aggregations, but not the median. Is it not possible to calculate the median using Group?
-
Group Recipe - custom aggregation
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 creating this in the custom column and it seems to also be counting blank/empty values Is anyone able to potentially advise ?…
-
Grouping dataset by concatenating text column with separator
Hello friends, I'm trying to group the dataset as shown below, but I'm not getting it. I think it's possible to use a custom key, but I don't know which SQL Expression to use. Has anyone ever had to do something like this? Input: order | product | value 100 | product A | 10.00 100 | product B | 5.00 Output: order |…
-
Custom Aggregations for the Group recipe with DSS engine
Is it possible to use the "Custom aggregations" tab in the Group recipe when using the DSS recipe engine or does the engine need to be "in-database" for that tab to be useful? I've tried using it but I cannot reference columns in the input dataset (which is a file). Thanks and I am using Data Science Studio 4.0.7.
-
Custom aggregations examples
Hello, Could you provide some examples of custom aggregations involving an array or a map? Thank you
-
Add aggregations to a column
If I have data like this: A 1 B 2 A 2 B 3 I want to create a third column that would produce either sum, min, max, avg over first column. Example for max: A 1 2 B 2 3 A 2 2 B 3 3 How can I do it in DSS?
-
There seems to be no currency field type. So when grouping rows with $ the Sum operator isn't avail