Forum Discussion
Multiple tables in one bar chart
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.
2 Replies
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.
