Forum Discussion
Value not stable
- 10 years ago
That was the solution
I downloaded the data from the example and created a simple table like yours and I see Nebraska as 10 in rank. What is interesting is that all of my numbers match yours except for Nebraska and both of the Nebraska numbers that I have are half of yours so it appears as if you have somehow doubled Nebraska's numbers but not sure how you did that, perhaps somewhere in your query when you were bringing in the data?
- GD6110 years ago
Helper III
Hello,
I found that Nebraska appears twice in my data base.Do you find the same issue ?
- GD6110 years ago
Helper III
I noticed that in the original database the name Nebraska appears tow times. One with the abbreviation, the other without.
I'll need to eliminate several rows at the bottom :
- GD6110 years ago
Helper III
That was the solution
- Greg_Deckler10 years ago
Community Champion
Nope, only appears once in mine. That would explain it though, the default aggregation is SUM so it is adding together both of your entries, hence why your numbers for Nebraska are twice as high as mine.