Forum Discussion
Report builder - 3 vars in a graph with different timestamp
- 1 year ago
Hi all,
The tittle 'VARIABLE' on the timestamp column you reffer to was just a string, it was my mistake because I added a new column an did not change the string text.
You were right about the Date, it was not in the correct order, so I saw that by default, this selection is empty, Dont know why:Just selecting here the TIMESTAMP, I could plot th 3 variables:
In addition if I configure it as my client wants, I can obtain something beauty for a Temperature/Humidity or whatever in a room:
Thanks a lot
Hi aplaza1
The image you've shared appears to be a table or a screenshot from a data logging or visualization system. It shows data for three variables: "UTA1-TT01.PV," "UTA01-TT01.SP_ALM_HH," and "UTA01-TT01.SP_ALM_LL," each associated with different timestamps. The "VALUE" column indicates the measured or recorded values for each variable at the corresponding time. The "Gráficos" section at the top suggests that this data is intended to be visualized graphically. The challenge you're facing is that when you plot these variables, they don't create a smooth, continuous line graph as expected. Instead, they appear as a series of horizontal steps, indicating that the plotting tool is not correctly interpreting the timestamps as a continuous time axis for interpolation. This is likely because the timestamps are being treated as categorical labels rather than numerical values representing points in time. To fix this, the timestamps need to be converted into a numerical format that the plotting tool recognizes (like seconds since a specific point in time or a decimal representation of the date and time). Once the timestamps are in the correct numerical format, the plotting tool can then be configured to treat the time axis as continuous, allowing it to draw lines that connect the data points smoothly and accurately represent the changes in the variables over time.
Hi all,
The tittle 'VARIABLE' on the timestamp column you reffer to was just a string, it was my mistake because I added a new column an did not change the string text.
You were right about the Date, it was not in the correct order, so I saw that by default, this selection is empty, Dont know why:
Just selecting here the TIMESTAMP, I could plot th 3 variables:
In addition if I configure it as my client wants, I can obtain something beauty for a Temperature/Humidity or whatever in a room:
Thanks a lot