I would like to ask for help. I have twitter data and I would like to sum all followers for unique accounts. However, I need it in the form of Metric visualization (as one number, Kibana visualization). I cannot filter unique records and sum them in this type of visualization. I used Terms but without success and many more. Thanks in advance for the help.
Can you explain your problem with one exemple ?
It's not really clear.
Are you trying to count all the possible values in your field list ? like having a list of followers and you want to count all followers for instance ? maybe the problem is that you are counting the number of documents where your term match. I don't know if that could help you but maybe you could look at the cardinality of your field corresponding to the name of the account ? after all, everything depends on the way you mapped your index
|Account_name||no. Of followers|
pls. see example above:
1.) filter only unique records 1x John_Wick, 1x Peter_Smith, 1x Adam_Johnson
2.) sum all followers 1000 + 5000 + 9000
3.) I need it in the form of Metric visualization (as one number) result will be 15000
4.) maybe the solution is pretty easy but I dont see it
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.