Sign in to Community
Sign in to view all badges
It would be good to have a feature to create a calculated metric from the calculated metrics.
1) In some cases, I need to calculate intermediate results and then finally consolidate them to have an "end result" as well.
CM1 = evar5 + evar6 - evar7
CM2 = evar8 + evar9 - evar10
===> CM = CM1 + CM2
2) In some cases, I have to breakdown a big formula into manageable chinks, and use those chunks to get a final calculated metric.
CM = (evar4 + evar5 - evar 10) + (evar 11 + evar9 - evar2) + (evar6 + evar7 - evar3)
CM1 = (evar4 + evar5 - evar 10)
CM2 = (evar 11 + evar9 - evar2)
CM3 = (evar6 + evar7 - evar3)
Finally, CM = CM1 + CM2 + CM3