topic count(field) is duplicating rows in App Development

count(field) is duplicating rows

mtabernad — Sat, 16 Nov 2024 19:04:42 GMT

Dear community,

I hope someone can help me since this is driving me crazy.

I have a simple table with all the fields of the model which are 9. After some date filters, only one row show up in the table but my kpi shows '2' as value.

My script is:

I would appreciate some help please!

Thank you in advance

Re: count(field) is duplicating rows

sunny_talwar — Thu, 20 Feb 2020 16:52:54 GMT

The table only displays unique combination of fields listed in it. That doesn't imply that Count() would equal = 1... When you see a count = 2, it means that there are two rows where the listed dimensions appear twice. Count(DISTINCT...) will give you 1

Re: count(field) is duplicating rows

mtabernad — Thu, 20 Feb 2020 17:03:34 GMT

Thanks for your quick reply. I get your point! I understand now!