I have a set of historic order data going back for several years. Simply structured like so:
<tbody>
</tbody>
What I would like is to show is how many active (aka undelivered) orders a customer had on any given date. I would like to represent that as a trend over time. This is for a large range of customers, over a high number of orders, for a long time period.
So on 01/01/2018, how many active (undelivered) orders did Customer A have.
Then on 02/02/2018, how many active (undelivered) orders did Customer A have.
I am really scratching my head to figure out the best way to show this for a range of customers, over a long time period.
Can any one offer suggestions on this one?
Thanks in advance
A | B | C | D |
Order number | Customer | Order Date | Delivery Date |
12345 | Customer A | 20/12/2017 | 06/01/2018 |
54321 | Customer B | 01/01/2018 | 10/01/2018 |
<tbody>
</tbody>
What I would like is to show is how many active (aka undelivered) orders a customer had on any given date. I would like to represent that as a trend over time. This is for a large range of customers, over a high number of orders, for a long time period.
So on 01/01/2018, how many active (undelivered) orders did Customer A have.
Then on 02/02/2018, how many active (undelivered) orders did Customer A have.
I am really scratching my head to figure out the best way to show this for a range of customers, over a long time period.
Can any one offer suggestions on this one?
Thanks in advance
Last edited: