I seem to be hitting a limit when using field calculations that are dependent on previous results. For example:
- fieldA = metric1 + metric2
- fieldB = fieldA + metric3
- fieldC = fieldB + metric4
- fieldD = fieldC + metric5
- fieldE = fieldD + metric6
- fieldF = fieldE + metric7
- fieldG = fieldF + metric8
- fieldH = fieldG + metric9
- fieldI = fieldH + metric10
and so on...
I'm hitting the limit around 9 or 10 rolling calculations. The formulas are valid but when I add the field into the chart, I get the "Data Set Configuration Error". What's more insane is sometimes I can substitute the calculated field with the formula for the previous calculation and it works. For example:
Instead of fieldI = fieldH + metric10 (which would fail), I have to use fieldI = (fieldG + metric9) + metric10
But the formulas get more complex and again, it doesn't always work. Anyone else seen this or know a workaround?
LinkedIn
Twitter
