add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
@sql := group_concat(distinct
'sum(case when event_type = ''',
event_type, ''' then number else 0 end)/sum(number) as `ratio_',
event_type, '`'
)
sum(case when event_type = 'exampleG1' then number else 0 end)/sum(number) as `ratio_exampleG1`,sum(case when event_type = 'exampleG2' then number else 0 end)/sum(number) as `ratio_exampleG2`,sum(case when event_type = 'exampleG3' then number else 0 end)/sum(number) as `ratio_exampleG3`
@sql
select date(created_at) date_bucket, sum(case when event_type = 'exampleG1' then number else 0 end)/sum(number) as `ratio_exampleG1`,sum(case when event_type = 'exampleG2' then number else 0 end)/sum(number) as `ratio_exampleG2`,sum(case when event_type = 'exampleG3' then number else 0 end)/sum(number) as `ratio_exampleG3` from example_table group by date(created_at) order by date_bucket
date_bucket ratio_exampleG1 ratio_exampleG2 ratio_exampleG3
2020-06-02 0.1429 0.2857 0.5714
2020-06-03 1.0000 0.0000 0.0000