Limits on rolling calculations

Looker Q&A Looker Studio
,
1

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?

2

Hey there!

I went to test this on an internal instance and had no troubles. I got all the way to fieldK and it was still working fine.

Could one of your references be recursive or circular? For example, if fieldA references fieldB, and fieldB references fieldA, the calculation editor will accept the formula. However, the chart returns a “Data set configuration” error as you’ve described for this kind of circular logic.