Apptio for All

Apptio for All

 View Only
  • 1.  How to shorten the Chart values in Pie Chart Apptio BI?

    Posted Mon August 19, 2024 05:12 AM

    Example: I need to show the value as 298k instead of 298,226


    #ApptioforAll


  • 2.  RE: How to shorten the Chart values in Pie Chart Apptio BI?

    Posted Mon August 19, 2024 10:42 AM

    Heya!  


    I'm not sure of that type of setting, but I've shared the question with some of the experts and I'll hopefully have an answer for you soon.

    Thanks!

    Justin



    ------------------------------
    Justin Kean
    Apptio
    Sr Instructor
    ------------------------------



  • 3.  RE: How to shorten the Chart values in Pie Chart Apptio BI?

    Posted Mon August 19, 2024 11:01 AM

    I talked to some folks on this. I am told that its not possible to shorten metrics on pie charts but you could configure the decimal precision to 0. 

    Thank you,

    Bob




  • 4.  RE: How to shorten the Chart values in Pie Chart Apptio BI?

    Posted Mon August 19, 2024 11:08 AM
    Edited by James Funk Tue November 05, 2024 06:33 PM

    You should be able to do this using the NumberFormat function in the Chart Properties.  Right click the chart and select Properties.  Under Chart Number Format, enter =NumberFormat($_,"#.#{@A}").  This should give you the shorthand notation you're looking for.

    The {@A} will give you all shorthand notations and the shorthand will be dependent on the number itself, i.e. if the number is in thousands, it will give you a K; if it's millions, it uses M, etc.  If you want it to always show in thousands for example (i.e. 2.5M should show as 2,500K instead), then you'd use {@K} for thousands, {@M} for millions, {@B} for billions, and {@T} for trillions.

    Edit... oh, I see this is an Apptio BI question... sorry!  My reply was for Studio!