I have a vertical stacked chart in quicksight. it has a score from 0-1000. Anything above 500 is a pass, anything below is a fail. Before grouping by a calculated field named TestScoreGroup (groups them into pass/fail with colors green/red), it shows hundreds - thousands of data. As soon as i group it, the data being displayed reduces to about 50 bars in the chart. Why does grouping/coloring data reduce the amount being displayed?
can you share some more details (screenshot)?
I will send in one moment, just have to remake it. I just realised under the title it says
“SHOWING TOP 50 IN STUDENTID AND TOP 2 IN TESTSCOREGROUP”
Is there a way to show all instead of the top 50?
Is there a filter on the visual?
There is, but its to remove score which are null/negative
Heres an image of it
Heres an image of it before grouping
@HarveyB-B what is on the axis? x = “TestScoreGroup”, y = “Test Score” and Value = “Case Score”?
x axis = studentid, y axis(value) = test score, group = TestScoreGroup
back to the “50” question.
You can defined the number of data point. But there is a limitation based on the number of fields being in the visual.