Expression not showing values

[#1]

Hi,

Please take a look at the attached example. What I can not figure out is why the Percentage expression only calculates for the first row of each row group. Here, rows are grouped by the "PAIR" values and are visually indicated by alternating background coloring.

[tresesco · Accepted solution]

Use NODISTINCT like:

=count(id)/sum(aggr(NODISTINCT count(id),PAIR))