×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Rated Average (MSTR Report)

## Rated Average (MSTR Report)

(OP)
I need to calculate the rated average as example...

date       calls duration dur/calls (calls/total*dur/calls)
01-01-2003 750    1125      1,500        0,342
02-01-2003 405    689      1,700        0,209
03-01-2003 946    1325      1,400        0,403
04-01-2003 400    481      1,200        0,146
05-01-2003 330    544      1,650        0,165
06-01-2003 457    615      1,345        0,187
Simple AVG 3289    796      1,466        1,453
Rated AVG          1,453

I need to show 1,453 in Average Section... but I cant find and option in the total options.. to do this...
Thanks...

### RE: Rated Average (MSTR Report)

cabs -

This is a problem with the smart metric setting in the subtotals/aggregation tab in the metric editor.  You are trying to get the totalling for the dur/calls Simple AVG to differ from the Rated AVG total in the same report...

Columns 3 and 4 are the same calculation essentially, where column for is the total, and column three (dur/calls) has the 'smart' processing turned off.  Make dur/calls 'smart' and you will get the anser column 4 gives.

Smart totals on: sum(m1) / sum(m2)
Smart totals off: sum(m1/m2)

To get the format of the report you have to create a custom defined total.  Even with a custom total, the logic of the metric can't change just because the aggregation (sum, avg, etc.) needs to be different.

Basically, I think the question is: how can you make the totalling logic different in a custom defined total versus standard totalling ?

I don't think it can be done in this layout.  It could certainly be done with XSL, but that probably isn't practical.  The best thing to do is to have two metrics...one that is 'smart' and one that isn't.

Good luck.

Chael

### RE: Rated Average (MSTR Report)

(OP)
Thanks Chael....

Rigth, the question an the problem is : how can you make the totalling logic different in a custom defined total versus standard totalling ?

If somebody have a new idea, I'm waiting.....

Bye..

### RE: Rated Average (MSTR Report)

One of our consultants had the exact same requirement.  There's a supported way to do it but it is not exposed thru the desktop product.  We worked it out through the SDK with a MSTR consultant.

Cabs, you need to contact your MSTR production consultant and have him/her search thru their internal knowledgebase.  There's an article titled something like "using a metric as a subtotal for another metric" Sorry I can't remember it exactly.

good luck

### RE: Rated Average (MSTR Report)

nlim,

sorry but I don't think I know about this,(unless I forgot) but if anyone finds out how to do it I would be interested in it as well.

reisw

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!