Numeric data on x axis multiline trend

#1

Hello,

I want to show Multi line trend with numeric data on both x and y axis. By Default x axis datatype is String and it shows multiline trend. However I am interested to sort x-axis data in descending order of x-axis value. It is not doing so I tried to make Type of X-axis item as Numeric however by doing this whole multi line chart became blank. What is the way to sort x axis string data (which is actually numbers) by descending order of value?
Appreciate your help.

#2

Hi Prashant,

If the chart became blank after changing the axis scale type to Numeric, the data it was displaying is not yet numeric.

  • If it was displaying the wrong data, you can choose which data to plot along each axis in the Data Analysis Panel by clicking Visualization, then changing which data is added under Horizontal Axis for each series.
  • If the data displayed along the X axis should be numeric, its data type may have been string (text) in the original data source. If this data is an Excel file or another file type, you can change the data type in the data connector, otherwise a data cube can convert text values to numeric if needed.
1 Like