Eliminate meaningless decimals from binned X axis labels

[Dean DuBois 2]

I have a line chart with bins on the X axis and the X axis labels contains meaningless decimal places. I cannot find how to eliminate these meaningless decimals. Any suggestions

[Shaun Simon]

Right Click > Properties > Formatting > Select your axis and change the Category to Number (or whatever you need) and set the Decimals.

[Dean DuBois 2]

This suggestion does not work...which is why I am asking this question. Is it the fact that I am looking at a binned property that I cannot change the category

[christopher sawtelle 2]

Can you show an example of what is happening

[Dean DuBois 2]

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.

[Anders Gavare]

The first thing I would try is to change the formatting for the DPLP column (under Edit -> Column Properties -> Select the DPLP column -> Switch to the Formatting tab -> change number of decimals under the Number category to zero).

[Paul Bennett 3]

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