Hi,
This is a simple Area Line Chart mapping cities and states. A city name might appear in multiple states. While this is very straight forward, I am confused by two things. What is the difference between big circles, small circles and bars, all to represent the same quantities?
Why does the visualization change from
“SHOWING TOP 200 IN CITY AND BOTTOM 25 IN STATE” to
“SHOWING BOTTOM 200 IN CITY AND BOTTOM 25 IN STATE” when I reverse the alphabetization of the city name? is that just an artifact of alphabetizing? What does that even mean–top 200 in city? bottom 25 in state? The underlying data set only has city names that might appear in up to 4 states.
Hope this is easy. Thanks!
Hi @Coliven Thanks for reaching out, and welcome to the QuickSight Community! 
I am pinging one of our SAs to make sure your question gets a reply on Monday if we don’t hear back from the community before then. Thx!
1 Like
@Coliven ,
I believe big dots and small dots are because of the overlapping colors assigned to different dimensional values in State.
On the order : Ascending mapped for Bottom . Descending mapped to Top
Top 200 Bottom 25 : There is a limit in the number of data points that’s visible in the chart. When the data is above this point, it will fall in to the others category.
Few screenshots based on different X and Group/Color data points (20 X-Axis Data Points )
Format Visual : X-axis ( Number of data points to show )
(2000 X-Axis Data Points , Group/Color 1)
(1000 X-Axis Data Points , Group/Color 10)
Kind regards,
Koushik
1 Like
Hello Koushik,
I believe you are right! Thank you so much for taking the time to expand the ways to visualize this based on number of data points to show. Very helpful.
Best,
Catherine
1 Like
