Update "Living" values using update by query

Hi,

I'm attempting to create a "score" field that will hold a value that will change whenever the sum of other fields change, but I'm not sure if this is feasible with update-by-query. For example, if I wanted to create a gaming app that would update each time the player scores a point or has multiple field objects that plays into the "overall" score. I have a script processor that will calculate the score based on the field values that makes up the overall score, but I want the "score" field to be a moving score.

I think the best way of doing this is as a processor on ingest time. Why doesn't it work and can you explain what a moving score is, that the ingest time processor cannot cover?

I configured the pipeline to just refresh itself by disabling sincedb.