Standard BoM rain data comes to us as a rolling accumulative total that resets to 0 mm at 9 am every day. This creates challenges for using and viewing this data relative to a more traditional data format (e.g. discrete log intervals of a total for each interval).
To convert BoM format rain data to traditional interval data:
1. | Create a "Calculated Input (Difference)" type input called "BoM rain difference" that references the BoM format data to calculate the difference between each log interval | |
2. | Create a Calculated Input V2 (Beta) input that references the previous calculated input, but which replaces any negative values with 0 using the script below: |
If Inputs.BoM rain difference.Value > 0 then |