X-axis values do not exist in the data table

[Francisco Aspillaga]

Hi,

Why when graphing the two variables in the table, values appear on the X axis that do not exist in the table (eg: 33200, 33300, 33400, 33500,....33900)?

 

Thanks for your help.

[Fredrik Rosell]

Hello Francisco,

Just to confirm, do you mean the axis scale labels displayed the bottom of the visualization? Those labels are equally distributed, using what appears to be a continuous axis scale for a numeric column.  

Some aspects to consider:

* Your "Text" column seems to contain integers (in a few categories) and would likely be imported as such by default, but if you don't want this to be treated as numbers, but rather as strings/categories, you could either

* Import as string from the start

* Change after import in the Data in analysis fly-out > click on the column > Settings (the cogwheel) > Data type.

* For a specific plot, you can right-click in the plot > Properties > X-Axis > Settings > Set the Axis Mode to categorical

Explanation from the manual (https://docs.tibco.com/pub/sfire-analyst/12.2.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=vis%2Fvis_details_on_advanced_settings.htm)

"

Continuous

Select this option for numerical columns when you want the values to be treated as continuous, numerical values.

This option is not available for properties that are always categorical (like string columns).

Categorical

Select this option when you want the values to be seen as categories rather than numerical values.

For example, if you have the years 2001, 2002 and 2003 in a column, you would probably like to treat the different values as categories rather than numbers."

[Francisco Aspillaga]

Excellent. Thank you very much for your explanation and help!.