I have these bars with the query within the picture.
I want to stack the bars, grouped by area but stack on each other volume from one week and volume from other week, sales from one week and sales from other week but I get this:
Is there a way to accomplish this? Table below:
Please provide your sample data as csv as follows
id,report_date,area,team,volumne
3,2022-04-18,area1,B,26
or basic DDL and DML
create table areas(id nt, report_date datetime,
area varchar(50), team, char(1), volume int)
insert into areas
values(3,'2022-04-18','area1','B',26)
This will help us help you. Hard to work with an image data
Hi yosiasz, unfortunately I cannot attach a CSV file to my post. Here is the data:
[‘id’, ‘report_date’, ‘area’, ‘team’, ‘volume’, ‘sales’]
[‘1’, ‘2022-04-17 19:00:00’, ‘area1’, ‘A’, ‘33’, ‘69’]
[‘2’, ‘2022-04-17 19:00:00’, ‘area1’, ‘A’, ‘3’, ‘45’]
[‘3’, ‘2022-04-17 19:00:00’, ‘area1’, ‘B’, ‘26’, ‘74’]
[‘4’, ‘2022-04-17 19:00:00’, ‘area1’, ‘B’, ‘44’, ‘59’]
[‘5’, ‘2022-04-17 19:00:00’, ‘area1’, ‘B’, ‘90’, ‘94’]
[‘6’, ‘2022-04-17 19:00:00’, ‘area1’, ‘C’, ‘123’, ‘88’]
[‘7’, ‘2022-04-17 19:00:00’, ‘area1’, ‘C’, ‘12’, ‘4’]
[‘8’, ‘2022-04-17 19:00:00’, ‘area2’, ‘A’, ‘134’, ‘77’]
[‘9’, ‘2022-04-17 19:00:00’, ‘area2’, ‘A’, ‘2’, ‘91’]
[‘10’, ‘2022-04-17 19:00:00’, ‘area2’, ‘B’, ‘252’, ‘93’]
[‘11’, ‘2022-04-17 19:00:00’, ‘area2’, ‘C’, ‘67’, ‘22’]
[‘12’, ‘2022-04-17 19:00:00’, ‘area2’, ‘C’, ‘65’, ‘68’]
[‘13’, ‘2022-04-24 19:00:00’, ‘area1’, ‘A’, ‘77’, ‘88’]
[‘14’, ‘2022-04-24 19:00:00’, ‘area1’, ‘A’, ‘33’, ‘26’]
[‘15’, ‘2022-04-24 19:00:00’, ‘area1’, ‘B’, ‘87’, ‘8’]
[‘16’, ‘2022-04-24 19:00:00’, ‘area1’, ‘B’, ‘3’, ‘67’]
[‘17’, ‘2022-04-24 19:00:00’, ‘area1’, ‘C’, ‘8’, ‘89’]
[‘18’, ‘2022-04-24 19:00:00’, ‘area1’, ‘C’, ‘57’, ‘41’]
[‘19’, ‘2022-04-24 19:00:00’, ‘area2’, ‘A’, ‘65’, ‘19’]
[‘20’, ‘2022-04-24 19:00:00’, ‘area2’, ‘A’, ‘41’, ‘12’]
[‘21’, ‘2022-04-24 19:00:00’, ‘area2’, ‘B’, ‘87’, ‘46’]
[‘22’, ‘2022-04-24 19:00:00’, ‘area2’, ‘C’, ‘55’, ‘90’]
table creation
CREATE TABLE test (
id serial primary key
report_date timestamp not null
area varchar not null
team varchar not null
volume int not null
sales int not null)
That is close, I would have liked area1 volume and sales to be grouped with each other as well
could you sketch it up in paint and post back ?
I think the closest you can with that is by adding
order by area
Also the 0 are overlapped on top of those stacked charts, could it be a bug?
No, I used paint to create the picture I would like, thank you for your help. I don’t think I will be able to get it exactly how I would like.