I am having issue plotting line chart with the x axis and y axis from the columns I want.
I am having a explore with two table (A and B) left joint together based on ‘as-of-date’ and ‘CBSA’ columns.
I created a few derived columns with the following steps:
‘Median Value’ created based on median of a column in table A group by ‘as-of-date’
‘Index A’ is created as a table calculation column based on top of ‘Median Value’
‘Index B’ is created from a table calculation column based on a column ‘Hpi’ from table B
the visualization table looks like:
Now I want to plot line graph with ‘as-of-date’ as x-axis and compare two lines: Index A vs. Index B.
however the line chart looks like this now:
I am thinking what should I do to achieve something like:
Could you please help me with it?