# Flat table of data **URL:** \ **Category:** Kibana\ **Created:** [February 3, 2022, 10:56am UTC](https://discuss.elastic.co/t/flat-table-of-data/296177 "2022-02-03T10:56:34Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\ **Post date:** [February 3, 2022, 10:56am UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/1 "2022-02-03T10:56:34Z")
Hi all, I'm using 7.16.2 version. I have data in elastic which is representing result of tests, one json for example: My question is, how can I create new table in kibana with flat result, not top values. I want to see this table: testcaseName | testcaseFailedReason| buildNumber I want to see all the result appears in the DB and not the first 10 and not top values. ```auto { "_index" : "testcases", "_type" : "_doc", "_id" : "V4U5vH4Brh--qJzelZEv", "_score" : 7.190881, "_ignored" : [ "testcase.$.name.keyword" ], "_source" : { "buildNumber" : 5, "buildVersion" : "1.16.5-add-tester-name-field-to-elastic+5", "testcase" : { "$" : { "name" : "/opt/fireglass/1.16.5-add-tester-name-field-to-elastic+5/regression_tests/out/cases/activity_logs/basic_activity_logs_search.js - Basic activity log search Activity log search after browsing Contains a log with events 'Network Request' and 'Forward To Isolation", "time" : "17.325", "className" : "Contains a log with events 'Network Request' and 'Forward To Isolation" } }, "testcaseFailedReason" : "", "testcaseName" : "Basic activity log search Activity log search after browsing Contains a log with events 'Network Request' and 'Forward To Isolation", "testcaseStatus" : "Passed", "testcaseTime" : 17.325, "testerName" : "", "timestamp" : "2022-02-02T20:56:37.234Z" } } ``` ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [February 3, 2022, 11:08am UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/2 "2022-02-03T11:08:15Z")
Discover is not enough for you? ---
**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\ **Post date:** [February 3, 2022, 11:59am UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/3 "2022-02-03T11:59:00Z")
What do you mean? ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [February 3, 2022, 12:02pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/4 "2022-02-03T12:02:21Z")
As you said you want to sell all results, Discover will meet the requirement. [Discover | Kibana Guide [7.17] | Elastic](https://www.elastic.co/guide/en/kibana/current/discover.html) ---
**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\ **Post date:** [February 3, 2022, 12:05pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/5 "2022-02-03T12:05:38Z")
I want all the results, but with filter, certain field should be not empty, how do I filter fields that has value other than "", and I want it as a table in the dashboard. ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [February 3, 2022, 12:19pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/6 "2022-02-03T12:19:24Z")
I suppose saved search is the best match. Using Discover and set filter and select fields to show in table. Then click Save button right-top. ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/4/745dcb768b93f03fb5ecfcc7b9b7346b0f605a85.png) You can add the search form Add From Library in Dashboard. ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/8/c8d6a7ddbd8186a7254c3fa1445cc61c020cadbf.png) ---
**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\ **Post date:** [February 3, 2022, 12:31pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/7 "2022-02-03T12:31:49Z")
Hi Tomo, The example you gave me is perfect, Thanks! I need only more one thing: How can I select which fields will be displayed in the visualize? I don't need all the fields, I need only few. (And should I do it in the discover stage or in the dashboard?) Thanks again ---
**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\ **Post date:** [February 3, 2022, 12:34pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/8 "2022-02-03T12:34:34Z")
You can do it in the Discover stage. Click fields in the left column (maybe just bellow the "Selected fields ...... 3" in my screenshot). Then only selected fields showup in the table. ---
**Author:** ![ShayWeizman](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@ShayWeizman](https://discuss.elastic.co/u/ShayWeizman)\ **Post date:** [February 3, 2022, 1:01pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/9 "2022-02-03T13:01:03Z")
Very cool!! Thank you very much !! I've succeed to add it as I want 🙂 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 3, 2022, 1:01pm UTC](https://discuss.elastic.co/t/flat-table-of-data/296177/10 "2022-03-03T13:01:37Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.