Adding visuals to Sentiment Analysis

[RGJ (Richard - Communiteq)]

So what does this module actually do next to making an entry in the classification_results table?

[Falco]

@RGJ

So what does this module actually do next to making an entry in the classification_results table?

At the moment that’s all it does. We are working on summarizing and exposing the results of those classifications as information in the UI as show in

@Falco

User overall sentiment on the user profile page - Future UI mockup

Overall community sentiment over time - Future UI mockup

[mattdm (Matthew Miller)]

I love the UI mockup!

Does anyone have any Data Explorer queries to use in the meantime? My SQL is kinda on the ¿donde esta la biblioteca? level…

[Falco]

@SaraDev made some last week they can share here.

[SaraDev (Sara Devlaeminck)]

There’s a few DE queries for the Discourse AI plugin I shared here:

Community Sentiment and Toxicity queries

For those wondering how to view the classification results database for the Community Sentiment and Toxicity modules, this can be done using the Data Explorer plugin, and the classification_results table. This is useful for seeing how the AI plugin is functioning on your site and classifying posts. AI Sentiment SELECT target_id as post_id, model_used, classification->'negative' as negative, classification->'neutral' as neutral, classification->'positive' as positive from classification_result…

[MarieMc]

Hello @Falco do you have an update on when this widget will become available on in the admin dashboard?

[Falco]

This is scheduled for our next sprint, so I’d guess no later than October.

[Samantha_O]

Is this still expected no later than October? asking for a friend

[Falco]

Yup, we did a first pass in the equation we going to use to classify between neutral and the sentiments, and we liked what we saw, so we are moving into implementation next.

[Hifihedgehog]

Hyped for Halloween and sentiment’s release!

[Samantha_O]

Any timeframe on when the sentiment dashboard of sorts will be available? To Hifihedgehog’s point - it’s almost all Hallow’s Eve and with that comes the end of October. Can we expect our trick or treating gift from Discourse to be this? asking for a friend… again

[sam (Sam Saffron)]

We are on it, @Roman_Rizzi is working on it this week, hard to put a date on it though, we hope to have something in next few weeks and will reply here as soon as it is ready.

In the mean time, are you using data explorer queries? they provide all the information its just that UI is not as fancy.

[Falco]

We’ve released the first pass on exposing this info in the dashboard:

It will rollout to our customer with the module enabled in the next deploy. Emotion still need some work, but we are getting there!

[MarieMc]

Hi @Falco, in the future, will it be possible to dive deep into this data? I’d love to see what specific conversations are driving what sentiment

[Falco]

Yes, it’s in our roadmap to work on reports and way to drill down on this data, making it easier for admins to act on it.