How to create customchart for fronetend(client) time?

[sureshKumarK]

Hi, I am looking for frontend time(client time) to plot in a custom chart. Please let me know what is the metric need to select (if there is one) Please see the screenshots below, I am able to capture Network time, Server time, the only thing missing here is Frontend time (screenshot#2)

Screenshot#1 - this is from user actions

Screenshot#2 - Below screenshot is from custom chart, can't find the metric for frontendtime

[ChadTurner · Accepted solution]

@Suresh K., YES! this can be done via the User Session SQL:

Let me know if you need a hand with this.

[sureshKumarK]

Thanks @Chad T., I am able to do it using USQL. Could you let me know how I can plot it in a custom chart and eventually pin that in Dashboard? I am specifically looking for an option for Frontendtime here, could you let me know if there is one available?

[ChadTurner]

for this you will need to do it from the User Sessions Section of Dynatrace. You will also be able to pin the results to the dashboard of your choosing. You can have multiple types of graphs as well.

[ChadTurner]

here is a sample of one:

[sureshKumarK]

thanks @Chad T., so User session query is the only place to build this? challenge with that is, I can't drill down to the user actions from the results. If I am able to plot the same using custom chart, I can do the drill-down directly from the chart by filtering with Dimension. And can't do the same from User session query page. So, question is, since I am able to find network contribution, Server time from custom chart metrics, why I am not able to see one for Frontend time? I am not sure if there is an inbuilt metric available for this. Appreciate if you point me in the right direction. Thanks, Suresh.

[ChadTurner]

if you really want to be able to jump right into the user session from the USQL results, that can be done quite simply. the graph will also provide you a table under and you can filter/sort/group/list by user.

[sureshKumarK]

is it? let me try

[ChadTurner]

The magnifying glass allows you to jump right into that session that is providing you with the metric:

[sureshKumarK]

@Chad T. I just developed this query, not able to find the magnifying glass at all.

Saas Version 1.191. Am I missing something here?

[ChadTurner]

yeah, let me work it a bit on my end and see if I can get it to pop up

[ChadTurner]

SO it appears that once we go a GROUP BY, the system removed the link to the user session.

[sureshKumarK]

Hmm. @Chad T., see the below values, these are captured from the out of the box available metrics in Dynatrace. Similar to this, I am wondering why I am not able to find the metric for Frontend time? If there is one available, could you help me in providing that. If there is no metric available for that, appreciate if you give suggestion on how to build a custom metric for Frontend time?

[ChadTurner]

as of now, the only way to do this is via the USQL - you could put in a RFE for this to be included in the custom charts. But for now you will have to resort to making a custom tile via the USQL statements