Hey guys,
Got a problem around a two-stage calculation.
People and parties. How many followers do they have on Twitter? I get Follower Data at a Tweet level (important).
SO:
maxstring(followers)
gives me a correct calculation for one person's followers.
BUT:
How do I roll that up to a party level? At the moment it is being distorted by the number of tweets a user sends. For example, if person A has 100 followers and person B has 10 followers, the average should be 55.
BUT if person B tweets 10 times and person A tweets once, the average is 10*(10 followers) + 1*(100 followers) = 200 followers, divided by (10+1)=11 tweets. So the average comes out at 18.
Can anyone help?
