cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Number of distinct dimensions (rows)

elenaperez
Dynatrace Participant
Dynatrace Participant

Hello team!

We are trying to get the number of rows (distinct dimensions) in a table obtained from the Multidimensional Analysis. Is this possible?

For example, if we split by a Request attribute called UUID, we would like to get the number of distinct UUIDs captured (with a specific filtered applied as well).
We also tried creating the metric and using the data explorer, but counting the number of rows doesn't seem to be an option.

Any ideas?

Thank you.

3 REPLIES 3

gbaudart
DynaMight Champion
DynaMight Champion

hi @elenaperez ,

In order to think about the possibilities, could you show us the type of results you have with your MDA?

When you created a metric, what exactly did you try? (count? sum?)

Observability Consultant - Dynatrace Professional Certified

elenaperez
Dynatrace Participant
Dynatrace Participant

The configure view is the one in the picture, and the result is a table with the different UUIDs as rows with the respective request count.

gbaudart
DynaMight Champion
DynaMight Champion

Hi @elenaperez ,

From the MDA, to find out the number of dimensions:

gbaudart_0-1704707500604.png

Then you can create a metric from the MDA.
Select the highest dimension number you can have, and "SUM":

gbaudart_1-1704707581195.png

To display the number of dimensions, I have not yet been able to display it in a single value in the DataExplorer. In fact, we cannot do a DISTINCT COUNT.

However, I found a workaround, with Honeycomb, until I found something better :

gbaudart_2-1704707818844.png

let me know if this might be helpful to you.
I keep looking at other solutions

 

 

 

Observability Consultant - Dynatrace Professional Certified

Featured Posts