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