Replies: 1 comment
|
select
channel,
approx_quantile(total_sales, 0.25) as first_quartile,
approx_quantile(total_sales, 0.50) as median,
approx_quantile(total_sales, 0.75) as third_quartile,
case
when channel ilike '%Google%' then '#923d59'
when channel ilike '%Facebook%' then '#488f96'
else '#495867'
end as color
from daily_sales
group by 1Then
|
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
I see the example for Box Plot with colors but the color key just contains a column name called
colorwithout a definition ofcolor. I have used theseriesColoroption in a Bar chart succesfully but it doesn't seem to work here. Can anyone help?All reactions