Static Data

[dbtornell]

I have two sets of data that I want to show on the same graph with the x-axis being the time (year, quarter, month, day etc.).  The data represents lists of orders.  I want to have on bar for order type X and one bar for order type Y.  The goal is to compare the number of order types against one another to see how many orders are missing.  I am able to show accurate data for order type X given the time I select, wether thats year, quarter, month, day etc., but I can't get order type Y to show up accurately.  Order type Y is represented as the total quantity no matter how I switch the x-axis; so I  get down to the day level order type X will be shown as something like "7" and order type Y will be shown as "16000", and these are both on the same day.  Does anyone know how I can fix this problem so both order types display accurate data given the time specification?

[jthomson]

Use a date table as your axis and then relate your data sets to it

[dbtornell]

What do you mean?