# Multiple FIELDS in VALEU section of Pie Chart

**URL:** <https://community.amazonquick.com/t/multiple-fields-in-valeu-section-of-pie-chart/6011>\
**Category:** Q&A\
**Tags:** charts, quick-sight\
**Created:** [September 13, 2022, 1:27pm UTC](https://community.amazonquick.com/t/multiple-fields-in-valeu-section-of-pie-chart/6011 "2022-09-13T13:27:36Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![David\_Wong](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/david_wong/32/15630_2.png) [@David\_Wong](https://community.amazonquick.com/u/David_Wong)\
**Post date:** [September 14, 2022, 5:27am UTC](https://community.amazonquick.com/t/multiple-fields-in-valeu-section-of-pie-chart/6011/4 "2022-09-14T05:27:03Z")

</div>

The thing that you want to measure should go in “Value”. Your categorization, i.e. the slices of your pie chart, should go in “Group/Color”.

If you don’t already have a field that represents the slices of your pie chart, you have to create one. Something like this:  
Category = ifelse(  
{days} \> 365, ‘365+ Days’,  
{days} \> 270, ‘271 to 365 Days’,  
{days} \> 180, ‘181 to 270 Days’,  
{days} \> 90, ‘91 to 180 Days’,  
‘0 to 90 Days’  
)

Then put Category in “Group/Color” and put whatever you want to measure in “Value”.

---

_[View the full topic](https://community.amazonquick.com/t/multiple-fields-in-valeu-section-of-pie-chart/6011)._