DQL Dashboard queries for Service request or End points

[ManoharSomineni]

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.

[p_devulapalli]

Please try something like below

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

[ManoharSomineni]

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.

[p_devulapalli · Accepted solution]

@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

[ManoharSomineni]

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.

[ManoharSomineni]

[ManoharSomineni]

My result after executing the query

[p_devulapalli]

Select DQL and paste the query in query section