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?
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 🤔