ADD KEY Process Indicators (KPI) to SharePoint list :


steps to make indicator coloum :
add a new calculated column to you list :


add the three indicators icons to site asserts document library and use them from there.
add the formula as below :
=IF([complete %]<10,"<img src='http://yoursiteurl/sites/name/SiteAssets/indicator_button.png' alt='red' height='22' width='22'>",

IF(AND([complete %]>9,[complete %]<50),"<img src='http://yoursiteurl/sites/name/SiteAssets/yellow.jpg' alt='yellow' height='22' width='22'>",

IF([complete %]>50,"<img src='http://yoursiteurl/sites/name/SiteAssets/green.jpg' alt='green' height='22' width='22'>",)))

ADD more if conditions basing on you requirement.
my assumption for conditions
red<10
10>yellow<50
green>50




Comments

Post a Comment

Popular posts from this blog

Metalogix Exception thrown: Server was unable to process request. ---> Value does not fall within the expected range. Solution : Look for app pool .Is posible reset iis .
Read more
REST API The Basics Before it can do anything with SharePoint, your remote Web or mobile application must obtain authorized access. In SharePoint 2013 there are two general approaches to authorizing access to a SharePoint site (regardless of whether you’re using REST). The first approach involves authenticating a SharePoint user, in which case your application has the same access to SharePoint data and capabilities as the user. The different ways you can authenticate a user from a Web or mobile application are outside the scope of this article, but we’ll briefly mention two new options in SharePoint 2013 because they affect the way you construct your REST requests: If you’re calling into SharePoint from a remotely hosted application that can’t use client-side code (HTML and JavaScript) exclusively, and there’s no firewall between SharePoint and your application, you can use OAuth 2.0 tokens with Microsoft Access Control Service (ACS) as the secure token server. If client-side ...
Read more
Image
Allow SharePoint 2013 site to load into IFRAME in non-SharePoint application add the code highligted to all of your master pages if you have multiple masterpages. <WebPartPages:AllowFraming runat="server" />
Read more