topic Re: Attribute Assistant - delayed field update in Water Utilities Questions

Attribute Assistant - delayed field update

BrynMorris-hale — Thu, 09 Nov 2017 09:04:28 GMT

Hi - I'm looking for some help with my attribute assistant updates. It seems they are delayed or one step behind.

I'm using a Feature Stats Value method to sum a number of columns together. These are quarter totals for the year and the result is a year figure. This is working fine. I then have another Feature Stat that sums all of these year totals to get a final figure. However this doesn't updated straight away, it seems only after I have entered another value does it update based on the first value entered, so it always seems to be one step behind.

I've tried changing the weighting and putting the final sum to the end but this doesn't work.

Interestingly when I use the attribute assistant toolbar and 'run change rules for selected features' it updates and corrects everything and it works fine.

I've attached my dynamic value table. The rules that are delayed or one step behind are OBJECTID16 and 17. Total Compl and Total Commit.

Any help would be greatly appreciated.

Thanks

Re: Attribute Assistant - delayed field update

MikeMillerGIS — Fri, 10 Nov 2017 16:00:43 GMT

Any chance you can post a GDB with the dynamic value table and the Housing_Monitoring table so I can run through this and see what is happening

Re: Attribute Assistant - delayed field update

BrynMorris-hale — Mon, 13 Nov 2017 09:10:09 GMT

Thanks Michael, could I email this to you as its confidential?

Re: Attribute Assistant - delayed field update

MikeMillerGIS — Mon, 13 Nov 2017 15:24:19 GMT

Yes, but feel free to include no data, just a schema. I can fake out a few features. mmiller@esri.com

Re: Attribute Assistant - delayed field update

BrynMorris-hale — Wed, 15 Nov 2017 08:34:05 GMT

thanks I've sent you an email

Re: Attribute Assistant - delayed field update

MikeMillerGIS — Mon, 27 Nov 2017 21:17:15 GMT

Bryn,

Sorry for the delay, was out on vacation. I reviewed the sample. I believe the issue is with the field weight. The higher number runs first. So switch your feature stats for the fields to run first, meaning a higher field weight number, I set them all to 35. Then your summary of each year, say 30, then the final expression last, say 20. Weights are just relative. Like label weights.

Re: Attribute Assistant - delayed field update

BrynMorris-hale — Tue, 02 Jan 2018 09:32:15 GMT

Thanks Michael, Sorry for the delayed reply. I tested that and it works! I really appreciate your help on this. Cheers.