I´m running home assistant and got a tp-link router that I want to show how much data that I send/receive. The problem seems that the router is getting reset when it reaches some values.
Is there a way to keep the counting in a positive value. What I want is to how mutch data each day / month etc and show this in grafana. Is there a way to create a new entry that count byte sent/recieved each day? I want to show this by using grafana.
SELECT mean("value") AS "mean_value" FROM "home_assistant"."autogen"."B" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND ("entity_id"='m9plus_b_received' OR "entity_id"='m9plus_b_sent') GROUP BY time(:interval:) FILL(null)