Multiple tables in one bar chart

[Steg]

Hi there, I have a question. 

I am trying to create a bar chart which shore incoming cases and outgoing cases. for value I use 'count of casenumber' the axis shows the country (in this case: the Islands). 

There are two charts: amount of incoming cases (based on the table: date of registry) and amount of outgoing cases (based on the table: date of closing). 

What I would like to do is to combine the two charts in one, so I can present the amount of incoming cases and outgoing cases by island (x-axis) and a slicer per year. 

It probably is a very simple solution, but so far, I haven't solved it. Please help.

If you need more information, please let me know. 

[az38]

Hi @Steg 

In the most common case you just need to create relationships between tables by a common field (for example, date fields in your scenario)

[Steg]

Dear @az38 ,

the two date (incoming cases and outgoing cases are in the same table. e.g.

Casenumber	Incoming date	outgoing date
CUR201701200	4-5-2017	7-5-2017
CUR201701201	8-5-2017	12-8-2018
CUR201800047	8-8-2018	9-12-2018

My goal is to show in one bar chart the total of incoming cases en outgoing cases per year.