cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL dynamic timeframe inside query

y_buccellato
Advisor

is it achievable to put a dynamic (relative) timeframe in my USQL query?


[I mean not as filter as Global TimeFrame in the dashboard or a filter in the single dashlet]

3 REPLIES 3

It’s not supported right now to put it in query. But you can use this option:

Sebastian

Thank you Sebastian, very kind of you.


One more question: in your experience, if I select the "Dynamic time-frame shift", will this option be inherited in the corresponding api v1 call?

[I'm trying to achieve a scheduled usql-api call via power query on excell and maybe I'm overcomplicating things]

Hi @Yann B.

In case of Rest API you need to specify the time in epoch format , so any how you will need to calculate it and while calculating subtract the right amount of ms you want....

HTH

Yos


dynatrace certificated professional - dynatrace primer partner - Matrix Soft Ware Division - Israel