valuesToDate

Use valueToDate to perform statistical operations on the result and score generated by a object during a particular period of time. For example, use this function to insert the highest score a measure achieved in the past six months.

You can use valuesToDate with the following:

  To use valuesTodate:

  1. Select Functions, thenTime, and then double-click valuesToDate.

  2. Select the measure whose values to use from the box that is displayed. To use the current measure, select This measure.

    This inserts: valuesToDate(attribute, “measure”, period)

  3. Replace attribute with a function that retrieves the kind of value to use.

    For example, to use the scores of a measure on a scorecard, enter onScorecardMeasures and select the scorecard from the box that is displayed.

    Tip:

    To calculate values using a target other than the Report Target, right-click and select Insert Target.

  4. Replace period with one of these intervals that represents the time after which values were available:

    • day—Use if the object began generating values yesterday.

    • week—Use if the object began generating values 7 days ago.

    • month—Use if the object began generating values 4 weeks ago.

    • half-year—Use if the object began generating values six months ago.

    • year — Use if the object began generating values a year ago.

For example, to insert the highest score a measure on a scorecard has achieved this year, enter:

valuesToDate(MAX(onScorecardMeasures,”Scorecardname”,year))