Hello all and thanks in advance for any help you provide!
I'm trying to set up a widget in operations dashboard to show average length per day. This could be a chart, number that changes as the average changes etc. Ideally I'd like to have a graph with the average each day for a week or so.
I have a field crew using AGO to update the status of a main from not flushed to flushed as they work through them. Each main has a length field. I could easily calculate this each day, but would like to have it ongoing in Dashboard.
It seems as though this isn't possible. Am I missing something? I can figure out the average length of each individual main and how many mains each day and provide that info. But can I then calculate them together?
Is there a custom widget out there that would do this? Seems like there should be as it is a fairly simple operation?