Forum Discussion

villa1980's avatar
villa1980
Resolver II
2 years ago
Solved

Create a Group Based on Separate Metrics

A very simple one, but my mind has gone blank.
I have created a Metric Field, which contains the separate headers, BAU, Operational,Final.
What I would like to do is create a new Metric that basically says if it is BAU then "Normal", Operational then "Ops" , Final then "Make Decision".
I still want to keep the original headers, but then want this new group so can report at both levels.

 

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, villa1980 

     

    You want a formula like this?

    Measure=IF(A1="BAU", "Normal", IF(A1="Operational", "Ops", IF(A1="Final", "Make Decision", Blank())))

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, villa1980 

     

    You want a formula like this?

    Measure=IF(A1="BAU", "Normal", IF(A1="Operational", "Ops", IF(A1="Final", "Make Decision", Blank())))

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • villa1980's avatar
      villa1980
      Resolver II
      2 years ago

      Just wanted to say thank-you for the response and it worked very well. An if statement did not cross my mind, I was trying to use Switch but that was erroring.

      Thank-you again.

      Alex