Dated post density aggrigation query

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.

here is the sample data

          "tweet": "Tweet Text",
          "create_date": "2016-10-13T14:07:45+02:00",

What have you tried so far?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.