Duplicate times in floodgauge charts

[matthewberryman]

[matthewberryman]

db_and_logs.zip

[tomasholderness]

Pushed a fix to cognicity-reports-floodgauges, where timezone was set wrong and SQL rows loop was incorrect.

https://github.com/smart-facility/cognicity-reports-floodgauge/commit/b59b95077521f1e521fa4be8e4d88c52b1955776

[matthewberryman]

I have this running on dev. Will monitor (ignoring old data that I won't drop). You can bump cognicity-reports to have updated submodule if you like but I'm primarily focussing on the merge branch of cognicity-reports.

[matthewberryman]

Still not quite right.

[matthewberryman]

@talltom looking at new data points coming in, it looks like you might be omitting the minutes when displaying?

[tomasholderness]

Check out latest pushes to floodgauge submodule. It was a problem with check for duplicate data.

https://github.com/smart-facility/cognicity-reports-floodgauge/commits/master

[matthewberryman]

Giving that a whirl now.

[matthewberryman]

Hard for me to check until either #72 is fixed or I could drop the tables and recreate if you like ?

[matthewberryman]

Seems to be resolving as new data comes in. Happy to close this off.