The data I am working with has several data entries at each time stamp. Each data point contains a field for sensor name as well as a field for value. So the field for sensor name is automatically linked with the value. With this type of data I am trying to look at multiple sensors at a specific time. I have tried creating calculated fields, but the issue is that they analyze the data by row and not timestamp. So when the calculated field gets to the first data point and tries to look at other calculated fields, it receives a null value as those fields are not specific to a time stamp, but to a sensor and not applicable to the first sensor. Any ideas on how I can look at data with multiple entries with the same timestamp in quicksight? Is it even possible?
