Why does grouping/coloring data in a vertical stacked bar chart reduce data being shown?

Question & Answer
1

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?

2

@HarveyB-B
can you share some more details (screenshot)?

3

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?

4

Is there a filter on the visual?

5

There is, but its to remove score which are null/negative

Heres an image of it

image
image1242×328 20.2 KB

Heres an image of it before grouping

image
image1227×347 22.4 KB

6

@HarveyB-B what is on the axis? x = “TestScoreGroup”, y = “Test Score” and Value = “Case Score”?

7

x axis = studentid, y axis(value) = test score, group = TestScoreGroup

8

Hi @HarveyB-B
back to the “50” question.

grafik

You can defined the number of data point. But there is a limitation based on the number of fields being in the visual.

BR