Aggregate Data in a Field

[Anonymous]

I have a FIELD named CallDescription, which has successful descriptions (script placed) and unsuccessful descriptions  (ie do not want[reason1],do not want[reason2], do not call again, wrong number)

Is there a way to aggregate the unsuccessful descriptions, so I can show charts that compare successful VS unsuccessful calls?

[swuehl]

Chris,

probably yes, assuming that not both description types are completely showing free text (then you probably need some kind of sentiment analysis).

I' not sure what you mean with 'script placed', is this already one of / the only successful description?

You could create a table of your defined successful descriptions:

DESCTABLE:

MAPPING LOAD

F1, 'Successful' as F2

INLINE [

F1

script placed

software installed

just success

];

LOAD

CallDescription,

applymap('DESCTABLE', CallDescription, 'Unsuccessful') as Status,

...

from Table;

Thus, if all successful descriptions are listed in the mapping table, you will create a Status field only having two possible states, Successful and Unsuccessful from that.

This will allow you to directly compare your successful vs unsuccesful calls.

Hope this helps,

Stefan