# ES|QL Visualization: Metric Format Title

**URL:** <https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470>\
**Category:** Kibana\
**Created:** [January 21, 2025, 6:24pm UTC](https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470 "2025-01-21T18:24:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [January 21, 2025, 6:24pm UTC](https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470/1 "2025-01-21T18:24:52Z")

</div>

Hello,  
I created a metric visualization using ES|QL. I was wondering if I am doing it wrong but I can't seem to format the name with spaces.

```auto
FROM logs-*
| WHERE host.name IS NOT NULL
| STATS count = COUNT(*) BY host.name
| STATS sum_count = SUM(count)
| RENAME sum_count AS Total_Hosts

```

I tried to do :  
`| RENAME sum_count AS 'Total Hosts'`  
I get this error:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/2/a26745ece3fc8f8534dfea46e20543f3c1458755.png)

Perhaps it cannot be done in ES|QL but theres no editing title in Visual Editor:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/f/ffd9e11fbd99f39daee956e3c97fd5cc79926bea.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/c/1c455d3a9e0db697af226b9fcf7ab2b24c893d90.png)

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 21, 2025, 6:40pm UTC](https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470/2 "2025-01-21T18:40:45Z")

</div>

Hi @erikg What version are you on

8.17.1

```auto
FROM logs-*
| WHERE host.name IS NOT NULL
| STATS count = COUNT(*) BY host.name
| STATS sum_count = SUM(count)
| RENAME sum_count AS Total_Hosts

```

 ![Screenshot 2025-01-21 at 10.38.43 AM](https://us1.discourse-cdn.com/elastic/original/3X/2/2/22b27764f10570a8bfcb65bb7f0353db0ef1ab72.png)

Also not sure if you are just testing but the above query is the same as this

```auto
FROM logs-*
| WHERE host.name IS NOT NULL
| STATS Total_Hosts = COUNT(*)

```

Because you are doing `BY` then just summing that...

---

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [January 21, 2025, 6:43pm UTC](https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470/3 "2025-01-21T18:43:45Z")

</div>

Hey @stephenb , haha thanks for optimizing my query but I was asking regarding the format of the title "Total\_Hosts". I am a picky person and would like to remove the "\_" in between, I would prefer if it was able to modify the column or end result to "Total Hosts"

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [January 21, 2025, 7:00pm UTC](https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470/4 "2025-01-21T19:00:28Z")

</div>

Back ticks... ` is the magic incantation

```auto
FROM logs-*
| WHERE host.name IS NOT NULL
| STATS `total hosts` = COUNT(*)

```

 ![Screenshot 2025-01-21 at 11.00.02 AM](https://us1.discourse-cdn.com/elastic/original/3X/6/9/69b903923971b00c45626b18cd296b6723ed4352.png)

---

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [January 21, 2025, 7:17pm UTC](https://discuss.elastic.co/t/es-ql-visualization-metric-format-title/373470/5 "2025-01-21T19:17:39Z")

</div>

Woah! thanks @stephenb