# Creating a pie chart that totals the number of items in a status **URL:** \ **Category:** Get Help\ **Created:** [August 11, 2026, 10:23am UTC](https://community.fibery.io/t/creating-a-pie-chart-that-totals-the-number-of-items-in-a-status/11156 "2026-08-11T10:23:08Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![MemmyMoo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/memmymoo/32/14864_2.png) [@MemmyMoo](https://community.fibery.io/u/MemmyMoo)\ **Post date:** [August 11, 2026, 10:23am UTC](https://community.fibery.io/t/creating-a-pie-chart-that-totals-the-number-of-items-in-a-status/11156/1 "2026-08-11T10:23:08Z")
Hi all, I’m looking to count the number of items that are a specific status and make them into a pie chart. I’m struggling a bit, since I have to create a formula for it but I can’t seem to get the hang of it. What I did, was create a column for status. In it, I can mark an item as completed, in progress, etc. I would just like to count the number of complete items, in progress, etc, and place them all in a pie chart. Could anyone help me figure this out? ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4fb079214b06d1fc7395ed1a3408d9fc49288260.png) ---
**Author:** ![TBSFelicia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tbsfelicia/32/14344_2.png) [@TBSFelicia](https://community.fibery.io/u/TBSFelicia)\ **Post date:** [August 11, 2026, 5:06pm UTC](https://community.fibery.io/t/creating-a-pie-chart-that-totals-the-number-of-items-in-a-status/11156/2 "2026-08-11T17:06:04Z")
If you use Fibery’s built-in Report view, it can count and chart by Status directly: 1. In the Left navigation, use the + icon next to the space where you want the report to live. 2. Click **New \> View \> Report** 3. Select **Pie Chart** 4. Select your Database 5. For **Value** , enter: `Count([your Status field name])` 6. Save 7. For **Type** (color/split), enter your Status field name again You don’t need to fill in anything for **Multiple pies** unless you want to split this into several pies by another dimension (e.g. one pie per Project). That should give you one wedge per Status option, sized by count. ---
**Author:** ![MemmyMoo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/memmymoo/32/14864_2.png) [@MemmyMoo](https://community.fibery.io/u/MemmyMoo)\ **Post date:** [August 13, 2026, 7:20pm UTC](https://community.fibery.io/t/creating-a-pie-chart-that-totals-the-number-of-items-in-a-status/11156/3 "2026-08-13T19:20:22Z")
Thank you so much! The step by step was really helpful, but I got lost at number 7. When you said, “enter your status field name again”, where do I go to add the color/split type? In Value, or Color? So far I’ve done the screenshot in my Value field: ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/ac8f298440c58f24e58e75bcc1ff736e8f1f90aa.png) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [August 13, 2026, 7:22pm UTC](https://community.fibery.io/t/creating-a-pie-chart-that-totals-the-number-of-items-in-a-status/11156/4 "2026-08-13T19:22:24Z")
Put Status in the Color box ---
**Author:** ![MemmyMoo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/memmymoo/32/14864_2.png) [@MemmyMoo](https://community.fibery.io/u/MemmyMoo)\ **Post date:** [August 13, 2026, 7:30pm UTC](https://community.fibery.io/t/creating-a-pie-chart-that-totals-the-number-of-items-in-a-status/11156/5 "2026-08-13T19:30:19Z")
Thank you!! I finally got it, I’m so thankful to all of you. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/c8a8b2fff2a71c68fa99be4499cdfac6ff6dd2fb.jpeg)