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!