Forum Discussion
How do I plot a line chart
jm9999999 , In the line visual put the numeric value in y-axis and time value in x-axis[The text].
This will sort the x axis on the basis of the text string. Now in the table section, click on the day/time column[text column], this will open column tools on the menu above. Go to sort column by and sort it by index column.
For ex., in this the city names[Text] are sorted on the basis of city ID[numeric]. The sort column by option is visible by clicking on the city button in table pane.
I've tried this,
I am unable to prevent it from sorting my data points unless I put the index first and sort by index. If I do that it doesn't display the day time on the chart. Double clicking on the current sort by option doesn't disable the sorting.
I need the graph in index order but I want the x -axis to display the day time column in index order.
jm9999999 , In the line visual put the numeric value in y-axis and time value in x-axis[The text].
This will sort the x axis on the basis of the text string. Now in the table section, click on the day/time column[text column], this will open column tools on the menu above. Go to sort column by and sort it by index column.
For ex., in this the city names[Text] are sorted on the basis of city ID[numeric]. The sort column by option is visible by clicking on the city button in table pane.
Thank you so much, I have been tearing my hair out over getting this graph right!