I have a table "SensorHistory" that has info pertaining to rain gauge data.
My goal is to create summary information to eventually present rain gauge totals attributes such as 1 day, 7 day, 10 day, 24 day and YTD totals.
I was wondering how to go about this in ArcMap or ArcPro so that I have 5 attributes with site_id(see picture) and receive time for that day having the maximum rain gauge accumulation which would equal 11 in sensor_class?
I assume I would have to query out the table for the given time periods and use the max statistic (receive_time) for that day to get the rain accumulation. Not quite sure how to query that either so any help is appreciated! I also would need a model builder for this so it can be easily replicated again or can be used for future readings.
What I need is a summary value for each site_id listing the the max accumulations from the data_value field using on only the records that have 11 as the sensor_class value and the summary value derived based on four different date range record selections of received_time field values covering 1 day, 7 days, 24 days and all days in the given calendar year.
