Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I use a simple count function on the following dates, why does the KPI total "20", instead of 25? I feel like I skipped Kindergarten or something...
| 4/30/12 |
| 4/30/13 |
| 4/30/13 |
| 4/30/14 |
| 4/30/14 |
| 4/30/14 |
| 4/30/15 |
| 4/30/15 |
| 4/30/15 |
| 4/30/15 |
| 4/30/16 |
| 4/30/16 |
| 4/30/16 |
| 4/30/17 |
| 4/30/17 |
| 4/30/17 |
| 4/30/18 |
| 4/30/18 |
| 4/30/18 |
| 4/30/19 |
| 4/30/19 |
| 4/30/19 |
| 4/30/20 |
| 4/30/20 |
| 4/30/20 |
I apologize if this is posted in the wrong Forum category - Thanks!
Is this a key field connecting two tables? If it is then check this following blog: Count or Count distinct?
