Questions tagged [kpi]

A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a goal.

Filter by
Sorted by
Tagged with
0 votes
1 answer
418 views

KPI for Sharepoint Online hooked into Excel

I've been tasked with looking for replacements for our current KPI system as we move from Sharepoint 2013 to Sharepoint Online. In our current system we use a KPI web part that hooks into Excel ...
methodOverload's user avatar
0 votes
0 answers
91 views

Best way to design a dashboard based on a SharePoint list with KPI

I have a SharePoint list with 100+ KPI which has a target and actual goals with KPI title. How do I show KPI indicators for these data?
Johnson Murphy's user avatar
0 votes
1 answer
132 views

Best approach to design/display dashboard (kpi) using sharepoint kpi list

I have a sharepoint list with 70 kpi data points (i.e. month, goal/target, actual). What is the best way to display this data in sharepoint. i tried excel powerpivot based on the sharepoint list but ...
Ruby Trustit's user avatar
1 vote
1 answer
1k views

Creating KPI Status Indicators with Calculated Column

I am trying to use calculated columns to have a possibility of 3 status indicators come up based on another column that is called projectstartday which shows how many days are left until a project ...
Madeline Faunce's user avatar
2 votes
3 answers
1k views

SharePoint Online: Status Indicator / Stop Lights

I have 3 columns: InorOut In (calculated field) Out (calculated field) The In and Out columns displays the icon using this formula: ="<DIV style='text-align:center'>"&IF([In or Out]="In","...
Tamras Merin's user avatar
0 votes
2 answers
10k views

Status Indicators on SharePoint Online

I am looking to create some kind of status indicators for a list that I have produced. I just want a simple red, amber, green setup. I came across the status indicator webpart but I couldn't get this ...
James's user avatar
  • 17
0 votes
1 answer
144 views

Using key Performance indicator on SharePoint 2010

I have a list, how do i add kpi indicator on the list. Since I have a column on that list as Project health. If I add green on project health i want to display green round, if yellow then yellow ...
Mohammed Eliyas Ahmed's user avatar
3 votes
0 answers
3k views

Create Indicator List in SharePoint 2013?

How do you create a KPI Indicator List as required by the Status List (Business Content) Web Part? This article suggests they're no longer supported (but link to MS site is broken). The article also ...
PeterX's user avatar
  • 1,020
0 votes
2 answers
3k views

Using a Calculated Column to show Images

Ok, I've been working on this most of yesterday and today. I am able to render an image with the following formula - ="<div><img src='/xx/xx/PublishingImages/"&IF([Employees ...
user28400's user avatar
4 votes
4 answers
4k views

Dashboard in SharePoint Online

I need to create some dashboards in SharePoint Online (with OOB or any feature provided by MSFT), I am not allowed to use any kind of Custom Code for it. As Performance Point is not available in SPO, ...
cjs's user avatar
  • 1,204
0 votes
1 answer
153 views

How to create multiple KPI's in a row

I want to create multiple kpi's in one row. Example: Charlotte office and then a kpi for phones, a kpi for internet, a kpi electricity, etc all side by side with the appropriate headers. Basically I ...
SurfSamurai's user avatar
0 votes
1 answer
626 views

Show Status Title and icon only in web part

Specifically, I need to consume the Indicator title and the status icon on the front page of a web part page. Example: Network Status : Green icon, Marketing Status : Yellow icon. I don't want ...
Sean's user avatar
  • 404
3 votes
2 answers
4k views

Sharepoint KPI using calculated columns

I am trying to create a KPI for the tasks schedule we have on a calendar. The formula I have is: "<div><img src='/_layouts/images/KPIDefault-"&IF(Completed="Yes",0,2)&".gif'/><...
Craig's user avatar
  • 31
0 votes
1 answer
158 views

'Select a measure:' stuck on 'Loading...' in Dashboard Designer KPI Dimensional Data Source Mapping

I am trying to create a KPI in Dashboard Designer, but am getting a timeout. I have been doing this for a while on my site; this is not the first. I haven't had this problem before. I created a new ...
Conrad's user avatar
  • 199
0 votes
1 answer
143 views

How to make status indicators that depend on child status indicators?

We've been tasked with using SharePoint 2010 to create a dashboard for at-a-glance production line status. The line is broken into different areas each with their own status indicator: green when no ...
user111023's user avatar
1 vote
0 answers
31 views

What is a Scorecard Custom Set Formula and how do I use it?

When creating a Scorecard which includes a KPI, in the right "Details" frame, there is a section for "Set Formulas" and under that (along with Time, which I understand) is "Custom" which I can't find ...
Conrad's user avatar
  • 199
0 votes
1 answer
60 views

Using Time Intelligence Filter inside KPI with a Scorecard

I am trying to take advantage of the Time Intelligence Filter inside of a KPI, so that I can add this KPI to a Scorecard and have, say, the last 5 days of data from the KPI in the Scorecard. (I have ...
Conrad's user avatar
  • 199
0 votes
1 answer
173 views

Using KPI's to count Document Sets in SharePoint 2013

I am using Document Sets to track multiple documents as a "case", and would like to use the SharePoint KPI's to track total numbers of cases. I can get the KPIs to count the total documents inside of ...
Brent Ellis's user avatar
3 votes
1 answer
726 views

Configuring KPI in dashboard designer

I'm configuring a KPI for my SharePoint 2010 site. Take this example of a "projects" list and a "project progress" field in this list which is shown in percentage. I want to configure a KPI for this ...
Paiman Samadian's user avatar