Help on plotting two series on same chart (Created vs Resolved)

[aurelie_pilette]

Hello,

I would like to plot a visualization with items created and resolved. I can easily have two visu one for created and the other one for resolved, but I cannot find a way to plot both on the same chart.

My dataset looks like this:

Sprint created	Sprint closed	Issuekey
Sprint1	Sprint3	1
Sprint1	Sprint4	2
Sprint2	Sprint4	3

And i would like to have one table on looker studio who can allow by sprint to see how many have been created ad how many have been resolved

Sprint	Created	Closed
Sprint1	2	0
Sprint2	1	0
Sprint3	0	1
Sprint4	0	2

Do you know if it is possible and if yes, how ?

Thanks

[marcwo]

Hi @aurelie_pilette

what kind of visual are you trying to build and what problems did you run into? When I use your sample data, I can easily build a grouped bar chart for example.

If you provide more information, we might be able to help you further!