topic USQL dynamic timeframe inside query in Real User Monitoring

USQL dynamic timeframe inside query

y_buccellato — Tue, 17 Mar 2020 15:32:09 GMT

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]

Re: USQL dynamic timeframe inside query

skrystosik — Tue, 17 Mar 2020 17:58:26 GMT

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

Sebastian

Re: USQL dynamic timeframe inside query

y_buccellato — Wed, 18 Mar 2020 09:55:37 GMT

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]

Re: USQL dynamic timeframe inside query

Yosi_Neuman — Wed, 18 Mar 2020 12:56:56 GMT

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