Jump to content

Eliminate meaningless decimals from binned X axis labels

Dean DuBois 2

Recommended Posts

This is the chart. X axis labels look ridiculous with 2 decimal places. Despite Spotfires incredible technical abilities, it's graphics (default fonts and consisitent use of unneeded decimals that requires reformatting is very annoying. Their default color selections are also pretty poor.
Link to comment
Share on other sites

  • 3 weeks later...
  • 3 years later...

Wrap your binned expression in thefollowing manner

substitute("your current expression", ".00","")

Since the data type is 'string', all the above does is to replace all instances of ".00" (i.e. the decimal) with "" (i.e. nothing) thus removing the decimals


Note - check the sort order once you have done this, it may need tweaking. I've found that the lowest value is often dispayed after the largest value which is easily fixed with the sort order found under the column properties

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