topic DQL Dashboard queries for Service request or End points in DQL

DQL Dashboard queries for Service request or End points

ManoharSomineni — Thu, 05 Sep 2024 19:58:51 GMT

I am trying to create Dashboard charts of Number of Request chart, Failed request count chart and successful request count chart for storeBooking in BookingService service in Easy Travel application. Kindly provide the Queries for mentioned charts.

I achieved this in Custom Multidimensional analysis, but no option to pin to Dashboard.

Re: DQL Dashboard queries for Service request or End points

p_devulapalli — Fri, 06 Sep 2024 00:59:00 GMT

Please try something like below

timeseries by: { endpoint.name } , {avg(dt.service.request.count),avg(dt.service.request.failure_count) }
| filter endpoint.name == "storeBooking"

Re: DQL Dashboard queries for Service request or End points

ManoharSomineni — Fri, 06 Sep 2024 06:28:09 GMT

Hi Phani, Thanks for prompt response.
Still I don't know where I need to execute that you mentioned Query. Please run the query and if possible please attach the chat snip for better understanding.

Re: DQL Dashboard queries for Service request or End points

p_devulapalli — Fri, 06 Sep 2024 06:49:58 GMT

@ManoharSomineni You would need to use Notebooks as an example to run this query

Here are some links to get some understanding

https://docs.dynatrace.com/docs/observe-and-explore/dashboards-and-notebooks/notebooks

https://docs.dynatrace.com/docs/observe-and-explore/dashboards-and-notebooks

https://docs.dynatrace.com/docs/observe-and-explore/metrics/dql-examples

https://www.youtube.com/watch?v=RAtId3P8C6I

Re: DQL Dashboard queries for Service request or End points

ManoharSomineni — Fri, 06 Sep 2024 06:56:44 GMT

My result after executing the query

Re: DQL Dashboard queries for Service request or End points

p_devulapalli — Fri, 06 Sep 2024 07:09:27 GMT

Select DQL and paste the query in query section

Re: DQL Dashboard queries for Service request or End points

ManoharSomineni — Fri, 06 Sep 2024 07:18:10 GMT

Hi @p_devulapalli ,

I took timeframe of last one week, still it showing only one record. same result getting in the time frame of 1 hour as well.

Re: DQL Dashboard queries for Service request or End points

ManoharSomineni — Fri, 06 Sep 2024 07:19:40 GMT