# All values but not only "other" in values / 0% when a possible value not in log **URL:** \ **Category:** Kibana\ **Created:** [September 3, 2021, 2:39pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291 "2021-09-03T14:39:01Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Emilaye](https://avatars.discourse-cdn.com/v4/letter/e/aca169/32.png) [@Emilaye](https://discuss.elastic.co/u/Emilaye)\ **Post date:** [September 3, 2021, 2:39pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/1 "2021-09-03T14:39:01Z")
Hi there, 1- I got a table in dashboard with value "Others".In fact i'd like to have all values listed at first, how can i have this result ? 2- In a column i can have many values for example A,B,C, i'd like to have 0% for C when i only have A,B values,is it possible ? Thx for help 🙂 ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 3, 2021, 5:04pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/2 "2021-09-03T17:04:58Z")
Hi @Emilaye , welcome to the Kibana community. Can I ask which tool did you use to build the tables in your dashboard? Assuming you've used Lens, the `Other` value usually comes by default from the `Top values` function: you can read more [about it at the bottom of this page](https://www.elastic.co/guide/en/kibana/master/lens.html). As for your second question, may I ask how is your document structured? ---
**Author:** ![syskey](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@syskey](https://discuss.elastic.co/u/syskey)\ **Post date:** [September 3, 2021, 7:42pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/3 "2021-09-03T19:42:27Z")
Hi, how can i have different values listed instead of top values? For second question, we want to check that all possible values are in log otherwise printing 0% for a value not in file, the file is a log with pipe as separator, thx for yoyr support 🙂 ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 20, 2021, 10:53am UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/4 "2021-09-20T10:53:24Z")
Sorry for late reply, didn't get the notification 😓 . > how can i have different values listed instead of top values? If you want to have a finer control over your values rather than just letting Lens picking up the "Top values" you can use Filters, but then manually define all the possible values. This could be probably a better case for also the second question: ![Screenshot 2021-09-20 at 12.45.44](https://us1.discourse-cdn.com/elastic/original/3X/5/4/54b411866088361b577c794a8a67aa14626d15bd.png) In the example above I've created a query for each row using Filters and the last one is `0` as there's no match found. ---
**Author:** ![Emilaye](https://avatars.discourse-cdn.com/v4/letter/e/aca169/32.png) [@Emilaye](https://discuss.elastic.co/u/Emilaye)\ **Post date:** [September 22, 2021, 2:55pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/5 "2021-09-22T14:55:53Z")
Thanx for you reply, yes i use Lens, can i change "top value" to "list of different valuesFor the second question, i use a log file with pipe a seperator , we want to check if all possible values are in file or 0% or 0 for the values not in file. thx for your support 🙂 ---
**Author:** ![Emilaye](https://avatars.discourse-cdn.com/v4/letter/e/aca169/32.png) [@Emilaye](https://discuss.elastic.co/u/Emilaye)\ **Post date:** [September 22, 2021, 3:05pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/6 "2021-09-22T15:05:53Z")
Thanks Marco, i used these filters with all defined values i was waiting for, but having quite a lot of filters (more than 300) i have an error when trying to go back to the view.... maybe there is another way to be more efficient... finnally we'd like to test the log file to find out when an unexpected value is reported in it,... Thx for any help, regards ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 20, 2021, 3:06pm UTC](https://discuss.elastic.co/t/all-values-but-not-only-other-in-values-0-when-a-possible-value-not-in-log/283291/7 "2021-10-20T15:06:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.