# Adding visuals to Sentiment Analysis

**URL:** https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661
**Category:** Feature
**Tags:** ai, ai-sentiment
**Created:** [May 5, 2023, 7:02pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661 "2023-05-05T19:02:05Z")
**Posts on this page:** 15
**Page:** 1

<div class="post-metadata">

### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [May 5, 2023, 7:02pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/1 "2023-05-05T19:02:05Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [May 5, 2023, 7:23pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/2 "2023-05-05T19:23:33Z")

</div>

> [@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

> [@Introducing Discourse AI](https://meta.discourse.org/t/introducing-discourse-ai/262744/1):
>
> ![](https://global.discourse-cdn.com/meta/original/4X/6/5/9/659f666adc4fb93c5cdd08e2ceab632c911b1399.png)
> 
> User overall sentiment on the user profile page - Future UI mockup
> 
> ![](https://global.discourse-cdn.com/meta/original/4X/7/c/d/7cd784930ed05ddbf7a0f048e4e3b9407b20f6d4.png)
> 
> Overall community sentiment over time - Future UI mockup

---

<div class="post-metadata">

### Author: ![mattdm](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mattdm/32/216484_2.png) [@mattdm](https://meta.discourse.org/u/mattdm)
#### Post date: [May 16, 2023, 7:00pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/3 "2023-05-16T19:00:44Z")

</div>

I love the UI mockup!

Does anyone have any [Data Explorer](https://meta.discourse.org/t/32566?silent=true) queries to use in the meantime? My SQL is kinda on the _¿donde esta la biblioteca?_ level…

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [May 16, 2023, 7:01pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/4 "2023-05-16T19:01:14Z")

</div>

@SaraDev made some last week they can share here.

---

<div class="post-metadata">

### Author: ![SaraDev](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/saradev/32/335139_2.png) [@SaraDev](https://meta.discourse.org/u/SaraDev)
#### Post date: [May 18, 2023, 6:51pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/5 "2023-05-18T18:51:18Z")

</div>

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

> [@Community Sentiment and Toxicity queries](https://meta.discourse.org/t/community-sentiment-and-toxicity-queries/275741):
>
> 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](https://meta.discourse.org/t/32566?silent=true) 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\_results…

---

<div class="post-metadata">

### Author: ![MarieMc](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mariemc/32/258056_2.png) [@MarieMc](https://meta.discourse.org/u/MarieMc)
#### Post date: [August 23, 2023, 3:04pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/6 "2023-08-23T15:04:42Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [August 23, 2023, 3:11pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/7 "2023-08-23T15:11:50Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Samantha\_O](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/samantha_o/32/251273_2.png) [@Samantha\_O](https://meta.discourse.org/u/Samantha_O)
#### Post date: [September 19, 2023, 7:44pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/8 "2023-09-19T19:44:45Z")

</div>

Is this still expected no later than October? _asking for a friend_

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [September 20, 2023, 12:40am UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/9 "2023-09-20T00:40:39Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Hifihedgehog](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hifihedgehog/32/140207_2.png) [@Hifihedgehog](https://meta.discourse.org/u/Hifihedgehog)
#### Post date: [October 22, 2023, 8:05pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/10 "2023-10-22T20:05:07Z")

</div>

Hyped for Halloween and sentiment’s release! 🚀

---

<div class="post-metadata">

### Author: ![Samantha\_O](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/samantha_o/32/251273_2.png) [@Samantha\_O](https://meta.discourse.org/u/Samantha_O)
#### Post date: [October 26, 2023, 8:56pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/11 "2023-10-26T20:56:14Z")

</div>

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_

🎃

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [October 31, 2023, 11:54pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/12 "2023-10-31T23:54:30Z")

</div>

We are on it, @Roman 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](https://meta.discourse.org/t/32566?silent=true) queries? they provide all the information its just that UI is not as fancy.

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [November 10, 2023, 8:21pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/13 "2023-11-10T20:21:56Z")

</div>

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

 ![image](https://global.discourse-cdn.com/meta/original/4X/1/0/1/101c3369125cd367b2d03bd4607fd02623491b8d.png)

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

---

<div class="post-metadata">

### Author: ![MarieMc](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mariemc/32/258056_2.png) [@MarieMc](https://meta.discourse.org/u/MarieMc)
#### Post date: [December 15, 2023, 2:02pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/14 "2023-12-15T14:02:02Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [December 15, 2023, 4:21pm UTC](https://meta.discourse.org/t/adding-visuals-to-sentiment-analysis/288661/15 "2023-12-15T16:21:11Z")

</div>

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.
