I’m using InfluxDB to store Home Assistant state data, and the units of measurement for my gas meter recently changed from “ft3” to “ft³”. Initially, InfluxDB had two separate measurements, one “ft3” and one “ft³” before I realized the change. I wanted to combine the data under the new “ft³” measurement, so I dropped all “ft3” measurements and then used the “Write data” function from Chronograf to re-add the same data under the “ft³” measurement. Now Chronograf shows only one measurement for my gas data, “ft³”, but the data prior to the change cannot be viewed in the same visualization as the data after the change. For example, this is a table spanning pre-change and post-change data:
SELECT mean("value") AS "mean_value" FROM "home_assistant"."autogen"."ft³" WHERE time > now() - 23d AND time < now() - 15d AND "entity_id"='meter_gas' GROUP BY time(1d) FILL(null)
There is no data shown on 9/4 or later, which is the date when the change from “ft3” to “ft³” occurred. However, if I adjust ONLY the timespan in the query, as below, the table displays correctly data for each day (though I can’t embed another image as a new user).
SELECT mean("value") AS "mean_value" FROM "home_assistant"."autogen"."ft³" WHERE time > now() - 17d AND time < now() - 10d AND "entity_id"='meter_gas' GROUP BY time(1d) FILL(null)
Oddly, if the query starts at
time < now() - 18d or
time < now() - 19d, there are no results, regardless of time span submitted.
It seems like Influx still doesn’t understand that the measurement for all this data is the same, despite Chronograf only showing “ft³” and no measurements of “ft3”. Is there some metadata that I need to clear out or regenerate, or is there another solution?