You are viewing a single comment's thread from:

RE: Posts, Word Count, Rewards, Communities, and other weekly analytical reports - 2nd Week of July

in Hive Statistics2 months ago (edited)

This is quite a data dump :) Nice!
Will need to go throug it a few times.
On a first look, there is data for posts by aplication, there is a breakdown of all the posts by word count, but there is no breakdown on word count by app... if I can see right?

You can get data for character numbers from the comments table, column body lenght... and break it down by app, you can then divide the number of characters with some average character per word and get a proxy for the word by app...

Sort:  

I have engineered that as a column in my PowerBI DAX. I'm just counting the spaces in the text to get the wordcount, plus one.

I have that as a slicer on the left hand side of this image:

image.png

It shows the averages per interface, but I haven't yet got a measure to count num posts per word count group. I ran out of time to do that for today's post but I can definitely elaborate on it further.