Unable to plot time series in Looker

Trying to plot two fields in Looker:


# 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: 



0 replies

Be the first to reply!