06 Jun 2022 09:01 AM - last edited on 30 Nov 2022 05:33 AM by AgataWlodarczyk
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?
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'.
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:
Solved! Go to Solution.
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.
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
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:
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?
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.
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!:
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?
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.