Quick question and one I feel as though I've just forgotten the answer to.... How do I get this KPI to have a comma in it like the secondary one does?

Thanks in advance!

Hey Molly,

I'm not 100% sure this is it (because all of mine seem to just have a comma) but I have a feeling it could be because your Active Project column is a label in your data rather than a number, so Apptio doesn't know you'd like a comma there as it doesn't realise it's a number.

Let me know if changing it to Number works (or if it's already a number) and I'll try to think of something else

Oli

Hi Oli, 

Thanks for your reply!  Active Project Count is already set as a number so I'm not sure what the cause of it would be   Let me know if you think of anything else!

Thanks!

Is it a metric rather than a column in a data set? If so, could you send a screenshot of the metric properties and I'll see if anything in there looks different to something I have?

Thanks

Molly,

I believe that may be the metric for project counts, if you add the #,### to the Chart Format this may fix and add the comma.

Thanks,

Ryan

Ryan,

Do I need to recalculate Dev once I do that?  Because adding "#,###" into the metric didn't work right away even with just refreshing.

Thanks,
Molly

Typically, you would not need to any recalculation in order to see.  But seeing that @Douglas Mahan has already gotten what I would have suggested next I would try that.

Just taking a stab at this because I haven't been in report land for a minute - that is my partner in crime, Andre (@Andre Harmon).  But I think if you click on the KPI menu, you can change the format.  Emphasis on "I think".  See below pic. It's under the Shorthand button.

Whoops - I didn't see Ryan's reply first - definitely go with his suggestion.

Hi Jenny,

Actually looked there to start, but that just puts a "K" for thousands, "M" for millions, etc. instead of simply adding the comma to what already exists.

Thanks for your help though!

Molly

Molly,

This specific KPI you are looking at, is it for an Out of the Box report or a Custom Report?  If it is an Out of the Box report I would check out a few areas on why the comma is not appearing:

Out of the Box:

1) Check whatever you have aligned with Active Project is a Numeric column and not a Label

2) Check the metric to ensure that it is set to Numeric and not a Label

3) If both of these are set correctly, can you right click on the KPI and click Show Full Datapath and post that here?  I will be able to see a little more on what is going on with that.

Custom Report:

If the report is Custom then you want to look at the following steps:

1) Check whatever you have aligned with Active Project is a Numeric column and not a Label

2) Check the metric to ensure that it is set to Numeric and not a Label

3) Create a new column in a new ad hoc config window can pull in whatever is backing Active Projects data and verifying that it has the commas. 

      If it does, then lock that new column to a perspective and switch out the KPI

      If it does not, then edit the column to be a Format: Number, Type: Numeric, and Summable.  Once this is done then lock that new column to a perspective and switch out the KPI

Please let me know if this helps or if you have any other questions.  I will keep an eye out for the full datapath screenshot if it is still not working.  

Thank you,

Doug Mahan

Hi Doug,

This report was OOTB, but we copied it to edit a few things in the table on the report.  Here is the full data path.  Hopefully this helps you.  If this isn't necessary and I should be following the steps as if we did a customization, let me know.  Thanks!

Molly,

You are going to have to follow my second sets of steps.  It looks like this KPI is coming directly from your data IE: Projects Master data.Active Projects Count.  You will need to make a perspective and switch out the KPI to get the comma in. 

Let me know if you are able to follow those steps.

Thank you,

Doug Mahan

HI Molly,

I ran into this exact problem and Doug's second set of steps fixed it! I ran into another issue though when adding the KPI back where it would not actually show a number at all unless I added an element of that ,master dataset I.E project name to the filters of the KPI. This made the KPI register where it needed to be pulled from exactly and then populated. I had to publish this as well to tie it to the projects object!!

Hope you make it work!

Lauren,

I glad that I was on the right track, and thank for the additional insight.  I ran into the "having to pull and correct element into the report" for the KPI as well.  We just need to make sure that we do this step to allow Apptio to know where to look for the data.

Thanks,

Doug Mahan

Thanks, Lauren!

Hoping to be able to find some time to try this later on today.  I'll let you all know if it works out!  Thanks!

Had this issue before, after you take the steps everyone already noted sometimes it helps to just force a re-calc in Dev to see if it's a cached display issue. Click the calculate Now and head to lunch would be my advice. I'v also (rarely) seen this resolve itself when promoted to a pre-calculated environment.

Joe, that is a good tip.  I agree that sometimes Apptio gets hung up and the reset will clear up the issue.  I have seen this work before and it is a good double check when trying to troubleshoot an issue.

Agreed   Made this a while back, but now cant find it, but it's in my cube lol... 

That is great.  I have not seen that sign in forever.

*** i wish i had this in my cube back in my Apptio days...