# How do I create a visualization showing how many records there are for each workflow status?

**URL:** <https://community.nextw.com/t/how-do-i-create-a-visualization-showing-how-many-records-there-are-for-each-workflow-status/2153>\
**Category:** Nextworld Platform\
**Created:** [July 27, 2026, 10:31pm UTC](https://community.nextw.com/t/how-do-i-create-a-visualization-showing-how-many-records-there-are-for-each-workflow-status/2153 "2026-07-27T22:31:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ian.p](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/ian.p/32/427_2.png) [@ian.p](https://community.nextw.com/u/ian.p)\
**Post date:** [July 27, 2026, 10:31pm UTC](https://community.nextw.com/t/how-do-i-create-a-visualization-showing-how-many-records-there-are-for-each-workflow-status/2153/1 "2026-07-27T22:31:07Z")

</div>

Let’s say I have the 6 records in a table whose workflow statuses are:  
`DRAFT`  
`ACTIVE`  
`INACTIVE`  
`INACTIVE`  
`ACTIVE`  
`ACTIVE`

Is it possible to build an Info Box visualization for this showing `DRAFT` - 1 | `ACTIVE` - 3 | `INACTIVE` - 2 ?

---

<div class="post-metadata">

**Author:** ![matt](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/matt/32/1514_2.png) [@matt](https://community.nextw.com/u/matt)\
**Post date:** [July 27, 2026, 10:40pm UTC](https://community.nextw.com/t/how-do-i-create-a-visualization-showing-how-many-records-there-are-for-each-workflow-status/2153/2 "2026-07-27T22:40:12Z")

</div>

You should be able to achieve this using:

- Type = Info Box
- Group By Fields = Workflow Status
- Aggregation Fields = Workflow Status (where “Count” is the only selected aggregation option–might be “Total” by default)

---

<div class="post-metadata">

**Author:** ![ian.p](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/ian.p/32/427_2.png) [@ian.p](https://community.nextw.com/u/ian.p)\
**Post date:** [July 28, 2026, 3:29pm UTC](https://community.nextw.com/t/how-do-i-create-a-visualization-showing-how-many-records-there-are-for-each-workflow-status/2153/3 "2026-07-28T15:29:53Z")

</div>

I can’t figure out how to drag the Workflow Status field into the visualization. I’ve added `znwWorkflowInstance` as a field to the underlying table.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/nextworld/original/2X/5/5b07f52c34441acf7a10bb4459aaa5c737b6686a.png)

---

<div class="post-metadata">

**Author:** ![matt](https://sea1.discourse-cdn.com/flex001/user_avatar/community.nextw.com/matt/32/1514_2.png) [@matt](https://community.nextw.com/u/matt)\
**Post date:** [July 28, 2026, 4:08pm UTC](https://community.nextw.com/t/how-do-i-create-a-visualization-showing-how-many-records-there-are-for-each-workflow-status/2153/4 "2026-07-28T16:08:12Z")

</div>

That is a bug (workflow fields aren’t listed in that main side bar because they can’t be used in form layouts but they can be used in visualizations). The work around is to:

1. Use another field instead temporarily
2. Select your application in the Structure
3. Click Advanced - Field Dependencies - Visualizations - Edit Visualization
4. Replace that temporary field with the Status field
5. Click Apply and Exit
6. Save your app and generate