Im trying to display rainfall data on my dashboard from an edn device that transmits pulse counts from a tipping bucket. I had created a synthetic variable to cound the pulses since the last uplink and times by the bucket volume. My synthetic variable looks like this - (diff(count,-1)*0.2) with the output being mm of rainfall for the given sample period (my case is 10 minutes).
I would like to display the rainfall in a bar chart with collumns stacked next to eaxh other on the X axis, one with the 10 minute totals for the past hour, one with the hourly totals for the day, and one with the daily totals for the week. ideally it would be good to be able to show these in different colours within the one chart as well.
Any help would be appreciated!