I have IoT device data stored in RDS, and I want to analyze this data through Amazon QuickSight. I can ask questions like, ‘What was the highest temperature recorded?’ and ‘What was the average humidity observed last month?’ Additionally, I have a boolean field ‘lightsOpen,’ where 1 means the light is switched on, and 0 means it is switched off. I would also like to ask questions such as ‘Tell me the current status of the light.’ This should check the latest timestamp value of ‘lightsOpen’ and indicate whether the light is currently switched on or off.
Quicksight response to this question is:
“There are 2 unique light statuses. The light status with the highest total light power usage is 1, with 451 units”
What I can do get the desired response? or is this not a valid use case for Quicksight in Q?
