# Count number of occurences based on a condition

**URL:** <https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446>\
**Category:** Kibana\
**Created:** [June 4, 2018, 3:03pm UTC](https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446 "2018-06-04T15:03:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![javidr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/javidr/32/136982_2.png) [@javidr](https://discuss.elastic.co/u/javidr)\
**Post date:** [June 4, 2018, 3:03pm UTC](https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446/1 "2018-06-04T15:03:29Z")

</div>

Hi

Im having some issues with Kibana, as it doesnt work well with nested data (it is, a json inside the main json)

To solve it, i have had to flatten it, so, for example

{"car": "Ford, "Model": "Mondeo", "details": [{ "Price:, "6000", "Condition": "Used" }, {"Price:, "9000", "Condition": "New" }, { "Price:, "8000", "Condition": "New" }]}

Converts to:

{"car": "Ford, "Model": "Mondeo", "details.Price\_0:, "6000", "details\_Condition\_0": "Used", "details.Price\_1": "9000"......}

I would like to visualise in a bar chart the number of new cars per model.

The X axis will be model, but for the Y axis i would need to display the number of times that detail\_condition\_\* equals to "New"

How can i visualise that? Im trying to generate a query but it doesnt seem to work

Thanks

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [June 4, 2018, 8:24pm UTC](https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446/2 "2018-06-04T20:24:39Z")

</div>

Hi Javi,

We can try something here and see if it doesn't work.

Can you create your chart on with y axis on count and x-axis mode.  
And then try to create a filter on visualization by using add filter button.

In the example below - I am creating a filter for "win 8"

 ![add_filter](https://us1.discourse-cdn.com/elastic/original/3X/3/b/3b6c6c3be1f663ee328face06157251bb557ea6f.png)

Thanks  
Bhavya

---

<div class="post-metadata">

**Author:** ![javidr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/javidr/32/136982_2.png) [@javidr](https://discuss.elastic.co/u/javidr)\
**Post date:** [June 4, 2018, 8:40pm UTC](https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446/3 "2018-06-04T20:40:11Z")

</div>

Hi

Thanks for the answer

The problem I face is that my filter is not based on a field only, as it is an array flattened and every occurrence has a different name. details\_condition\_1, details\_condition\_2 etc...

It needs to be details\_condition\_$ what I use for filtering where $ is a wildcard

Can I create a regex or similar to match it?

---

<div class="post-metadata">

**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\
**Post date:** [June 5, 2018, 3:07pm UTC](https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446/4 "2018-06-05T15:07:45Z")

</div>

How are you loading this data and how did you flatten the data?

Ideally you would want each doc to represent 1 vehicle like;

```auto
{"car": "Ford, "Model": "Mondeo", "Price:, "6000", "Condition": "Used" }

{"car": "Ford, "Model": "Mondeo", "Price:, "9000", "Condition": "New" }

{"car": "Ford, "Model": "Mondeo", "Price:, "8000", "Condition": "New" }

```

If that is possible it would make things really easy.

---

<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:** [July 3, 2018, 3:12pm UTC](https://discuss.elastic.co/t/count-number-of-occurences-based-on-a-condition/134446/5 "2018-07-03T15:12:14Z")

</div>

Closed on July 3, 2018, 3:12pm UTC

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