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: