I’ve set up several transactions in transaction groups to log data to a table. The transactions log data from several different data points from several different sites every hour, on the hour. Essentially, I have a table that has the columns - Timestamp, SiteName, Value, and Description (the type of value it is. Temperature, volume, etc.). All the different values from all the different sites are all lumped in there together.
On one of the tables in the report, I would like to look something like this (just a mockup I did in excel):
What’s the best way to go about achieving the above table in my report?
I need to account for null values, as well if there are multiple entries for one time period on accident. Would nested queries be what I need? Or maybe having many different SQL queries for just one item, and then joining them together with a python script. If you’ve solved this problem before, feel free to contact me directly. Thanks!