How to create TA_TYPE as a measure in Calculation View for the Text Analysis Index?

97 Views Last edit Aug 23, 2018 at 11:46 AM 3 rev

Hello,

I have a column table having (ID, String) on which I have created a Full Text Index with configuration 'Extraction Voice of Customer' and set Text Analysis ON.

Post to that, have created a calculation view on top of this full text Index. In which, taken the important columns TA_TOKEN, TA_TYPE as output. TA_TYPE has the value for type sentence or word based on the analysis done in Index configuration as below:

IDTA_COUNTERTA_TOKENTA_TYPE11Eco-FriendlySentiment12Eco-FriendlyWeakPositiveSentiment21Eco-FriendlySentiment22Eco-FriendlyWeakPositiveSentiment31Eco-FriendlySentiment32Eco-FriendlyWeakPositiveSentiment41Eco-FriendlySentiment42Eco-FriendlyWeakPositiveSentiment51Eco-FriendlySentiment52Eco-FriendlyWeakPositiveSentiment61Eco-FriendlySentiment62Eco-FriendlyWeakPositiveSentiment101Performance is goodSentiment102PerformanceTopic103goodWeakPositiveSentiment111Performance is goodSentiment112PerformanceTopic113goodWeakPositiveSentiment121Performance is goodSentiment122PerformanceTopic123goodWeakPositiveSentiment131Performance is goodSentiment132PerformanceTopic133goodWeakPositiveSentiment141Performance is goodSentiment142PerformanceTopic143goodWeakPositiveSentiment151Performance is goodSentiment152PerformanceTopic153goodWeakPositiveSentiment161Performance is goodSentiment162PerformanceTopic163goodWeakPositiveSentiment171Performance is goodSentiment172PerformanceTopic173goodWeakPositiveSentiment181less MaintenanceNOUN_GROUP191less MaintenanceNOUN_GROUP201less MaintenanceNOUN_GROUP

Target is to have TA_TOKEN in Row Axis/Label Axis and Measure in Column Axis/Value Axis in which Positive and Negative can be selected.

At the end, this same calculation view should usable in SAC as a Story as well