Lightup Community
Getting error for a slicing based query
I'm getting the following error when I update and restart my LightUp metric and monitor:
```
Metric collection paused due to an exception
Please review the SQL. Duplicate timestamp (epoch in seconds) in
row {"CNT_ERR": 745, "event_ts": 1706508000} and
row {"CNT_ERR": 7180, "event_ts": 1706508000}
```
Can anyone help out on how to fix the issue?
Posted by Keshav Bohra about 2 months ago
How to configure percent change thresholds for a monitor?
I'm trying to add a monitor to alert when the total count of records drops by 3% in a day - how would I configure the thresholds to accomplish this?
Posted by Claire W 6 months ago
Usage of different TIMEZONE in SQL Metric
I have 3 questions here. PFB the same:
1. What is the exact use of **AGGREGATION TIMEZONE** while creating SQL Metrics(Step 2- Configure Metric)? Actually in the data I have the timestamp in EST. How does adjusting this variable impact the final graph?
2. What is the exact use of **TIMEZONE **while creating SQL Metrics(Step 2- Configure Metric) in the Partitions Section? My partition is also in EST, so will the graph here be impacted if I set it to EST?
3. In step 3-Preview, we can select the starting and ending timestamps. Could you please confirm this will be in which timezone?
Posted by Goutam Das 11 months ago