Jump to content

X-axis values do not exist in the data table

Francisco Aspillaga
Go to solution Solved by Fredrik Rosell,

Recommended Posts

  • Solution

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)



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).


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."

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...