I'm using Sharepoint 2007 and sharepoint designer, and I am using multiple sharepoint lists that have the same column types (# required, # complete, % complete) that shows the training status for different departments in my organization. For example, I have List1 (Sales), with a row, Title: safety training, # required (number of people in that department): 10, # complete: 8, % complete: 80.

List1 goes into KPIList1 and is displayed on a KPI webpart on the Sales page in my site collection (Lets call it Dunder Mifflin).

List2 (Administration) is a similar list (#required: 4, # complete:2, % complete: 50) that is displayed on its own KPI webpart on the Administration page in the same site collection.

The endstate is an overall KPI on the main page that reflects the overall safety training status for the organization (in this case 65% complete). I want each department to be able to update their own training status and have that automatically update the Overall KPI.

What I've been trying to do is import the rows from List1 and List2 onto an "overall" sharepoint list (List3), so I can calculate an average of the two, either in the List3 sharepoint list or in a KPI list.

I tried going the data view route, but to my knowledge it won't let me calculate an average and I don't think I can display the data view in a KPI webpart. You can probably tell from reading this that I don't have much programming experience, so step-by-step directions and/or screenshots are very helpful.

  • From a glance what you need to do is join the lists? Or do you want the data to be sequential? A join would put the rows side by side, sequentially they would be merged (ie the columns are the same) If it is a join then you can perform joins, not sure if it will work with the KPI webpart as you said. 2010 is far more powerful for this sort of work. Since I don't have an exact answer for you Stephanie at the moment I won't put it as an answer, but if this works, please reply to your post as the answer. List joins: blah.winsmarts.com/… – Hugh Wood Dec 3 '12 at 12:28
  • 1
    I ended up using the data view to join my lists but I was unable to set it up in a KPI. Because of that I added an extra column to my data view and used conditional formatting to simulate the KPI status. – Stephanie Dec 11 '12 at 16:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.