Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm trying to generate a table or bar graph that shows the backlog (Total Bookings - Total Shipments) based on the Ship Date.
This is how my table is structured:
Project | Date Project Created | Date Actual Ship |
GT-00373 | 11/24/09 | 5/14/10 |
GT-00374 | 11/24/09 | 6/02/10 |
GT-00375 | 11/24/09 | 6/08/10 |
GT-00128 | 3/25/09 | 2/13/12 |
GT-00728 | 7/03/11 | 8/04/12 |
GT-00129 | 3/25/09 | 3/14/13 |
This is approximately how I want the visual to look:
5/14/10 | 4 |
6/02/10 | 3 |
6/08/10 | 2 |
2/13/12 | 2 |
8/04/12 | 1 |
3/14/13 | 0 |
Any suggestions?
Better If you could explain logic behind to get numbers?