Ploting different dates in the X axes

[VictorBoscaro]

I'm working in a dataset that has the information of second instance processes of a goverment agency. Each processes has two attributes that are dates, corresponding to the day that they were distributed and the day that they were judged. 

I want to make a plot that on the X axis shows the month, and the Y axis will have two bars, one with the count of process that were distributed in that month and the other the number of process that were judged that month.

Any help on how can I solve this?

[QFabian]

Hi @VictorBoscaro , please try this script,  and see if it is good for you :

A:
LOAD * INLINE [
ProcessID, DistributedDate, JudgedDate
1, 29-08-2020, 02-12-2020
2, 24-04-2020, 10-07-2020
3, 05-02-2020, 16-02-2020
4, 20-08-2020, 22-11-2020
5, 24-08-2020, 28-11-2020
6, 15-01-2020, 14-02-2020
7, 12-03-2020, 09-05-2020
8, 26-08-2020, 05-10-2020
9, 19-06-2020, 15-07-2020
10, 10-03-2020, 06-04-2020
11, 02-08-2020, 12-08-2020
12, 07-05-2020, 18-06-2020
13, 10-02-2020, 12-02-2020
14, 22-05-2020, 11-06-2020
15, 09-08-2020, 30-09-2020
16, 07-08-2020, 23-10-2020
17, 23-06-2020, 05-08-2020
18, 21-01-2020, 22-01-2020
19, 17-07-2020, 01-08-2020
20, 07-01-2020, 21-02-2020
21, 04-07-2020, 20-09-2020
22, 24-08-2020, 25-10-2020
];

B:
Load
'Distributed' as Type,
monthname(DistributedDate) as Period,
count(ProcessID) as NumberOfProcess
Resident A
group By monthname(DistributedDate);

Load
'Judged' as Type,
monthname(JudgedDate) as Period,
count(ProcessID) as NumberOfProcess
Resident A
group by monthname(JudgedDate);

then you can create the chart as expecgted :

you can see the atached file too.

[QFabian]

here is the screenshot from qlik sense, the previous chart was made in qlikview, but the script is the same!