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; } } }

Problem with distinct aggregation count and difference + and &

fsi

I'm new at Birt and couldn't make/find/how to do the distinct in my table, below Is what I have, which is duplicating the rows and I wanted to make it distinct to make 2 rows.
 
 city - age - local - **** - count
BH - 30 a 39 - Exit Market - Female - 2
BH - 30 a 39 - Exit Market - Female - 2
 
CTB - 16 a 29 - Exit GYM - Male - 1
 
The "count" is my Aggregation with function count and aggregated group by table group below.
<pre class="_prettyXprint _lang-">
row["city"]+row["age"]+row["local"]+row["****"]
</pre>
Which, shouldn't duplicated it? If I use separately my query with group by and count, it doesn't duplicate.
And another thing, I don't understand the logic of using & and + to count it correctly. I mean, if I use & on my expression, it will count to 3(record) and with +(concat) will count it right above.
 
Thanks.

Find more posts tagged with

Comments

fsi

I figured it out. Just need move the row into group table. Didn't notice that in the table was written: Group Header/Footer Row.