Francisco Aspillaga Posted March 3, 2023 Share Posted March 3, 2023 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. Link to comment Share on other sites More sharing options...
Solution Fredrik Rosell Posted March 3, 2023 Solution Share Posted March 3, 2023 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 categoricalExplanation 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)"ContinuousSelect 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).CategoricalSelect 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 More sharing options...
Francisco Aspillaga Posted March 3, 2023 Author Share Posted March 3, 2023 Excellent. Thank you very much for your explanation and help!. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now