Hi @daylightfinisher - I thin kin this case you need to get both date fields into the same column in order to plot them on the same X-axis. Best way to do this is to UNION the table with itself, and in the process align the date fields into the same field, and introduce a new field that describes which date type that row belongs to (can be used as a filter later for other use case). Would be conceptually like this:
Select
field 1 as field 1,
field 2 as field 2,
order date as date,
"order date" as datetype
from table
UNION ALL
Select
field 1 as field 1,
field 2 as field 2,
delivery date as date,
"delivery date" as datetype
from table
Then you put that single date field on your x-axis. For the two values, I didnt quite follow the ‘positive/negative’ part of it - you may need some calculated fields like:
ifelse(datetype='delivery date', value*-1, value)
Which would make any rows for deliveries a negative value.