I have made a small fun PoC last year, 2016. December 18th, on which I inserted tweets (Twitter4J) into ES, and visualized with Kibana.
The above visualization shows significant terms that appear in tweets that contain "trump", and on the Y axis, their corresponding sentiment value. I prepared no mappings by hand, fields have been indexed dynamically and appeared in Kibana - surprisingly and fortunately.
Now, using the same data, I would like to define my own mappings, but could not produce the same visualization. The "tweet.text" if analyzed, no aggregations are available. If I create a "raw" field mapping as well, it is aggregatable, but definitely not going to produce the same results. I also added the following to the field definition:
"term_vector": "with_positions_offsets_payloads", "index_options": "offsets"
I'm using the "standard" analyzer, and field type "text".
I kindly as the Community to help me to achieve such a visualization on any text field.