Line chart that sums count of values by date.

[jellyjoe]

Hey,

I'm having an issue creating a line chart that shows the progress of achieving certain statuses. First however let me explain the situation.

I have two tables, the first table called ,,Planned" shows when a machine i supposed to achieve certain status

MC No.	Planned	Arrival	Unpacking
1	Planned	03.11.2020	03.11.2020
4	Planned	03.11.2020	03.11.2020
5	Planned	03.11.2020	03.11.2020
7	Planned	03.11.2020	03.11.2020
8	Planned	03.11.2020	04.11.2020
9	Planned	03.11.2020	04.11.2020
10	Planned	03.11.2020	04.11.2020
11	Planned	04.11.2020	04.11.2020
14	Planned	04.11.2020	04.11.2020
12	Planned	04.11.2020	05.11.2020
15	Planned	04.11.2020	05.11.2020
16	Planned	04.11.2020	05.11.2020
17	Planned	04.11.2020	05.11.2020
13	Planned	04.11.2020	06.11.2020
18	Planned	04.11.2020	06.11.2020
19	Planned	05.11.2020	06.11.2020
6	Planned	05.11.2020	06.11.2020
20	Planned	06.11.2020	06.11.2020
21	Planned	06.11.2020	07.11.2020
3	Planned	06.11.2020	07.11.2020
2	Planned	07.11.2020	07.11.2020

So for example, on 03.11.2020 machines 1,4,5,7,8,9,10 are supposed to achieve status ,,Arrival", and machines 1,4,5,7 are supposed to achieve status ,,unpacking"

Second table is the ,,actual' table which shows what statuses were achieved and when. If a record is blank then that means this status havent been achieved by the machine yet

MC No.	Planned	Arrival	Unpacking
1	Actual	03.11.2020	04.11.2020
4	Actual		04.11.2020
5	Actual	03.11.2020	04.11.2020
7	Actual	03.11.2020	04.11.2020
8	Actual	03.11.2020
9	Actual	03.11.2020
10	Actual	03.11.2020
11	Actual		05.11.2020
14	Actual	04.11.2020	05.11.2020
12	Actual	04.11.2020	05.11.2020
15	Actual	04.11.2020	05.11.2020
16	Actual
17	Actual	04.11.2020	05.11.2020
13	Actual	04.11.2020	05.11.2020
18	Actual
19	Actual	05.11.2020	06.11.2020
6	Actual	05.11.2020	06.11.2020
20	Actual	06.11.2020	06.11.2020
21	Actual
3	Actual		07.11.2020
2	Actual	07.11.2020	07.11.2020

My goal is to make a line chart which would show two lines

a) A line of how many statuses have actually been achieved by a date (not for each day, a sum of how many were achieved by that day)

b) Same line, but showing the plans

Each status would have a separate line chart.

For example, the ,,Arrival" chart would look something like this: 

Would really appreciate some help in how i can achieve that.

Thanks in advance

[jellyjoe]

Works like a charm, thank you very much!

[amitchandak · Accepted solution]

@jellyjoe , Not very clear. But someting like this calculate(sum(Table[MC No]), filter(Allselected(Table), Table[Arrival] <= max(Table[Arrival]) && Table[Planned] =max(Table[Planned])))

and actual/planned as measure or legend