I have a lookup table in which I have area code and longtitue and latitude and other details, at the other end I have area code in my index also.
So, I have made my query with lookup table to match for all the area code and show a "MAP" graph.
I am doing ..
index=indexname areacode | lookup coordinate.csv areacode as CCC | geosats global....=0 latfi....=latitute long...=longitude count by CCC
My output is having something like this :
geobin longitue latitue 200 201 202 304 501 505
blahblah blah -blah 1 1 1 4 1
now, the problem is in my result set only 6 area code is showing 200 201 202 304 501 505 ( just as above example ) , Even though I have more data matching up with lookup table, those Areacodes are not showing, like it is not showing 210 , 312 area code.
Please help me why I can't see these area codes in the statistics even though I have data for these two.