Count

[#1]

I have done this kind of statistics several time, but this time I don't understand what I'm doing wrong. I would like to count the number of suppliers so I'm using the formula =count([Ragione Sociale Fornitore]) that I've always used. The point is that in case the supplier is repeated, it is counted only once, while I want to be counted twice.

What I'm doing wrong???

[mdmukramali]

Dear,

can you attach the sample apps.

[anandathome]

You will have to remove Column2 and Column3 from your dimensions.

Then you will get the correct count.

"Numero .." and "Data ..." dimension fields are showing the details.

To make count aggregate to first field, remove the other two fields from dimension list.

[gandalfgray]

Hi Irene

If you are interest in the number of suppliers, I think you have got the correct result: 15.

18 is not the number of suppliers, as you can see some are duplicated.

18 may be the number of [Numero doc...], so try a count([Numero doc...])

[MK_QSL]

Provide sample data file....

[#6]

I've already tried the Count(num_doc) still not working...

[#7]

The chart is already opened and filtered

[er_mohit]

have you tried like this

aggr(nodistinct count([Ragione Sociale Fornitore]),yourdimension field)

[#9]

I've provided data sample in the answer to @Mohammed Mukram Ali

[alexandros17]

Mi spiace ma non riesco ad aprire il tuo documento ...