Hi,
I would like to generate a composite "Bar horizontal percentage" chart in Kibana. See PowerPoint version below:
I have tried to reproduce this chart in Kibana by using three different methods. None of the methods have produced satisfactory outputs.
First, I tried to use "Filters" for each of the sub-questions. The problem is that there is only a single input for "horizontal axis", which simply reproduces the same output for each bar chart - i.e., the output for "Water".
Second, I tried to generate separate bar charts and only included a key at the bottom. Although it produced a technically correct result, it was extremely ugly.
Third, I used filters and added layers. Although this produced a technically correct output, Kibana identified the four possible responses as 8*4 (=32) different responses. The subsequent output was one full iteration of the theme colour, as opposed to eight iterations.
Since there are only four possible responses ("Included in my rent", "Not offered", "I don't know" and "Charged separately"), I do not understand why Kibana identifies 32 possible responses.
I would like to reproduce a composite bar chart that resembles the PowerPoint representation (the first image in this query). Any help would be greatly appreciated.
See first (incorrect) attempt below:
See second (incorrect) attempt below:
See third (incorrect) attempt below:
What is the version of the stack used?
Can you share the mapping of the index?
Kibana v 8.7.1.
Hopefully, I'm sending the mapping of the index correctly (see below):
"For each of these services, which were/are included in your rent or charged separately? \n[Cleaning service for your bedroom]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Electricity]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Laundry]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Organised transport to campus (e": {
"properties": {
"g": {
"properties": {
" bus or shuttle)]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Parking]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Student Life Programme (Parties, events etc": {
"properties": {
")]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Water]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"For each of these services, which were/are included in your rent or charged separately? \n[Wi-Fi]": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
