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:
That part is good and was easy.
I want to draw a chart that has the following features:
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.