Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
i have a list of order dates, structured as below:
Order No | Reference Date | Creation Date | Closing Date |
1 | 01/01/2021 | 01/01/2021 | 02/01/2021 |
2 | 02/01/2021 | 02/01/2021 | 02/01/2021 |
3 | 02/01/2021 | 02/01/2021 | 03/01/2021 |
4 | 02/01/2021 | 02/01/2021 | 05/01/2021 |
5 | 03/01/2021 | 03/01/2021 | 05/01/2021 |
6 | 03/01/2021 | 03/01/2021 | 05/01/2021 |
7 | 04/01/2021 | 04/01/2021 | 06/01/2021 |
8 | 05/01/2021 | 05/01/2021 | 06/01/2021 |
9 | 06/01/2021 | 06/01/2021 | 06/01/2021 |
10 | 06/01/2021 | 06/01/2021 | 06/01/2021 |
Now i need to create a line chart where i have [Reference Date] on X-axis and count the orders created and closed on that [Reference Date] on Y-axis.
In order to obtain something like this:
I would like to create this chart without adding script during load.
Can someone help me?
You can find these data in the attached file.
Thanks in advice
DateTable:
LOAD * Inline [
Order No, Reference Date, Creation Date, Closing Date
1, 01/01/2021, 01/01/2021, 02/01/2021
2, 02/01/2021, 02/01/2021, 02/01/2021
3, 02/01/2021, 02/01/2021, 03/01/2021
4, 02/01/2021, 02/01/2021, 05/01/2021
5, 03/01/2021, 03/01/2021, 05/01/2021
6, 03/01/2021, 03/01/2021, 05/01/2021
7, 04/01/2021, 04/01/2021, 06/01/2021
8, 05/01/2021, 05/01/2021, 06/01/2021
9, 06/01/2021, 06/01/2021, 06/01/2021
10 ,06/01/2021, 06/01/2021, 06/01/2021
];
Load "Creation Date" as "Reference Date",
'Created' as TypeDate Resident DateTable;
Load "Closing Date" as "Reference Date",
'Closed' as TypeDate Resident DateTable;
Now create a line chart as follow :
Result :
Dear @OmarBenSalem ,
thanks for your solution but, as i wrote in my post, i'm looking for a solution without adding script.