Why does my Conversation Summary Volume table has duplicate columns?

Document ID : KB000074336
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
NFA Custom Reports which include the "Conversation Summary Volume Table - Total" may have two columns named "Total From". 
 
User-added image

The last column name should be "Total To/From", which would be a total of all conversation data over the time period of the report.
Environment:
NFA All Versions
Cause:
Misnamed column in the database.
Resolution:
1. Open a command prompt on the NFA Console server and run:
mysql reporter

2. Run the command below to update the column names:
update control_properties set propertyValue='Total To/From' where controlid=40067 and propertyname='Column5_HeaderFormat' and propertyValue='Total From';

3. Refresh the page and note that the last column should now say "Total To/From".
User-added image