Need matrices data such as CPU usage for a specific time range

[saradmishra28]

If I am extracting data for 25, 26 & 27 dates with a specific duration 9:30 am to 5:30 pm.

then I will get data in the following time span only :
1. 25-06-2023 : 09:30 to 17:30
2. 26-06-2023 : 09:30 to 17:30
3. 27-06-2023 : 09:30 to 17:30
How can I do it in either data explorer or notebook?

[vasile_gafton]

In Notebooks you can have for instance 3 different charts and for each chart configure one of the 3 timeframes

[saradmishra28]

actually, i gave above as explanation. 
I want to do that for 1-year data. So, writing separate instance for each timeframe will be a difficult task.

[Yosi_Neuman]

Hi @saradmishra28 

With data explorer you can use the Time shift transformation

HTH

Yos 

[saradmishra28]

Timeshift move the whole timespan to forward or backward in time.
I want to extract for a specific duration in a day i.e., 9:30 am to 5:30 pm for each day out of whole week/month.

[Yosi_Neuman]

Hi @saradmishra28 

Not sure what you meant by Timeshift move the whole timespan to forward or backward in time.

Hope the below screen shot explains better what you able to do with timeshift per metric with your exeat time frame. 

Sorry but I did not understood your last comment about 1-year data  🤔

Yos