Hello,
Is it possible to get SUM of all unique records for a time period?
For example, I have these records for a few days
awsec2_api{alias="awsec2metrics", instance_id="i-05a7d9e565ac8b7" reachability="initializing", state="running", systemstatus="initializing", zone="us-east-1c"}16
P.S. code 16 means running
One instance can have different statuses for 24 hours.
I would like to get SUM of instances for 24 hours like this:
Total istances = 10
Initializing instances = 12
Running = 20