IBM WFSS Ideas Portal



Our team welcomes any feedback and suggestions you have for improving our offerings. This forum allows us to connect your product improvement ideas with IBM product and engineering teams.


For product documentation, see Knowledge Center.
Create and View Support Cases and Use the Discussion Forum here


Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases


The shorter URL for this site is:

IBMers, please visit the WFSS Internal Ideas portal

Allow a Metric to be used in the definition of a subsequent Metric in Calc Wizard

When creating Metrics in Calc Wizard in v9, you can only use functions and arithmetic on fields in your data sources in the calculation. It would be VERY HELPFUL to be able to use other Metrics defined earlier (above this one) in the calculation in the definition of other Metrics in the same calculation. I find myself creating Metric1, then copying the entire thing into Metric2 and adding more calculation steps, then copying the entirety of Metric2 into Metric3 to add even more steps. Being able to reference Metric1 directly as part of the definition of the formula for Metric2 and then reference Metric2 directly in the formula for Metric3 would be very helpful indeed. More than 3 levels of nesting is desired - up to 10 would be nice, or whatever the maximum is for number of metrics in a calc.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Apr 9 2019
  • Need More Information
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    20 Jun 20:57

    Even more important than reordering metrics, but going hand-in-hand with it, is the request above.  Why was this rejected outright?  If you don't think this is valuable, that only proves you have never created calculations for an actual customer or for a demo POC.  This is VERY IMPORTANT and would be extremely useful.  The hoops I have to jump thru to work around this deficiency is extraordinary.  If you don't agree, please seek me out and we can talk about it and I can let you know why I feel so strongly about this.  This being rejected is yet another reason why I have all but given up on these types of "ask for enhancements here" projects with ICM.

  • Admin
    Paul Peters commented
    24 Jun 16:54

    Please comment and vote on this IDEA for feedback and support.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    24 Jun 18:28

    Note that this idea was originally submitted under v9, but it would be for v10 today.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    24 Jun 19:13

    several other calc wizard enhancements would certainly score a higher value with our users if you asked them the order in which to implement.  But this one I come across from time to time and would be helpful for sure. 

    It would probably make sense to have the Prod Mgmt team allow several senior consultants weigh in on what enhancement requests would save them a lot of time during our implementations and weigh them accordingly.  We have several that were marked 'will not implement' yet would certainly improve the UX of the product and allow us to complete implementations much faster.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    25 Jun 15:25

    I am a Sr Consultant, and I see the value of this enhancement request.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    01 Jul 16:56

    This is an important suggestion and is expected of any calculation engine.  I would say that this shouldn't just be in calculations but would be just as valuable in creating calculated columns in presenter.