I'd like to calculate the average of a signal in a display range, and then use that average value in subsequent calculations. I'd like the calculation to be dynamic, so if I adjust my display range, the average and all subsequent calculations should re-calculate.
The averages for my signals show up in the Details pane, and I can also use a simple Metric to calculate and display the average, but I can't figure out how to access those values in a formula.
I found an older post from 2019 that says it's currently not possible to use a Metric in a subsequent calculation:
The suggested workaround is "we recommend first using signal from condition to do the calculation of the parameter, then referencing your signal from condition in the scorecard metric tool"
But I'm not sure how to limit a condition to my display range. Is there a special capsule I could use that spans only the display range?