Forum Discussion
Generating Points based on an equation
HI, I have a equation let's say Y= ((Ymax-Xnum)/(Xmax-Xavg)) . Here we know Ymax, Xmax and Xavg which are given and Xnum is driven by a duration and starts from 1. (Eg: If the Duration is 50 then...
But the problem is, the single measure would use Xnum in the formula. How do I accomplish that?
Thats where using the table of XNum values and placing it as an Axis on the graph produces those results. Measures are recalculated for each context. In this case, by using the Axis, you are creating a context for each and every XNum.