Dynamic view Refresh Error Issue

[jjustingkm]

I am getting a dynamic error refresh error issue when the template apps chart doesn't have any data to return.

this is the massage I get type error cannot read properties of undefined (reading '0)

I suspect the failure happens during the first time refresh the subsequent are successful.

[edwin]

the first time the sheet is opened, the DV will refresh.  of course if you dont have any selections, the binding variables are all null.  what i do is for each binding variable i pick up the COUNT (odagcnt_....), i do this for all the binding variables i use in my script.  there are constraints weve built in and if any count is wrong, i test all the COUNTS and exit script so that the rest of the script is not executed - NO REFRESH ERROR message.  then in my DV, i add a calculation condition incorporating all the COUNT constraints, and in the calculation message i list out any violation of constraints 

this way the failure is graceful and the message helps the user by pointing out what needs to be changed in the selections

[jjustingkm]

In this case, the failure happens after I select all the filters and run, mostly I noticed the failure happens in the first run.

For example, if country and date are the filters, if I select country Mexico , Date 8/28/25 and run the error message gets, but again i refresh it runs successful. 

[jjustingkm]

And also get this message after the failure and if try to refresh again immediately after that.