Hello,
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.
Hello,
Can you explain your problem with one exemple ?
It's not really clear.
Thanks
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 |
|---|---|
| John_Wick | 1,000 |
| John_Wick | 1,000 |
| John_Wick | 1,000 |
| Peter_Smith | 5,000 |
| Peter_Smith | 5,000 |
| Adam_Johnson | 9,000 |
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.