Guage showing performance %

[hschultz]

Hi guys. I sit with 2 problems & really hope you are able to assist please.

I am trying to build 3 guages to show an effectiveness rating for non internal staff as of month-to-date, year-to-date, and in total

Basically it is [TimeSpent] in min converted to hours, against the [AvailableHours]

So if they spent 40 hours, and there are 100 available the guage must show 40%.

For Total i am trying to use:

SUM( {$<ProductRollup -= 'Internal'>} (([TimeSpent]/60) / [AvailableHours]) )

That gives me a big total of over 16000%.

Using AVG gives me a very low % of about 1 or 2

For the Month-to-date i am using this:

SUM( {$<YEAR = {$(vCurrentYear)}, MONTHNUMBER ={$(vCurrentMonth)}, ProductRollup -= 'Internal'>} (([TimeSpent]/60) / [AvailableHours]))

Now this works great if I selected only 1 employee. But when I select another or all employees, again it adds my total.

Replacing SUM with AVG results in a completely wrong total of about 1 to 2 %.

Any assistance in getting these 3 working will be greatly appreciated. Thank you.

[hschultz · Accepted solution]

Hi all

I have managed to fix this:

The Dimension i just added 'SUM', then in the Expression added:

Sum({1<YEAR={$(vCurrentYear)}>}(TimeSpent/60))

/

Sum({1<YEAR={$(vCurrentYear)}>}AvailableHours)

The porblem was obviously against the dimension not being a total, but something speciffic.