How to get SUM of all unique records for a time period? Not a SUM of VALUES

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

Hi, I have the same question, did you fide out the solution?