Group Recipe - custom aggregation

Options
Data123
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

Answers

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭
    Options

    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)<BR />

    Hope this helps!

Setup Info
    Tags
      Help me…