Group Recipe - custom aggregation

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

Answers

  • Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭
    edited July 2024

    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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.