Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!

–1 vote
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
by
Could you post what you've currently done to define the custom aggregation?
Hi, Have you been able to solve your issue?

1 Answer

0 votes

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 END

Give 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!

by
1,337 questions
1,362 answers
1,556 comments
11,912 users

©Dataiku 2012-2018 - Privacy Policy