What is the recommend way to update historical data?
We see an issue in the workspace reports, due to misspelling at website the same record added multiple times. something like below, I need to update second row value which is "sample reQuest" to the "sample request" to get the actual count.
| sample request | 5 |
| sample reQuest | 4 |
What is the best way to update the second record value. is there any way to sum of both without updating the record?