I'm new to Kibana, and I can't seem to figure out a completely trivial thing. Can you please point me in the right direction? I tried searching & googling, but I was not able to move on for more days.
Minimal working example:
data
| sentence | article | is_about_cat |
|---|---|---|
| Cat drinks milk. | A | YES |
| Dog drinks milk. | A | NO |
| I love you. | B | NO |
| You love me. | B | NO |
| Cat is an animal. | C | YES |
| Sky is blue. | C | NO |
| Blood is red. | C | NO |
| I don´t know. | D | NO |
| You don't know. | D | NO |
What I want:
I want to know how many articles are about cats = have at least one sentence that has "YES" in "is_about_cat" column. (Which is true for 2 articles in the example data, A & C.)
The visualization I can do (if I am not wrong):
Use metrics and show the number/percentage of articles that contain a sentence about a cat.
visualization -> metrics
unique_count('article.keyword', kql='is_about_cat:"YES"')
unique_count('article.keyword', kql='is_about_cat:"YES"') / unique_count('article.keyword')
The visualization I want and don't know how to do:
I want to visualize the proportion and have a graph:
I can only do this graph for sentences (each line in the table). I tried visualisation & aggregation based visualisation, but I was not able to get to the right numbers.
How can I make this visualization?
Thank you for your time & help. 