Difference not right, because number format?

Hello i´m a newbie in InfluxDb, i have a problem and i think the problem is the number format, but i think the raw data are in the right format.

The problem is that i want to do the difference between two entrys (for a consumtion analytic), but the difference is to small between two entrys. Attached are Screenshots. The frist screenshot are the raw data, and the second screenshot are the data where i get vom InfluxDBGui.

Now i do the difference and the difference is smaller then 0,0009…
if you look at the data from InfluxDBGui there are 5.931,36 an now i think they do the difference after the komma (,) and not the hole number.

Why is in the InfluxDBGui the Number like this? and not like Raw Data Entrys?

Thanks for your helb :slight_smile:

Hello @shms,
You can change the decimal representation in the table in the GUI by going to settings > decimal value.

I think that will solve your problem. Let me know!

Please see this:

I think it’s related

Hallo Anaisdg,

thanks for your answer. But this was not the problem. I solved it, but I don’t know why this is working.

First i try to calculate the difference like this
|> difference()
|> aggregateWindow(every: 1d, fn: last, createEmpty: false)

Now I changed the difference() after the aggregateWindow and it works???

Now I have one more question. :slight_smile:

I have two measurements with 1 value. I would like to subtract the measurements 1 from the measurements 2 value, how does it works? In google i only find ways to do this with 2 Values in one measurements.

Thanks shms