I am working on twitter analytics where in I am stuck on certain queries. I am not able to figure out which aggregation or other queries do I use to get the desired result.
I have dumped all the tweets and i need the result in desired format.
-
I need to plot an graph which will tell me on which day did I tweet the most.
-
Also what time is the best time to tweet (considering most retweets i got) .
here is the sample data
{
"tweet": "Tweet Text",
"create_date": "2016-10-13T14:07:45+02:00",
"re-tweets":40
}