Looker Community

Two line series on one graph?

This shouldn’t be a hard one, but I’m not able to figure it out as a new Looker user.

I have an SQL query to pull the following data:

|Date|Company|Share Price|

That part is good and was easy.

I want to draw a chart that has the following features:
x-axis: date
y-axis: share price
two series line graphs, one for each of the companies that I’m tracking.

Theoretically, I should be able to Pivot on name, but I can’t figure out how to get the share price value into those company columns.

Can you show us what happens when you do what you say you do? If share price is a measure then there should be nothing stopping you from achieving that kind of time series.

Following up on this: Looker restricts visualizations based on custom SQL.