# Visualization using one field as term but label with another field

**URL:** <https://discuss.elastic.co/t/visualization-using-one-field-as-term-but-label-with-another-field/91242>\
**Category:** Kibana\
**Created:** [June 29, 2017, 8:12am UTC](https://discuss.elastic.co/t/visualization-using-one-field-as-term-but-label-with-another-field/91242 "2017-06-29T08:12:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![smlbiobot](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/smlbiobot/32/29622_2.png) [@smlbiobot](https://discuss.elastic.co/u/smlbiobot)\
**Post date:** [June 29, 2017, 8:12am UTC](https://discuss.elastic.co/t/visualization-using-one-field-as-term-but-label-with-another-field/91242/1 "2017-06-29T08:12:59Z")

</div>

I would like to use Kibana to do some visualization, but am having trouble figuring how to use one field for calculation but then label the result using another field.

The way I have structured my data has been using something similar to below for users:

```
{
      "name": "Streetlamp",
      "id": "140707809124810752"
}

```

I would like to count the sum of ids, but on the axis use the name as display. This is because the users often change their name and so it’s not an accurate representation if I count the name, but if I count the IDs, the chart became unreadable by humans.

How would I go about to do that?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [June 29, 2017, 10:16am UTC](https://discuss.elastic.co/t/visualization-using-one-field-as-term-but-label-with-another-field/91242/2 "2017-06-29T10:16:08Z")

</div>

> [@smlbiobot](#):
>
> am having trouble figuring how to use one field for calculation but then label the result using another field.

You cannot do that unfortunately.

---

<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 27, 2017, 10:16am UTC](https://discuss.elastic.co/t/visualization-using-one-field-as-term-but-label-with-another-field/91242/3 "2017-07-27T10:16:10Z")

</div>

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