Has anyone found an easy way to account for this situation?

An easy example is average hotel rate. We set a target of $50 per night. The actual calculation is hotel costs / hotel nights.

I need to aggregate this from a machine level to a division level so I don't believe I can do the calculation as a datapoint and the measure as a number. It would not average the aggregation. With over 90 machine I don't want to have to trick the system by dividing by 1 for the target if it isn't needed.

This message has been edited. Last edited by: Jasen,

Jasen -

For Ratio & Percentage Measures, if you use a fixed Target the displayed value will automatically be averaged when you aggregate at a higher level.

So you will still see the target as $50 at all levels of your dimension.


EricH

How do I use a fixed target though? It wants me to enter a ratio for the target.

Click in the check box under the # column. This opens up an entry box. Enter the fixed ratio value. It will be preserved on aggregation.

This is discussed in the PMF manual on p. 307 in the section "Working With Measures". Yes I know, the manual can be a bit overwhelming the first time you look at it, but it is your friend!

This message has been edited. Last edited by: EricH,

If the target was static I could do that, but the number changes from year to year and is different for each machine. The target can range from $40 to $90 per night based on location of the machine.

If the Target is not fixed (i.e. static), then you have to supply both a numerator & denominator - and you will have to do the "trick" of putting a 1 into the denominator.

The simplest way of getting that "1" is to create a User Defined Field on the Source and set it to 1.