Hi @ITWhisperer Sorry for the delay. my expectation is, suppose everyday we have data at 22:00 we need to keep that data and ignore the rest other data. can outlier be the option to ignore the data coming with different timestamp? please note: it is not always 22:00 data it can we any time but we have to ignore the other timestamp data apart from the usual one. base search:
| mstats sum(Entity.InMessageCount.count.Sum) as count span=1h where index=cloudwatch_metrics AND Namespace=Entity AND Environment=prod AND EntityName="Order.SupplierDepot" AND ServiceDenomination=OutboundBatcher by Namespace, Environment, ServiceDenomination, MetricName, EntityName
| where count > 0
Output:
_time
Namespace
Environment
ServiceDenomination
MetricName
EntityName
Count
2023-10-06 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
1
2023-10-07 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
2
2023-10-08 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
3
2023-10-09 09:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
4
2023-10-09 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
5
2023-10-10 09:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
6
2023-10-10 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
7
2023-10-11 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
8
2023-10-11 22:00
Entity
Test
TestBoundBatch
TestMessageCount
TestOrder.Supplier
9
... View more