Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Cale    Date: Feb 13    Category: Sharepoint    Views: 1051

I have a list that are essentially yes/no/n/a answers to questions. I need to do
some a KPI list (and maybe some other eye candy dashboard stuff) with this info.
I need to display something like the following:

- If 9 out of 10 questions were answered yes, display as green
- If 8 out of 10 questions were answered yes, display as yellow
- 7 or less answered yes, display as green

I am working on a calculated column that adds the yes answers, and divides by
the number of columns, but I can't get the indicator to display what I want. It
seems to want to lump it all together and give a percentage of all the



4 Answers Found

Answer #1    Answered By: Nalin Rao     Answered On: Feb 13

Create a page with a dataform web part on it in SPD and then use conditional
formatting to display  the green/yellow or whatever indicator.

Answer #2    Answered By: Thomas Davis     Answered On: Feb 13

I cannot find the dataform web part.

Answer #3    Answered By: Dominic Davis     Answered On: Feb 13

Go to the DataSource panel in SPD and find your list. Right click on the list
and select Data source details. Once the Details task pane comes up pick the
columns you want to display  and use the dropdown at the top of the list  to
insert as a Multiple Item view (or something like that since I'm going from
memory.). That will insert a data form web part. You can’t insert one from
the webpart gallery.

Answer #4    Answered By: Indu Raj     Answered On: Feb 13

Take a look at the following blog post for a step by step


Didn't find what you were looking for? Find more on KPI LIst Or get search suggestion and latest updates.