How can I create grouped bars that are also stacked visualization?

Michal_L — Thu, 08 Dec 2022 14:01:51 GMT

I wish to create a visualization combined of grouped bars, and also have those bars stacked.

Attached is a sketch of the final result I am interested in.

I am also attaching my sql because I'm not sure if I should "group by" in the query or in the visualization parameters.

select SUM(case when partition_date= '2022-11-16' then 1 else 0 end) as uploads_2022_11_16,
SUM(case when partition_date= '2022-11-17' then 1 else 0 end) as uploads_2022_11_17,
SUM(case when partition_date= '2022-11-18' then 1 else 0 end) as uploads_2022_11_18,
sourceType, entryApplication
from ovp_raw.entry_lifecycle
where partition_date > '2022-11-15'
group by sourceType, entryApplication

now it is just all stacked

Re: How can I create grouped bars that are also stacked visualization?

Aviral-Bhardwaj — Tue, 20 Dec 2022 14:19:00 GMT

try to use asc or dsc keyword ,maybe it worked

topic Re: How can I create grouped bars that are also stacked visualization? in Data Engineering

How can I create grouped bars that are also stacked visualization?

Re: How can I create grouped bars that are also stacked visualization?