# What does \_all in a vertial bar chart mean and is it possible to trim the value showed in tooltip?

**URL:** https://discuss.elastic.co/t/what-does--all-in-a-vertial-bar-chart-mean-and-is-it-possible-to-trim-the-value-showed-in-tooltip/70389
**Category:** Kibana
**Created:** [January 3, 2017, 5:52am UTC](https://discuss.elastic.co/t/what-does--all-in-a-vertial-bar-chart-mean-and-is-it-possible-to-trim-the-value-showed-in-tooltip/70389 "2017-01-03T05:52:24Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Kulasangar\_Gowrisang](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@Kulasangar\_Gowrisang](https://discuss.elastic.co/u/Kulasangar_Gowrisang)
#### Post date: [January 3, 2017, 5:52am UTC](https://discuss.elastic.co/t/what-does--all-in-a-vertial-bar-chart-mean-and-is-it-possible-to-trim-the-value-showed-in-tooltip/70389/1 "2017-01-03T05:52:24Z")

</div>

This is how my graph in `Kibana` looks like:

 ![](https://us1.discourse-cdn.com/elastic/original/2X/9/9e24c519d551a4755d269d7c00489d6ab2959f54.jpg)

What does `_all` mean in the graph above and is it possible to trim the part of a value which is being shown in the tool tip ?

I've gone through [this](https://discuss.elastic.co/t/modifying-values-displayed-in-tooltip-in-kibana-visualization/41155) thread as well, in which it says that it isn't possible to modify the `tooltip`. Instead is there a way to truncate the field which is being shown in the tooltip using a script in `Kibana` so that I can show the value as I want?

Any help could be appreciated.

---

<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: [January 3, 2017, 4:30pm UTC](https://discuss.elastic.co/t/what-does--all-in-a-vertial-bar-chart-mean-and-is-it-possible-to-trim-the-value-showed-in-tooltip/70389/2 "2017-01-03T16:30:27Z")

</div>

Hi Kulasangar,

I think I'd need to see the configuration of your visualization (the expanded panes on the left side) to help with your question on `_all`.

As far as the format of dates, there are a couple of things you could try.

1). There are 2 advanced settings you can change from within Kibana. But these are both global settings and not specific to this one visualization.

One is the `dateFormat` which has a default like `MMMM Do YYYY, HH:mm:ss.SSS`

The other is `dateFormat:scaled` which should automatically scale the date format based on the interval of the data. I don't know if that's not working because I don't see the configuration in the left panes.

2). You can try creating a new scripted field that shows your date field but in a truncated format and then use that in this visualization. If not 100% sure that the visualization won't still try to apply the scaled format on it though.

Regards,  
Lee

---

<div class="post-metadata">

### Author: ![Kulasangar\_Gowrisang](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@Kulasangar\_Gowrisang](https://discuss.elastic.co/u/Kulasangar_Gowrisang)
#### Post date: [January 4, 2017, 5:07am UTC](https://discuss.elastic.co/t/what-does--all-in-a-vertial-bar-chart-mean-and-is-it-possible-to-trim-the-value-showed-in-tooltip/70389/3 "2017-01-04T05:07:26Z")

</div>

Hi @LeeDr, Thank you for the quick response. 🙂

So [this](http://imgur.com/a/NpCpn) is how the config of the visualization look like for the above graph. Hope that answers your question.

I can't use the advanced settings you've mentioned since I need the timestamp value to be trimmed in this graph only. So I guess going ahead with the scripted field would work.

> [@LeeDr](#):
>
> You can try creating a new scripted field that shows your date field but in a truncated format and then use that in this visualization

How can I get going with this? If you could give me a hint as how the scripted field should look like? I'm aware of getting a value of an existing field using painless, but how am I going to trim?

Thanks 🙂

---

<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: [February 1, 2017, 5:07am UTC](https://discuss.elastic.co/t/what-does--all-in-a-vertial-bar-chart-mean-and-is-it-possible-to-trim-the-value-showed-in-tooltip/70389/4 "2017-02-01T05:07:34Z")

</div>

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