Unable to plot time series in Looker

Trying to plot two fields in Looker:

Month,

# of seats purchased by the customer.

Both of these are calculated in our own tables and declared as the correct data type (date / number respectively) in our LookML. 

Looker is incapable of taking these two columns and plotting a time series like you would expect. 

The date value is forced onto the y axis, and the number value is forced to be โ€˜in orderโ€™, so I canโ€™t get an accurate picture of licenses purchased over time.   Iโ€™m able to get the date onto the x axis by select โ€œSwap X and Y axisโ€, but there is NOTHING I can do to assign the date to the X axis, and there is no way to accurately plot the data.  instead Iโ€™m stuck with something like this: 

 

97cc50c2-3732-4942-a90f-baf2988b3b98.png
1 2 3,060
2 REPLIES 2
Top Labels in this Space
Top Solution Authors