The goal: I'd like to generate KPI from a view of a SharePoint list. The KPI have to calculate the average of a number column (say MyColumn). When I want to create the KPI, I follow these steps:
- List URL: I get the URL of the list. I tried the AllItems.aspx, MyCustomView.aspx and "empty" list URL as well.
- View: I select my custom View (MyCustomView.aspx)
- Select the "Calculation using all list items in the view" option
And here is my problem. In this drop down list I can choose the columns from AllItems.aspx, not from my view. It doesn't depend on the chosen URL or View (in step1 and step2)! But my problem is that this column (MyColumn) is not interesting for the users in the AllItems.aspx.
But it's not everything...
Ok, let's show this column on the AllItems.aspx and create the KPI. It's ok, working fine. Let's hide MyColumn from the AllItems view (but show on MyCustomView, of course). The KPI works henceforward... Moreover if you open the EditForm of the KPI, it shows for you the columns from MyCustomView (as I want), but the KPI NewForm.aspx shows the AllItems.aspx's columns!
I started a thread on MSDN Forum, but no answer. Don't spare me, if you have any idea if does it works properly this way!
Posted
Jan 05 2008, 10:22 PM
by
aghy