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.
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 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.