3 of 3 people found this helpful
Are you trying to return one event for a specific timestamp? Or would you like multiple events returned but not have the grouped in an array?
For a single event we have the Current Value function to return the current snapshot event. To return a single archived event we have the Archive Value function.
Here is a link to the LiveLibrary article for Single-Value functions.
Please let me know if you have any questions about this.
2 of 2 people found this helpful
Compressed and Sampled Data will always return as many samples there are available in the time range you have requested. If you only want a single value for a specific time you need to use the Archive Value Function.
Now if you are talking about the Array that is in the formula bar then there is no escaping this apart from copying your result and Paste Special>Values.