This works. thank you :) will put this across and share it. this is my first step to the dashboard world, so many more help required. I am already enjoying this.
basically, there are two parts to this
a) want to depict how many orders came in V/s orders closed at that given hour..then allign that with the headcount present to work on the orders at that given hour.
This will help me know the optimum headcount allinged to work towards orders
b) also...
have 5 elements ( Time ; Order-in; Order-out; Headcount to hadle order; Region(5 regions)). what would be best way to show this in a dashboard.
Sample data is as:
Time Order-in(count) Order-out(count) Headcount Region
3am-4am 100 90 3...