Time filter for scorecard using sharepoing list as data source RRS feed

  • Question

  • HI,

    I have created scorecard, where the KPI has been created using the sharepoint list data as the data source. My sharepoint list have following columns:

    Department, Planned Cost, Acutal Cost, Region, Date

    the scorecard has been built successfully, now i need to create time filter for the scorecard so that user can see the results only for the selected month. and this is where i am stuck: I have created a filter, connect the display value of the filter with the scorecard date field but filter is not showing any values, its blank.

    the formula i have used during the create filter wizard is: Month:Month-1, with the assumpton that it will show me Year.Jan - Year.April for the selection. in the preview it does show me this but when i deploy the dashboard it shows nothing.

    Any idea if anything is wrong with my formula? or am i missing any step?

    i simply need my time filter to show me year (starts from 2011) and the months, how can i do this?

    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, April 19, 2011 11:18 AM