# Create "Flop 10" with 0 values

**URL:** <https://discuss.elastic.co/t/create-flop-10-with-0-values/326572>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [February 27, 2023, 11:31am UTC](https://discuss.elastic.co/t/create-flop-10-with-0-values/326572 "2023-02-27T11:31:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![StadtGE](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stadtge/32/117796_2.png) [@StadtGE](https://discuss.elastic.co/u/StadtGE)\
**Post date:** [February 27, 2023, 11:31am UTC](https://discuss.elastic.co/t/create-flop-10-with-0-values/326572/1 "2023-02-27T11:31:05Z")

</div>

Hi,  
I hope you can help me. I want to create a visualisation (bar, metric, bucket etc.) for flop 10. It works, but I want show 0 values, areas that have not been selected.  
I have added {"min\_doc\_count":0} for the JSON input of the Terms sub-bucke(hostname), but that does not work.  
[![image](https://us1.discourse-cdn.com/elastic/original/3X/e/b/eb6e3e405050207b92669553de029c50d11ebe53.png)](https://user-images.githubusercontent.com/90030681/221545703-1b86becb-24cc-4c8d-ac88-fef2b3ceae16.png)

---

<div class="post-metadata">

**Author:** ![philippkahr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/philippkahr/32/100137_2.png) [@philippkahr](https://discuss.elastic.co/u/philippkahr)\
**Post date:** [February 27, 2023, 11:43am UTC](https://discuss.elastic.co/t/create-flop-10-with-0-values/326572/2 "2023-02-27T11:43:59Z")

</div>

Hi,

I would like to help you. Can you explain what a `FLOP 10` actually is?

I think I understand what you want to achieve.

Let's say you have the following three values:

- Luftbild: 0
- Böden: 1
- Grundschulen: 2

and now you also want to see the `Luftbild` on the `y` axis with 0 as value? Then in the legacy visualisation, you need to click on `Show missing values` on the right hand side. That should do the trick.

That would be a good idea to also rebuild using Kibana Lens, which is much more intuitiv and easy to use. There you can immediately change from Bar, to Line, to Heatmap, without needing to rebuild the entire visualisation all the time.

---

<div class="post-metadata">

**Author:** ![StadtGE](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stadtge/32/117796_2.png) [@StadtGE](https://discuss.elastic.co/u/StadtGE)\
**Post date:** [February 27, 2023, 12:31pm UTC](https://discuss.elastic.co/t/create-flop-10-with-0-values/326572/3 "2023-02-27T12:31:30Z")

</div>

Hi,

yeah thats exactly what I want.

`Show missing values `doesn´t work.` ``Nothing happens when I activate the button.```

`Thank you for helping.`

``

`Best Regards`

`Eva`

``

``

``

``

``

---

<div class="post-metadata">

**Author:** ![philippkahr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/philippkahr/32/100137_2.png) [@philippkahr](https://discuss.elastic.co/u/philippkahr)\
**Post date:** [February 27, 2023, 2:50pm UTC](https://discuss.elastic.co/t/create-flop-10-with-0-values/326572/4 "2023-02-27T14:50:52Z")

</div>

Ah. Is your data more like this:

`app.name: "Luftbild"`  
`app.name: "Grundschule"`  
`app.name: "Böden"`

Here is what the docs look like in Elasticsearch:

```auto
POST evademo/_doc
{
  "@timestamp": "2023-02-20T09:00:00.000Z",
  "app": { "name": "luftbild"}
}
POST evademo/_doc
{
  "@timestamp": "2023-02-27T09:00:00.000Z",
  "app": { "name": "böden"}
}
POST evademo/_doc
{
  "@timestamp": "2023-02-27T09:00:00.000Z",
  "app": { "name": "grundschule"}
}
POST evademo/_doc
{
  "@timestamp": "2023-02-27T09:00:00.000Z",
  "app": { "name": "party"}
}

```

Now it's today and you set your time picker for today. Resulting in that view:

 ![Screenshot 2023-02-27 at 15.24.59](https://us1.discourse-cdn.com/elastic/original/3X/8/e/8eb2d9965d52e94195b2e90e9f6cff6fa9d07d7c.png)

Which shows, `party`, `grundschule`, `böden`. Missing out on `Luftbild`, since the last entry of `Luftbild` is on the 20th Februar.

This is a bit of a struggle. You want a document that cannot be found in the timepicker to still show up.

Maybe another solution would be to use a table view, and set the column to `last value of @timestamp`. Then you can override the time picker settings for this visualisation using the wheel icon.

 ![Screenshot 2023-02-27 at 15.48.35](https://us1.discourse-cdn.com/elastic/original/3X/9/7/97bd8f5b152135a3bf4d32f7eacaba3701cf2c21.png)

and setting the `Customize Time Range` to whatever you like, e.g. 30 days. This will now always stay at 30 days, regardless of what you choose for the entire dashboard.

 ![Screenshot 2023-02-27 at 15.50.27](https://us1.discourse-cdn.com/elastic/original/3X/3/b/3b5599baae4c02b852b9289375306d223bcf4303.png)

Does that help you?

---

<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 27, 2023, 2:51pm UTC](https://discuss.elastic.co/t/create-flop-10-with-0-values/326572/5 "2023-03-27T14:51:50Z")

</div>

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