topic Number of distinct dimensions (rows) in Open Q&A

Number of distinct dimensions (rows)

elenaperez — Tue, 02 Jan 2024 08:35:50 GMT

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.

Re: Number of distinct dimensions (rows)

gbaudart — Fri, 05 Jan 2024 20:51:18 GMT

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

Re: Number of distinct dimensions (rows)

elenaperez — Mon, 08 Jan 2024 08:22:40 GMT

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.

Re: Number of distinct dimensions (rows)

gbaudart — Mon, 08 Jan 2024 09:58:59 GMT

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

Re: Number of distinct dimensions (rows)

Edouard — Mon, 05 May 2025 14:46:32 GMT

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.

Re: Number of distinct dimensions (rows)

elenaperez — Mon, 05 May 2025 16:09:29 GMT

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.