# Create label for existing data

**URL:** <https://discuss.elastic.co/t/create-label-for-existing-data/171465>\
**Category:** Kibana\
**Created:** [March 8, 2019, 9:54am UTC](https://discuss.elastic.co/t/create-label-for-existing-data/171465 "2019-03-08T09:54:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![muralasandeep](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@muralasandeep](https://discuss.elastic.co/u/muralasandeep)\
**Post date:** [March 8, 2019, 9:54am UTC](https://discuss.elastic.co/t/create-label-for-existing-data/171465/1 "2019-03-08T09:54:29Z")

</div>

Hi every one ,

This is Sandeep,  
i am new at kibana ,  
i have one field Error\_types ,in that field i have 3 types of errors like  
Table  
Syntax  
Failed  
based on this i created pie chart like this

metrics  
Slice Size: Count  
buckets  
Split Slices:  
Aggregation :  
Terms  
Field:  
Error\_type.keyword  
Order by  
Metric :Count  
in pie chart my result is ,  
Field value  
Error\_type.keyword Table 17,016 (91%)  
Error\_type.keyword Failed 1,281 (7%)  
Error\_type.keyword Syntax 393 (2%)

my expected results are  
Table doesn't exist 17,016 (91%)  
Failed to send mail 1,281 (7%)  
SQL Syntax Error 393 (2%)

here i changed only one label to "Failed to sent mail" from  
Label for missing values ,this data showing messing values, i am unable to change Table and Syntax because this Table and syntax data directly coming from data source but i need to change those data ,  
because when i am pointing to the particular data like "Table" i want show meaning full information like "Table doesn't exists" instead of only "Table" .  
Can any one help me please ,  
Thanks .

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [March 8, 2019, 5:59pm UTC](https://discuss.elastic.co/t/create-label-for-existing-data/171465/2 "2019-03-08T17:59:39Z")

</div>

Are you able to enter a string in the **Custom Label** field to change the display label ? This will display the label correct.y. More info needed on ur kibana instance ...screenshots, versions, gifs help .

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![muralasandeep](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@muralasandeep](https://discuss.elastic.co/u/muralasandeep)\
**Post date:** [March 11, 2019, 4:43am UTC](https://discuss.elastic.co/t/create-label-for-existing-data/171465/3 "2019-03-11T04:43:26Z")

</div>

Hi @rashmi ,  
Thank you so much for your replay,  
Yes,i am able to enter a string in the **Custom Label** field but i have only one **custom Label** but i need to change data (Table as Table doesn't exist ,Syntax as SQL syntax Error ) within one field that field name is Error\_type.keyword ,  
my actual Pie chart visualize like this  
Field value  
Error\_type.keyword Table 17,016 (91%)  
Error\_type.keyword Failed to send mail1,281 (7%)  
Error\_type.keyword Syntax 393 (2%)

in this Table and syntax data came from data source remaining Failed data is i created (enable) as missing data ,for missing data label is available as "Label for missing values" so for this i wrote as "Failed to sent mail" ,

now my Pie chart visualize is like this ,

Field value  
Error\_type.keyword Table 17,016 (91%)  
Error\_type.keyword Failed to send mail 1,281 (7%)  
Error\_type.keyword Syntax 393 (2%)

i have one **Custom Label**  
if i enter a string in **Custom Label** as Error Type:  
it shows like this  
Field value  
Error Type: Table 17,016 (91%)  
Error Type: Failed to send mail 1,281 (7%)  
Error Type: Syntax 393 (2%)  
if i enter a string in **Custom Label** as Table doesn't exist  
it shows like this  
Field value  
Table doesn't exist Table 17,016 (91%)  
Table doesn't exist Failed to send mail 1,281 (7%)  
Table doesn't exist Syntax 393 (2%)  
but my expected result is ,  
Field value  
Error Type: Table doesn't exist 17,016 (91%)(red color)  
Error Type: Failed to send mail 1,281 (7%)(Pink color)  
Error Type: SQL Syntax Error 393 (2%)(Orange color )

as shown above i need to show when i pointing to Red color i want show like this Error Type:Table doesn't exist 17,016(91.04%) like this remaining also..

could you help me please ,

Thanks  
Sandeep

---

<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:** [April 8, 2019, 4:43am UTC](https://discuss.elastic.co/t/create-label-for-existing-data/171465/4 "2019-04-08T04:43:35Z")

</div>

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