IBM Apptio

IBM Apptio

A place for Apptio product users to learn, connect, share and grow together.

 View Only
  • 1.  KPI comparison

    Posted Tue January 26, 2016 03:08 PM

    I have added some KPI widgets to a report. I am comparing plan versus actual headcount. however, I want the KPI to show the actual difference as a numeral, not as a percentage. Apptio is showing this:

     

    But instead of the 0% Over (which just looks weird) I want it to show "4 Over". Not a percentage difference, but rather the simple difference.





    #CostingStandard(CT-Foundation)


  • 2.  Re: KPI comparison
    Best Answer

    Posted Thu January 28, 2016 03:23 PM

    The KPI component is actually just a specific HTML/CSS combination, so one option is to use an HTML report component to mimic a KPI:

    KPI_HTML.PNG

     

    The above KPI for instance was created via: (top) Ribbon > Insert > HTML.

     

    Here's the HTML I used:

    <ul class="kpi-bar-horizontal" style="-moz-border-radius: 6px;-webkit-border-radius: 6px;-khtml-border-radius: 6px;border-radius: 6px;background-color:white;border: 1px solid gray;padding:0px;margin:0px;width:99%">

        <li style="padding-left:5px;padding-right:5px;">

            <span class="kpi-bar-text1">

                Internal Headcount

            </span>

            <div class="kpi-bar-value">

                <span style="color:black">

                    <%=NumberFormat(Labor Master Data.Labor Headcount,"###,###")%>

                    <%=If(Labor Actual to Plan < 0, "<span class=""kpi-bar-pct-positive"">"&Abs(Labor Actual to Plan)&" Under", "<span class=""kpi-bar-pct-negative"">"&Labor Actual to Plan&" Over")%>

                </span>

            </div>

            <span style="font-size: 90%">

                <font color="#808080">

                    Planned Internal Headcount: <%=NumberFormat(Planned Headcount,"###,###")%>

                </font>

            </span>

        </li>

    </ul>

     

    I also added a new metric (within the Metrics tab):

    Labor Actual to Plan = Labor Master Data.Labor Headcount - Planned Headcount

    ...which the HTML code uses.


    #CostingStandard(CT-Foundation)


  • 3.  Re: KPI comparison

    Posted Sat December 29, 2018 04:18 PM

    That's great! Thank you!


    #CostingStandard(CT-Foundation)