Hi @sushant_ln1711 ,

Perhaps you can try restoring the order by switching back the options or restoring the survey version to the version before the accidental switch, if there was no response collected after the accidental switch.

Or you can try to batch edit those data set to the current option sequence.

Hi @Chee Heng_SZ ,

There have been plenty of responses after the switch. I was thinking of replacing the older data with the current data (switched data). Is there a process to do that?

Hi @sushant_ln1711,

Since the switch is just reversing of the order, you can manually batch edit the records from option 1 to option 5, option 2 to option 4, option 4 to option 2 and option 5 to option 1.

1) Go to "data & analysis" tab.

2) select the option 1 records between Aug’23 to 8th March’2024

3) click the edit icon

4) select required field question that you want to edit and select the value of the reverse option number and update.

5) repeat step 2 and 3 for the other 3.

6) review and publish.

Or you can try exporting out the records from Aug 23 to 8 Mar 24 to edit in excel before importing it back in.

https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/download-data/export-data-overview/

Thanks Chee Heng_SZ, for the detailed steps. Really appreciate it. I am being double sure now  if I choose the data from Aug’23 to March’24 my current very dissatisfied responses will be seen as very satisfied and fairly dissatisfied as fairly satisfied?

Also, the data for Feb’ 24 which I am doing now is showing this ,

Should I revert it to the previous one?

Hi @sushant_ln1711 ,

If you did go through the steps one by one and  didn't 'select all and edit all' at once, it should work. If you are afraid of the data having issues, you can also do a same sample test somewhere else to verify if the suggestion work.

As for the "revert" screenshot that you have shown, it is likely that there was some editing done for the 100 responses and you click on the shaded corner to revert.

You can look at this supporting documentation to understand editing of response better:

https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/response-editing/

Just to confirm, This is my option 1(Very Satisfied) which will be changed to option 5(Very Dissatisfied)  after hitting the update?

Just to confirm, This is my option 1(Very Satisfied) which will be changed to option 5(Very Dissatisfied)  after hitting the update?

Hi @sushant_ln1711 ,

The value you select here is the value you want it to become. In your screenshot, you are setting the current field's result to be Very Satisfied.

If the original survey result is option 1(Very Satisfied) and the accidental switch cause it to become option 1(Very Dissatisfied), manual edit it to value of option 5(Very Satisfied) will help to fix 1/4 of the issue. Then, you can continue to edit with the other 3 options (2 to 4, 4 to 2 and 5 to 1) to resolve the problem.

Thank you @Chee Heng_SZ  :)

Hi @Chee Heng_SZ ,

Just one last question, sorry. For one of the questions I selected the very satisfied and very dissatisfied change to very satisfied. For the rest of the options for the same question, how will the change reflect? if I click on fairly satisfied then fairly dissatisfied changes to  fairly satisfied? 

Hi @Chee Heng_SZ ,

 

Just one last question, sorry. For one of the questions I selected the very satisfied and very dissatisfied change to very satisfied. For the rest of the options for the same question, how will the change reflect? if I click on fairly satisfied then fairly dissatisfied changes to  fairly satisfied? 

 

Hi @sushant_ln1711 ,

As mentioned in the previous post, you will need to select the records which you wish to change.

For example, maybe only 10 out of those records affected by accidental switch went from fairly satisfied to fairly dissatisfied, you select the 10 records of fairly dissatisfied, click edit, select field as question and value as fairly satisfied.