nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Distinct count total

Maik Burghardt

Hi there,

i created a few blocks which are you using aggregation distinct count on an entity. when i am adding multiple entities into rows i don't have totals? How can i fix this?

Secondly the Grand Totals don't make sense. any idea why?

maik

Find more posts tagged with

Dataview

Accepted answers

All comments

Robert Barkaway

Hi Maik, can you please show me your layout and the structure of the cube you're trying to use for the count?

Maik Burghardt

Hi Robert, does this help?

Robert Barkaway

Thanks Maik, can you also show me the entities you have on the axes and the structure of the cube itself please?

I tried creating a similar example and it seems to work fine for me, mine uses a cube dimensioned by 4 entities, 3 of which I'm using in the layout and then I'm counting the fourth

the results of mine make perfect sense, the count matches what I've got values for in each month and the total will be the number I've got a value for in the total

Maik Burghardt

Here you go. The counting itself is not the issue, it is more the subtotal and grand total.

Robert Barkaway

Okay, I'm not sure that's going to work - from what I can see it doesn't support down totals for aggregations. Mine shows no down totals, I'm not quite sure why yours seems to show a total but not a Grand Total to be honest, that's not what I get even trying a similar thing with an algorithm block

The only down total I get is on the Cube block, not on the Aggregation block or the algorithm that references it.

Maik Burghardt

anyone from the Board team a thought or idea?

Björn Reuber

Hello Maik,
about the aggregation function, here according to my knowledge if you have multiple entities by row the donwtotal is not supported (due to performance reasons).
For the Algortim, I assume Total is set to total and not to calculated.

Regards

Björn

Maik Burghardt

Hi Bjoern,

ok at least an explanation.

regarding the total - correct it is set to total. however the total doesn't add up when you make he math.

The total below with only one entity is not matching the actually numbers. the block is set to total when it is set to calculated it shows nothing.