Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Students Click Here

How to creating a new metric based on the Total value?

How to creating a new metric based on the Total value?

How to creating a new metric based on the Total value?

Below is a snapshot of my report.
    Metrics           Approvals    Mailed     NRR
-------------------------------------------------------Score Band                
less than 650           1,121    15,333    7.31%
between 650 and 700       6,908    12,084    57.17%
between 701 and 750      11,120    12,583    88.37%
between 751 and 800       9,815    10,321    95.10%
between 801 and 1000       2,104    2,192    95.99%
greater than 1000          22    432    5.09%
Total                  31,090    52,945    58.72%

Score band is actually an attribute.
NRR is my metric which is defined as sum(approvals)/sum(mailed).

Now I need to create another metric called the NRR Index which would be calculated as the value in NRR column divided by the Total NRR value.

e.g. my end report would like as shown below.
NRR Index 0.12=7.31/58.72
    Metrics         Approvals    Mailed     NRR    (NRR Index)
-------------------------------------------------------Score Band                
less than 650          1,121    15,333    7.31%    0.12
between 650 and 700   6,908    12,084    57.17%   0.97
between 701 and 750  11,120    12,583    88.37%   1.50
between 751 and 800   9,815    10,321    95.10%   1.62
between 801 and 1000  2,104    2,192    95.99%   1.63
greater than 1000     22    432    5.09%    0.09
Total             31,090    52,945    58.72%

How can I do it in MSTR? The value 58.72 is a calculated value displayed when I choose to display the subtotals option in MSTR. How can I use that value in the formula of my new metric called NRR Index?

Awaiting your responses.


RE: How to creating a new metric based on the Total value?

You need to create the denominator as a metric.  You can either

- create a metric called NRRTotal as sum(approval)/sum(mailed) but ignoring the dimensionality of "range".  
- or you can create a derived metric within the intelligent cube defined as sum(approval){} / sum(mailed) {}.

This is important as you don't want it to break it out by the rows in your report.  If you add this metric to your report, it should show 58.72 for all rows.

then create metric NRRINdex as NRR/NRRTotal.  This is like creating a % contribution metric.

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.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close