I currently have several dashboards for client fleets using Interfaces. On these I use the Field Summary to calculate the percentages of a fleet based on whether they are 'active' and within a servicing window.
What I would like to do is automate a function to grab that Field Summary data and at the end of the day input it into a new table to historically graph this data for analysing trends. This is already graphed and I simply enter the data manually. I know how to automate the trigger but after extensive reseach I think the only way to grab and record this would be a script.