28 Feb 2025
	
		
		08:22 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
 - last edited on 
    
	
		
		
		03 Mar 2025
	
		
		11:10 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
 by 
				
		 MaciejNeumann
		
			MaciejNeumann
		
		
		
		
		
		
		
		
	
			
		
I am trying
//metrics/query?metricSelector=(remote_unix.cpu_utilization:
splitBy(dt.entity.remote_unix:host):avg):names&from=2025-02-21T00:20&to=2025-02-26T23:55&resolution=1d"//
but result time is from
22-02-2025 00:00
23-02-2025 00:00
24-02-2025 00:00
25-02-2025 00:00
26-02-2025 00:00
27-02-2025 00:00
instead of 21st to 26 why is that and
how to remove metric id from output .
api returns following columns
metricId
dt.entity.remote_unix:host.name
dt.entity.remote_unix:host
time
value
28 Feb 2025 08:52 AM
Hi 
can you use this query? I'm curious to know if something changes using UTC
/metrics/query?metricSelector=remote_unix.cpu_utilization:splitBy(dt.entity.remote_unix:host):avg&from=1632096000000&to=1632700800000&resolution=1d&fields=dt.entity.remote_unix:host.name,time,value
To remove the metricId from the output, you can use the fields parameter to specify the fields you want in the response.
In this example fields=dt.entity.remote_unix:host.name,time,value specifies the fields to include in the response, excluding the metricId.
28 Feb 2025 12:24 PM
1740032221000 - GMT: Thursday, February 20, 2025 6:17:01 AM
1740593821000- GMT: Wednesday, February 26, 2025 6:17:01 PM
from=1740032221000&to=1740593821000&resolution=1d" ^ 
but still it returns 
time
21-02-2025 00:00
22-02-2025 00:00
23-02-2025 00:00
24-02-2025 00:00
25-02-2025 00:00
26-02-2025 00:00
27-02-2025 00:00
your field selection worked
