19 Aug 2023 03:53 PM
how can i query the number of user actions evolution in some timeframe like last 20 minutes in dynatrace classic dashbard using usql ?
19 Aug 2023 05:19 PM
Hi @Iplinsky
One of the limitations of usql is Only closed user sessions can be queried. Live user sessions aren't taken into account.
And session under 35 minutes are not marked as closed.
For your kind of requests we use builtin:apps.web.actionCount.category metric
HTH
Yos
20 Aug 2023 10:26 PM
i would like something like this but per minute and not all in one
21 Aug 2023 08:51 AM
Hi @Iplinsky
The product idea for this request was mark as not planed 🤔
Yos
20 Aug 2023 10:21 PM
yes, i would like to have in usql how can i see the user actions per minute from applications, like in applications page
21 Aug 2023 09:04 AM
@Iplinsky it's not possible using USQL. USQL is not designed for realtime data in contrary to metrics. You have to use metrics (Data Explorer widget) for this. If you need some further triage (such as the number of actions with some user action property value), you need to define your own application metrics.
USQL is designed for analysis of user session data, not for realtime data and monitoring. It's a different use case.