Hi @Brett I am storing the Temp sensor data with below columns
SensorID | Timestamp | SequenceID | TempValue
Is the below validations are possible in the quicksight. Highlighting the row is required instead of any count values. The data highlighting will be based on filter controls applied for SensorID and Timestamp
Duplicate events received with same timestamp and same SequenceID
Data loss events occurred based on the SequenceID missing which is expected to be continuous
More % variation observed in temperature which usually varies within 0.01 deg w.r.t to previous packet. Need to identify if the variation is more than 0.1 degree
Thank you for posting your question here. I found below post might be helpful to achieve your data validation requirements. Conditional formatting based on column
To look for duplicate records, you can add a row count column (with static value of 1), bring that to the table and add conditional formatting to highlight row/cell having value greater than 1. The table will need to be grouped by Sensor id, sequence nb and timestamp.
To check for missing sequence numbers and temperature variance greater than specified value, you can use the difference function to calculate the difference of these values as compared to last record and then add conditional formatting on these. Arena link to a working sample is given further below. Once you launch the link, click the copy button from left panel to get an analysis copy of this solution and you can explore the calculations therein. Absolute Temperature Difference
