Number of distinct dimensions (rows)

[elenaperez]

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.

[gbaudart]

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?)

[elenaperez]

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 · Accepted solution]

Hi @elenaperez ,

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

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

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 :

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

[Edouard]

Hello !
I have the same problem, i want to be able to do a distinct count on multiple id and your method is only applicable for the first 100 values. Moreover, i don't have the possibility in calculated service metric to do sum of values on field "Value Aggregation", i have only choice on "Single value". Do you have another solution please, i really have this need to create dashboards.
Thanks.

[elenaperez]

Hi! What we did in the end was use Traces on Grail. You can do fetch spans and then use the DQL function countDistinct for the UUIDs. However, I would recommend using buckets because otherwise it can be quite expensive.