Averages in KPI's from Filters RRS feed

  • Question

  • I am trying to display average attendance in a KPI/Scorecard.    This is being displayed on a page that has a time intelligence filter that can return ranges such as previous 8 weeks, or previous 12 months.       I need to find a way to utilize this time intelligence filter in the average calculation.


    I understand that we cannot use <<MonthRange>> notation in the MDX of the KPI.    Is there another way to accomplish this?


    Thank you

    Monday, October 6, 2008 11:32 AM