Hi

I have some Graphs that I would like to display without the notations, since it creates a bit too much text detail on the graph. Is there a way to remove notations (M, K, B, etc.) from numbers in Apptio, except by making a new metric that simply does the calculation "X/1000000" in NumberFormat("#,###.0")? Because if I just add the "@M" to make millions, the "M" will still be there.

Can anyone help?

/Jesper

Hi Jesper

You should be able to add a new column and specify the format of it.

It will look like below in a table

Result in graph

In this graph, I've hidden X and Y axes and included data in the graph.

Hi Jesper

Thanks for the reply.

I have used the same solution in a table, but I do not know how to add a column to a chart, so I cannot apply the solution there.

BR Jesper

Hi Jesper,

Select the existing chart , and in the report tab, you can select "Table", which would convert the chart to tabular format, and then you can add the new formula column, and once you've done that, you could convert it back to a chart format.

Regards

Varghese

Thanks, Varghese.

I can see that it works for regular graphs. I am, however, looking at an overlay. Is it possible to do that with an overlay as well? I don't seem to be able to find it.

//Jesper

Hi Jesper, 

For the Overlay chart, this is what I did:

I selected the Base layer, and then right clicked on the chart to view chart properties, in that this is what I did:

Let me know if this what you were looking for.

Varghese

I am looking for a way to remove the "M" from the numbers. I still don't see that effect. My numberformat was #,###.0{@M} already.

Copying in @Oliver Smith - he's a report whiz

Thanks Jenny

@Jesper L�rkedal If you just pop ###,### it will return 250,000 500,000 etc. Is that what you wanted?

Thanks for the response, Oliver.

I'm sorry for not being more clear. What I would like is simply to remove the "M". So it would be the same as dividing by 1.000.000. I.e. instead of "10.5M", it should say "10.5".

//Jesper

Ah ok I understand now. I don't think it's possible  As Varghese said, the {@M} shortens it to 10.5M, but I don't think you can add anything to the number format to remove that M. 

I think that you'd have to do a metric as you originally thought, to divide the number by a million.

Ok. Thank you very much.

So I got confirmation of my own initial thought. I had hoped there was a solution that didn't require changing source data. I think it could be nice to have this function, so the "M" doesn't show on all data points. It should be clear from either a header or the axis.

//Jesper

You can always create a new calculated metric, where you define the format you'd like and then use it in an overlay graph.