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?
