# \[kibana\] Multi-levle pie chart issue

**URL:** <https://discuss.elastic.co/t/kibana-multi-levle-pie-chart-issue/194774>\
**Category:** Kibana\
**Created:** [August 12, 2019, 2:37am UTC](https://discuss.elastic.co/t/kibana-multi-levle-pie-chart-issue/194774 "2019-08-12T02:37:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![cheriemilk](https://avatars.discourse-cdn.com/v4/letter/c/c37758/32.png) [@cheriemilk](https://discuss.elastic.co/u/cheriemilk)\
**Post date:** [August 12, 2019, 2:37am UTC](https://discuss.elastic.co/t/kibana-multi-levle-pie-chart-issue/194774/1 "2019-08-12T02:37:34Z")

</div>

Hi Team,

1. I have below set of data in elk. Inside the data, the values under ktf4 column describe the elements end user selected for **Profile\_Criteria** only on UI page.  
indent preformatted text by 4 spaces

> ```
> > ktf2,ktf3,ktf4
> > "Keyword,Profile_Criteria",,city
> > Background_Criteria,languages,
> > Profile_Criteria,,managerId
> > Rating_Criteria,,
> > Background_Criteria,languages,
> > Profile_Criteria,,managerId
> > Profile_Criteria,,firstName
> 
> ```

1. 
  1. I go to Kibana-\>visualization to create a multi-level pie chart, the inner ring is aggregated based on ktf2, the outer ring is aggregated based on ktf4.  
From the above data, it generated below pie charts with two levels.  
For the out ring, it aggregated for keyword(which is part of slice in the inner ring) as well. As I explained above, ktf4 is the field to describe Profile\_Criteria only, so the aggregation for outer ring shouldn’t generate a slice for Keyword.  
**As the data structure is already there, and is not very likely to re-structure it. Is there any way to work around this issue?**

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

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [August 13, 2019, 10:39pm UTC](https://discuss.elastic.co/t/kibana-multi-levle-pie-chart-issue/194774/2 "2019-08-13T22:39:32Z")

</div>

From the data, it appears that this is functioning correctly. Your first entry has both `Keyword` and `Profile_Criteria` for `ktf2` in the same entry that has `city` for `ktf4`, so it would make sense that `city` is showing up for both of these. Am I misunderstanding something?

---

<div class="post-metadata">

**Author:** ![cheriemilk](https://avatars.discourse-cdn.com/v4/letter/c/c37758/32.png) [@cheriemilk](https://discuss.elastic.co/u/cheriemilk)\
**Post date:** [August 15, 2019, 8:15am UTC](https://discuss.elastic.co/t/kibana-multi-levle-pie-chart-issue/194774/3 "2019-08-15T08:15:23Z")

</div>

Hi Lukas,

Your understanding is correct. But I am seeking for anyway that when aggregating with ktf4, it aggregate for Profile\_Criteria only, an neither aggregating for keyword nor display it in the outerring, is there anyway to achieve this?

Thanks,  
Cherie

---

<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:** [September 12, 2019, 8:15am UTC](https://discuss.elastic.co/t/kibana-multi-levle-pie-chart-issue/194774/4 "2019-09-12T08:15:27Z")

</div>

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