Post Created Logic


(Ranga Ta) #1

Hi

How to calculate Post Created measure from Post table. We are trying to extract each user wise , group wise number of posts created but the overall post created for a given user in the user_stats table is not matching with number of records in the Posts table

Thanks
Ranga


(Jay Pfaffman) #2

That table gets generated daily, so if people post frequently, it’s wrong.


(Ranga Ta) #3

Hi Jay

Is there any script to populate the table(user_stats). As the above the User last updated one week ago. Still the post created is not matching with User_stats and Post table

Thanks
Rnaga


(Jay Pfaffman) #4

You can check http://site/sidekiq and search for something like “stats” to see whether sidekiq hasn’t been updating those stats.

Are your stats based on some query you did in the data explorer? You might post that query here to see if there’s something obviously wrong with that you’re getting from your query and what you’re expecting to see.