This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Limits on rolling calculations

Posted on 08-21-2024 08:58 AM
tranau151
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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?

 

0 1 126
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
sam8
Staff
Reply posted on --/--/---- --:-- AM

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.

0 Likes