Focal Point
[Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/9777005686

May 25, 2017, 12:36 AM
Jasen
[Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)
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,


WebFocus 8.002
PMF 8.2.3
Windows, all output
May 25, 2017, 01:43 PM
EricH
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
May 25, 2017, 02:37 PM
Jasen
How do I use a fixed target though? It wants me to enter a ratio for the target.


WebFocus 8.002
PMF 8.2.3
Windows, all output
May 30, 2017, 04:09 PM
EricH
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! Smiler

This message has been edited. Last edited by: EricH,
May 31, 2017, 09:38 AM
Jasen
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.


WebFocus 8.002
PMF 8.2.3
Windows, all output
June 02, 2017, 09:37 AM
EricH
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.