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