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

[former_member545651]

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

[Henry_Banks]

Hi,

thanks for explaining your requirements .. but what is the actual problem here? you haven't described an issue or really asked a question . Are you stuck on a particular step? is there a warning or error or ..?

thanks, H

[former_member545651]

Hi Henry,

I need a logic in calculation view to create 2 measures positive and negative either as calculated column or restricted column

Kind Regards,

Ishan Mukewar