cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JamesH245 Frequent Visitor
Frequent Visitor

Detect trend and sort by it

Hi, I have a report based on sentiment analysis. The data looks like this:

sentiments.PNG

 

Each row is a post in a forum thread. Each post has an id that connects the posts as a thread. What I want to do is be able to detect the overall trend. Where does it start, and where does it end. This thread goes from negative to positive. (say 1 for positive trend, 0 for negative) But it would be nice to have a trend line equation. How can I take trend line data and sort threads by the trend (priotitize more negatively trending)? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Detect trend and sort by it

Hi @JamesH245 ,

 

I am unsure about your requirements. How do you want to show the trend in table? and the time in trend line? please kindly share more expected results with captures that would be easier for us to generate it. thanks!

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Detect trend and sort by it

Hi @JamesH245 ,

 

I am unsure about your requirements. How do you want to show the trend in table? and the time in trend line? please kindly share more expected results with captures that would be easier for us to generate it. thanks!

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 256 members 3,051 guests
Please welcome our newest community members: