How can I make a table showing data within 5 days after a given result?

I have this table of Test Scores and I want to create a new table that displays test scores following an “A” score within the next 5 days after the “A” was received.

Basically what I am trying to do is to see if test scores are influenced by timing shortly after an “A” grade.

Does it have to be a new table? You could do with a filtered view:

Thank you. This may work, but I am also trying to graph the results as a scatter chart (or line chart).
It seems as though you can only graph from the original table and not the secondary filtered table; and applying the same filter formula to a graph of the original table does not actually filter the data displayed in the graph.

The table view is filtered to show those rows with non-blank results:

You can apply the same filter to your chart and it should work.

1 Like

Wow, I can’t believe I missed that.
Thank you so much for your help.

2 Likes