topic Re: key request in Open Q&A

How to view all key requests?

Lwl — Tue, 13 Jun 2023 13:36:01 GMT

How to view all key requests defined in the environment. And then I can export it

Re: key request

Lwl — Thu, 08 Jun 2023 02:01:18 GMT

It is best to have a corresponding service name

Re: key request

AntonPineiro — Thu, 08 Jun 2023 07:28:54 GMT

Hi,

One option can be from multidimensional analysis:

Filter only key requests.
Add service name in split dimension.
Going down right and Export table.

Or using data explorer with table visualization, for example this query:

builtin:service.keyRequest.response.time:splitBy("dt.entity.service_method"):sort(value(auto,descending))

Best regards

Re: key request

Lwl — Thu, 08 Jun 2023 08:06:24 GMT

Thank you very much, but this does not reach the final result I want. What I want is the key request of the whole environment, and I can only get a part of it through your method, which does not meet my expectations. Thank you very much for your reply.

Re: key request

Lwl — Thu, 08 Jun 2023 08:14:52 GMT

Thank you very much, your following example is what I want, if can attach the corresponding Srevice name, it would be best

Re: key request

AntonPineiro — Thu, 08 Jun 2023 08:53:15 GMT

Hi,

You can add "parents" and service name appears in another column:

builtin:service.keyRequest.response.time:splitBy("dt.entity.service_method"):sort(value(auto,descending)):parents

You can export it as CSV:

Best regards

Re: key request

Kenny_Gillette — Thu, 08 Jun 2023 12:12:51 GMT

create a dashboard. I did this and copied the dashboard to each environment. i have added mine dashboard to this so you can use.

Re: key request

Lwl — Fri, 09 Jun 2023 07:47:42 GMT

Thank you for your reply. Thank you

Re: key request

Lwl — Fri, 09 Jun 2023 08:12:21 GMT

What a great dashboard you made! Can you share something else? Look forward to it

Re: key request

Kenny_Gillette — Fri, 09 Jun 2023 11:20:44 GMT

Share something else? what you need?

Re: key request

Lwl — Mon, 12 Jun 2023 02:16:28 GMT

Sorry for not replying to your message in time. You made a great dashboard. I don't have any specific needs at the moment, I just want other refined and simple dashboards. Of course, if it's too much trouble, don't. Thank you very much for your reply.

Re: key request

Kenny_Gillette — Mon, 12 Jun 2023 12:14:45 GMT

No worries, just trying to help where I can. They do have a lot of dashboards pre built that you can pull at https://dynatrace.github.io/BizOpsConfigurator/#home

I have used that for many dashboards.

Re: key request

JhonKenneth — Thu, 06 Jul 2023 08:18:27 GMT

Is this showing only the top 100 key request?

Re: key request

Lwl — Thu, 06 Jul 2023 08:35:00 GMT

Yes, this method can only see 100, but the text at the bottom can see all of them

Re: key request

Lwl — Thu, 06 Jul 2023 08:36:29 GMT

builtin:service.keyRequest.response.time:parents:splitBy("dt.entity.service_method","dt.entity.service"):sort(value(auto,descending)):limit(500)

Re: key request

zietho — Thu, 06 Jul 2023 12:35:01 GMT

no, if there is no limit attached (in advanced mode) for a table then there should no limit apply and the result should show all tuples of service + request pairs. Potentially 1000+
e.g. I removed it here and the count jumped from 20 to 48. So in this environment, I have 48 defined key requests.

Re: key request

JhonKenneth — Fri, 07 Jul 2023 07:38:17 GMT

Is there a way to adjust the limit? currently maximum is 100 as defined.

Re: key request

zietho — Fri, 07 Jul 2023 08:33:16 GMT

TLTR: please switch to Table or Honeycomb, then you can change/remove the limit.

These are the two we believe are scalable with 1000+ items. All others would either suffer in terms of GUI performance or would often (e.g. graph) not make sense with more than 100 different lines, slices,... you would just not perceive any differences anymore.

A graph with 10 metrics (limit) would result in 1000 lines, which means you see almost nothing anymore. The visualization becomes meaningless.

Re: key request

Lwl — Fri, 07 Jul 2023 09:36:11 GMT

Re: key request

Kenny_Gillette — Fri, 07 Jul 2023 12:01:31 GMT

Are you on managed? I am guessing so and less than 1.266?

1.266 removes this limit.

Managed release notes: https://www.dynatrace.com/support/help/whats-new/release-notes/managed/sprint-266

SaaS release notes: https://www.dynatrace.com/support/help/whats-new/release-notes/saas/sprint-266

Data explorer and dashboard table enhancements

Platform | Data explorer

We have made the following improvements to the table visualization:

Columns: In the Data explorer table visualization, use the checkboxes in the Columns section to enable and disable the display of columns. These selections are reflected in the resulting dashboard tiles.
Rows: In the Data explorer, you can remove the limit to see more than 100 rows.
Pages: In the Data explorer and resulting dashboard table tiles, tables are automatically paginated. Use the controls under the table to page through tables.