Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Group Recipe - custom aggregation
Added on October 12, 2018 8:01PM
Likes: 0
Replies: 1
Data123
Registered Posts: 4 ✭✭✭✭
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 ?
Thank you
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 ?
Thank you
Answers
-
Hi 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!
