Where is the table for Topic Usage in Virtual Agent Analytics

[Junyu]

Dear experts, 

Now i am using Virtual Agent Analytics. I want to use the data of Topic Usage (Topics -> Topic details -> Topic Usage). 

Do you know where it is (name of the table containing this data)?

Thanks a lot.

[Chris D]

I would say it's likely/almost certainly the Conversation Task (sys_cs_conversation_task) table since that's the primary source for Topic instances (i.e. usage).

[VCN]

Hi @Junyu ,

Could you share if you were able to figure this out as I am also looking for the same.

[abhishek153]

Hi @Junyu 
did you able to figure out the issue iam also looking for the same.
please let me know if you got information for that it will helpful for me.

[VCN]

Hi @Junyu @Chris D 

We have raised a case on this with ServiceNow as one of the topic occurrence count was showing very high. As part of the case submitted, it was explained by ServiceNow the data in this dashboard is coming from the Remote table "sn_ci_analytics_st_topic_occurrence" and using the below script on the Remote table.

https://INSTANCENAME.service-now.com/nav_to.do?uri=sys_script_vtable.do?sys_id=b7b0d95553142010bf6bd...

They have also shared the below Support article URL to understand on how the data in Virtual Agent dashboard is displayed. I have attached knowledge article if in case you cannot access the below link.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1507183

Please mark this answer as Correct if the details provided here answers your question.