I need to create a bar line graph (2 y-axis) that is sourced from two data tables. I'm not sure of the best way relate them by a KeyField yet, so currently the KeyField is just store.
The application will require one input for date and one for store and only one date and store can be selected at a time.
Fields for Sales QVD include:
Sales, Date, Store, Start time, End time (time in hour of the day increments)
There may not be sales for every hour during any given day; not all stores are open 24 hrs
Fields for Labor QVD include:
EE Name, Date, Store, Start (timestamp), End (timestamp)
Questions:
How can I show sales by hour as a bar and number of employees working throughout the day?
How to always show a full day (24 hours) even if the store did not record sales from 12AM day 1 to 12 AM day 2.
My QVW attached has two charts. The bar line chart on the left is the chart in question. The Gantt chart (horizontal stacked) on the right is separate. It's a reference as to how many employees were in the store throughout the day.
Any help, suggestions and/or comments will be greatly appreciated. Thanks for your time.
