# Splitting visualization by value not field

**URL:** <https://discuss.elastic.co/t/splitting-visualization-by-value-not-field/218573>\
**Category:** Kibana\
**Created:** [February 10, 2020, 11:29am UTC](https://discuss.elastic.co/t/splitting-visualization-by-value-not-field/218573 "2020-02-10T11:29:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kilianten](https://avatars.discourse-cdn.com/v4/letter/k/bbce88/32.png) [@kilianten](https://discuss.elastic.co/u/kilianten)\
**Post date:** [February 10, 2020, 11:29am UTC](https://discuss.elastic.co/t/splitting-visualization-by-value-not-field/218573/1 "2020-02-10T11:29:00Z")

</div>

I can the JSON structure whatever way I like but I need to split tables by string value and get a count of another value for example:

{  
"car.BMW":20,  
"car.Toyota":10  
}  
or something like  
{  
car: {"name":"BMW", "value":20}  
car: {"name":"Toyota", "value":10}  
}

and my table would look like this:

| CAR | COUNT |  
| BMW | 20 |  
|Totaota| 10 |

But I cant get the table to look like that! Any ideas?

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [February 10, 2020, 2:54pm UTC](https://discuss.elastic.co/t/splitting-visualization-by-value-not-field/218573/2 "2020-02-10T14:54:09Z")

</div>

The Discover app is one way of looking at a table which contains values from individual documents. The Visualize Table is aggregated, which it sounds like you don't want.

So I would suggest you select the path to the fields from Discover, such as `car.name` and `car.value`, and then Save the search. Once the search is saved you can embed it in a dashboard.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 9, 2020, 2:54pm UTC](https://discuss.elastic.co/t/splitting-visualization-by-value-not-field/218573/3 "2020-03-09T14:54:15Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.