Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
use: COUNT(IP)
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.
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.