KPI for each individual item in Sharepoint list


  • Hi,

    I have created KPI List. My reqirement is i have one list containing all project names with estimated budget.
    Now i want to create KPI for this list based on budget, i.e., want to show indicator based on each individual item estimated budget.

    But what i am able to do is based on No. of list items (or) based on %of list items (or) based on Sum, Maximum, Average, Minimum.
    But my requirement is want to display indicator for each item in a list.

    How to do this, Any ideas will be appreciated.

    Thanks & Regards, Neerubee
    • Moved by Mike Walsh FIN Monday, November 16, 2009 10:33 AM KPI q go to BI (From:SharePoint - Development and Programming)
    Monday, November 16, 2009 6:40 AM


All replies

  • Neerubee,

    You can accomplish by converting the list view in XSLT or by using calculated field column

    For more information please follow the links on apply background color to custom list column based on condition
    Color Coding – Formula Generator

    Additionally look at the similar thread and one more thread
    Best Regards, G Vijai Kumar | My Sharepoint Blog
    Monday, November 16, 2009 6:57 AM
  • HI Raj,

    Thanks for reply.

    I don't want by using calculation, because i have a list for example.

    Project Name                      Estimated Budget   

    XYZ                                      250000
    PQR                                      500000
    ABC                                      750000

    Now i want to check my goal is 500000, Now for each project have to show indicators. Not based on Average, %, Min, MAx etc..........
    And my list is dynamic one, if we keep on adding the projects, it should automatically update indicators.

    Hope you understood.

    Looking for answer..............
    Thanks & Regards, Neerubee
    Monday, November 16, 2009 7:05 AM
  • Neerubee,

    You can show indicators for each items in a list by using calculated field, all you have to do is by using below formula try to create a calculated field in the list name it as Value

    ="<DIV><IMG src='/_layouts/images/KPIDefault-"&IF(AND(Value>1,Value=<25000,"2.GIF",IF(AND(Value>25000,Value=<50000,"1.GIF",IF(AND(Value>50000,"0.GIF","Chartreuse"))))))&"'></DIV>"

    Now to render the KPI default images you have place the Javascript in CEWP as said in this thread

    Note: If you face any problem in rendering the KPI default images, make sure that Estimated Budget column is of Number type
    Best Regards, G Vijai Kumar | My Sharepoint Blog
    Monday, November 16, 2009 7:26 AM
  • I agree with SP RAJ.


    You don’t need the KPI list for your requirement.

    Wednesday, November 18, 2009 8:43 AM