I have a column for status. Status is a choice type column with three choices 'Not Started', 'In-Progress' and 'Completed'. Let's say in this list I have 5 items. Each item will have a status. Let's say these status values for 5 items are [Not Started, In-Progress, Not Started, Not Started, Completed].
In Nintex form, I have created three calculated value control fields: Number of Not Started Items, Number of In-Progress items and Number of Completed items.
How can I use lookup to calculate the number of Not Started, In-Progress and Completed items? In our case, there are 3 Not Started, 1 In-Progress and 1 Completed Status item. I would like to calculate these numbers using the same sort of functionality that may be calculated value field. Please let me know if there's more easier or better way to do it.
So you have a list with a status column which is a choice column with three options 'Not Started', 'In-Progress' and 'Completed'
When the column has data it would look like:
So create a view in SharePoint which shows the count for each status.
Group by the Status column.
When choosing this view in SharePoint it will look like the screen shot below which shows the count for each status.
In the Nintex forms add the list view control to your form.
List View Control Configuration:
When creating a new form you will see the following which will give you the counts that you are after.
Hope this helps.
This is a trivial thing depending on your circumstance.
Are you using Classic Forms?
Is there any relationship between the Items with Statuses, and the Item containing the Form you'd like to use to show those Items? (That is: Is it a Single Parent Item that is tracking the statuses of 1 or more Children Items on a different list?)