Hi Karen -
It good that you are asking this question before you make the viz
I'm not an educator but I see a lot of questions that come up about tracking admissions, projects or other programs that have events, dates and status ratings.
Most of the questions arise from the way the input data is structured - the common approach is to track the program using a table like and excel sheet :
and that creates problems with the analysis of the data and updating because each "column" is a separate dimension/measure - e.g there is no relation between the admission dates and application dates - your viz ends up looking like this
Where each Blue Pill on the rows shelf is an discrete value -
To update the data you need make the change to the individual value and reload / replace the entire sheet
A better way to structure your data is to recognize for each aplicant you have 3 separate types of data - ID's that are unique to the applicant, followed by the PHASE that the applicant is in in the process a DATE and a STATUS/Value
Which can result in a viz like this
Additionally to update this data you would create an update file with the same columns which would ave the new data
And Union them into your existing data set
Just some thoughts
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.