I want to create some sort of scoring mechanism on a visual and want to know if scripted fields are the way to do this.
I have documents that come in when a famous person gets a like, comment or a share of their post. I then want to create a scoring mechanism to calculate how popular they are (on a visual). So a like is not as valuable as a comment and a share is the most strong indicator of popularity. So I want 2 things:
I want to create a number that will calculate across all events a number score of how popular each person is. In the end I'd have a visual that would list the top 5 popular people, where popularity is a single number created by an algorithm of something similar to: likes/10000 + comments/10 + shares = popularity.
I want to create a chart that shows for each person, their distribution of likes, comments and shares. I can do this currently with a filtered bar chart but when there are 10000 likes 100 comments and 5 shares, I can't see any of the shares/comments compared to the likes because there are so many likes. So I'd like to normalize each of them so that graph is actually visually useful.
Would scripted fields deal with both of these use cases?