looker visualization treating all data as one line?

[bzwooyoung555]

i have three columns, but because of the nature of the data - looker seems to get two things wrong

1) it treats all three columns as one line - they are all calculation tables

sub note: if i remove the calculation tables, it still treats all the columns as one line anyways

2) it also mixes up the x & y axis when the date should be the x axis and the values should be the y axis

any proposed solutions to fix this?

My inputted SQL table is structured something like this:

Date, Calculation, Calculation

2023-06	62	14
2023-05	141	15
2023-04	33	9

Note: my months are a dimension-group time, and the rest are dimension numbers.

(also - does anyone know if it's possible to put two tables in looker visualization - so i could access one other table to perform additional calculations)