Subtotals for distinct count

Janina Herde

When using the distinct count aggregation function in Board 12, no subtotals are shown in data views.
Would be great to have subtotals for aggregation functions when using multiple row entities.

Product Management Team

Thank you for sharing your idea, Janina. We appreciate the time and effort you put into crafting your suggestion. Great news, you can use the Nexel function for this idea. Here's a link to find out more on this: https://www.boardmanual.com/2021/summer/capsules/screens/2_Objects/DataView/nexel-data-view.htm?rhhlterm=nexel&rhsearch=nexel

If this doesn't solve your need, please clarify and share your use case with a screenshot perhaps and we can help further!

Janina Herde

Meanwhile I used the workaround to have a simple algorithm (b=a) on that block and set it to sum instead of calculated. This way you can see the sum of the aggregated block (distinct count) in the subtotal rows. However I think this should be possible in the aggregated block (a) itself! Can you please forward this to your lab?

Stefan Rappen

Dear product management team, as this workaround does not work for another customer, i share an example. Maybe there is a way?

Subtotals missing.docx

Samir Jones

Hi @Stefan Rappen,

Have you enabled these settings?

In Data view layout

In Screen, when you select the Data view

And in case you don't want the extra Total row, you can deactivate in Screen, when selecting the Data view

Stefan Rappen

yes. These settings are enabled. No values displayed