topic Re: Filtering by Request Attribute Values in Data Explorer in Dashboarding

Filtering by request attribute values in Data Explorer

swin12 — Wed, 24 May 2023 14:38:48 GMT

Question:

Using data explorer, I currently have dashboard tiles that show the average processing time of a service and its key requests. Can I filter these tiles further using a particular value of a request attribute?

For example:
The possible values for the request attribute 'flow' are 'foo' and 'bar'. Can I use data explorer to show me response/processing time data for only the requests that:

A) Have the request attribute 'flow'.
B) Have the value of 'bar'.

Background:

I have a service that serves several requests. I have marked the requests I'm interested in as key requests. I have configured a request attribute for the key request that indicates which one of our (many) business flows generated the request.

Currently, I have added a tile to my dashboard that shows the total processing time of the key request(s) as an average. However, I'd like to split this tile by an extra dimension of 'flow' (the name of my request attribute). The request attribute doesn't seem to be an option in data explorer when I configure the split:

If I try to split the data at the service level, there does seem to be a filter available for the request attribute, but this doesn't seem to support the value of the attribute. It only seems to refine the query by which requests contain that particular attribute key:

I can seem to get the result I'm looking for using multidimensional analysis, however:

Thanks!

Re: Filtering by Request Attribute Values in Data Explorer

mgome — Mon, 06 Jun 2022 16:34:13 GMT

Request attributes are not part of the metric dimensions out of the box. You can create a calculated service metric for the request and add the request attribute in the "Split by dimension" section of the calculated service metric.

Re: Filtering by Request Attribute Values in Data Explorer

techean — Tue, 07 Jun 2022 04:24:38 GMT

Create calculated metrics | Dynatrace Docs use it as suggested by @mgome , as you said split by service result in data explorer is not bringing you the expected value you can go ahead with calculated metrics

Re: Filtering by Request Attribute Values in Data Explorer

swin12 — Tue, 07 Jun 2022 18:22:23 GMT

Thanks @mgome and @techean. This seems to make sense... Some follow up questions/comments, if you don't mind:

Before I create the calculated service metric, I suppose I could configure the MDA view in one of two ways:

Showing results for all values for the 'flow' attribute:
Filtered by a specific value for 'flow' (i.e. 'foo'):

Does the presence of a filter (such as filtering on a specific 'flow' value) in my MDA query/view have an effect on the the calculated service metric that I create? I suppose for my use case, I would not want to apply a filter for a specific value. Idea being that the calculated service metric can be split by dimension in Data Explorer? Something like:

Unfortunately at the time of writing this, I don't have any data to work with... or else I'd test this on my own. Would this data explorer query allow me to filter on specific values for the 'flow' attribute?

Re: Filtering by Request Attribute Values in Data Explorer

dannemca — Tue, 07 Jun 2022 19:35:42 GMT

The great idea here is to make the request attribute as default dimensions automatically on the builtin service metrics. That will help a lot.

I have some calc metrics created to do these queries, but the work get confusing when you have needs to cross filter these attributes, since you can choose only one dimension for these calc metrics.

I will mark this thread to see if you or someone else got luck with this task.

Re: Filtering by Request Attribute Values in Data Explorer

techean — Wed, 08 Jun 2022 04:37:38 GMT

the presence of filter will not have any additional effect on your calculated metric. Ideally data explorer will allow you to filter specific value based on your request attribute.

Re: Filtering by Request Attribute Values in Data Explorer

swin12 — Wed, 08 Jun 2022 20:16:59 GMT

Now that I have some data coming in, I can confirm that using the calculated service metric in Data Explorer, I can filter by the value of the request attribute using the 'Dimension' filter. Thanks!:

Re: Filtering by Request Attribute Values in Data Explorer

gversluis — Wed, 30 Nov 2022 14:01:40 GMT

Unfortunately, this is not a solution. Calculated metrics require DDU's. The data is already in Dynatrace, why should we pay twice just to get it visualized properly?

Also (after looking into this in more detail) this doesn't always apply. What about requests that are not within scope of an application?

Re: Filtering by Request Attribute Values in Data Explorer

clemens_hoffman — Thu, 13 Apr 2023 11:08:53 GMT

Hello,

I stumbled over the same issue. I want to filter requests based on the request path in a dashboard. So I created a Request Attribute for the request path, and excluded /health requests (I do not want to chart them).
The request attribute works fine: It is added for /api/* requests, but not for /health requests.

However, the Request Attribute filter in Data Explorer is totaly useless, it does not even filter out those requests which do not have the Request Attribute. Moreover, I cannot create a calculated service metric, because the request Attribute selector is empty.

Can someone help or explain why it's not working as expected?

Best regards

Clemens

Re: Filtering by Request Attribute Values in Data Explorer

Julius_Loman — Mon, 17 Apr 2023 19:34:13 GMT

You are not defining the calculated metric correctly.

First you need to defined the base metric - such as response time or request count.
Then define the conditions which are treated as filter (to narrow down requests counting toward the calculated metric)
Finally you need to use the request attribute as the split by dimension: