I am facing an issue updating my excel table. Currently, I designed my dashboard such that it will take in this Question Master Table. The changes made for this table is minimal but there is a chance that they might want to change the Question Label. I use isValue as an indicator that the Question is VALID/INVALID.
The Question 2 is changed.
The new Question has been set and the isValue is 1.
The real problem i am facing is when i reload on my dashboard. For the Academic Year 2015, it is showing the correct Question Label.
But it does not show the previous Question Label for the previous Academic Year from 2010 to 2014. Initially i thought using Academic Year as an identifier would be good but the changes made on the Question Master table will only take place once in a few years. Hence, inefficient. I can afford to make more columns on the excel sheet because it will not affect the dashboard. Any ideas how i can overcome this?