Wrong values displayed in bar chart

[lailarhc]

Hello.

This is probably a dumb problem, but I just can't seem to find the right expression to display the values I want on my bar chart.
Here's my expression for my bar chart: =Count(Aggr(Count(Curso), Servidor, Ano))

 

It should show that 2 courses (curso) have been taken in 2021, but it's only showing 1. 

Here too, it's only showing 1 instead of 6.

Why is this happening?

Thank you in advance.

[sunny_talwar]

Why don't you just use Count(Curso) here?

[lailarhc]

It also gives me a wrong number: way higher than the actual count.

This should amount to 4, but it's showing 540.
I'm using Count(Curso) here

[sunny_talwar]

How about Count(DISTINCT Curso)??

[sunny_talwar · Accepted solution]

Oh I see why that won't work... try this

=Sum(Aggr(Count(DISTINCT Curso), Servidor, Ano))

[lailarhc]

It worked!
Thank you 🙂