topic Re: Count is return unique count problem in App Development

Count is return unique count problem

wuming79 — Wed, 22 Dec 2021 15:42:54 GMT

Hi,

I have a table as below:

IP	start sequence
1.1.1.1	-
2.2.2.2	1
1.1.1.1	1
3.3.3.3	2
1.1.1.1	2
4.4.4.4	3

I just wanted to count the number of IP that appears on the table using SUM(IP) but the table I get is unique count instead.

IP	SUM(IP)
1.1.1.1	1
2.2.2.2	1
3.3.3.3	1
4.4.4.4	1

I'm not sure why am I getting this issue... when I uncheck show start sequence NULL, I can see there are 2 x 1.1.1.1.

Re: Count is return unique count problem

tomasz_tru — Mon, 22 Oct 2018 08:05:02 GMT

use: COUNT(IP)

Re: Count is return unique count problem

wuming79 — Mon, 22 Oct 2018 08:23:39 GMT

Hi,

same issue. it will count as unique. I'm not sure if this is affected by other tables that has IP column? I actually has 4 tables that are linked by "IP" and they all have a key icon beside them when I look at the Data Model Viewer.

Re: Count is return unique count problem

wuming79 — Mon, 22 Oct 2018 11:00:07 GMT

Hi, I found the problem. I had to rename one of the fields because the field I am counting is a key and count the new fieldname.