journey_rollup_detail - blindrhythm.public

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

outcome_class

text

2147483647

√

null

outcome

text

2147483647

√

null

runs

int8

19

√

null

avg_steps

numeric

0

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT
        CASE
            WHEN (outcome = ANY (ARRAY['COMPLETED_TO_PAYMENT'::text, 'COMPLETED_TO_CHECKOUT'::text, 'EXPLORED_NO_BARRIER'::text])) THEN 'SUCCESS'::text
            WHEN (outcome = ANY (ARRAY['BARRIER_CONFIRMED'::text, 'BARRIER_SUSPECTED'::text])) THEN 'SITE_BARRIER'::text
            ELSE 'AGENT_FAILURE'::text
        END AS outcome_class,
    outcome,
    count(*) AS runs,
    round(avg(steps_taken), 1) AS avg_steps
   FROM journey_run
  GROUP BY
        CASE
            WHEN (outcome = ANY (ARRAY['COMPLETED_TO_PAYMENT'::text, 'COMPLETED_TO_CHECKOUT'::text, 'EXPLORED_NO_BARRIER'::text])) THEN 'SUCCESS'::text
            WHEN (outcome = ANY (ARRAY['BARRIER_CONFIRMED'::text, 'BARRIER_SUSPECTED'::text])) THEN 'SITE_BARRIER'::text
            ELSE 'AGENT_FAILURE'::text
        END, outcome
  ORDER BY
        CASE
            WHEN (outcome = ANY (ARRAY['COMPLETED_TO_PAYMENT'::text, 'COMPLETED_TO_CHECKOUT'::text, 'EXPLORED_NO_BARRIER'::text])) THEN 'SUCCESS'::text
            WHEN (outcome = ANY (ARRAY['BARRIER_CONFIRMED'::text, 'BARRIER_SUSPECTED'::text])) THEN 'SITE_BARRIER'::text
            ELSE 'AGENT_FAILURE'::text
        END, (count(*)) DESC;

Possibly Referenced Tables/Views

journey_run