Fyi i have a serial number (unique order ) which have 2 codes ( 7 & 8). Each of the codes have a start and a planned end date.
Serial Number
Code
Start date
Planned End date
Current date
1
7
16-02-22
17-02-22
08-03-22
1
8
18-02-22
25-02-22
09-03-22
2
7
16-02-22
17-02-22
10-03-22
2
8
18-02-22
28-02-22
11-03-22
3
7
18-02-22
20-02-22
12-03-22
3
8
21-02-22
01-03-22
13-03-22
I need to make a graph (probably funnel ) to show the total time that needed for both codes and if is possible to read the current date and calculate current date in case codes exceeds planned end time.
