Count of Items in List Meeting Criteria

[Shashank Achanta]

I have a list (Tracker) with columns for User Name and Status.  I am looking to create a table in another page which shows count of items assigned to a particular user and their status.

For Examples -

User Name	Completed	In Progress	Not Started
User 1	4	2	1
User 2	8	0	1

How do I achieve this?

[#2]

I can think on the following ways:
(1) By means of some custom code that read your tracker list, make the count calculations and shows the data in the format you want
(2) Same idea, but using PowerApps instead...the downside of PowerApps approach is that you don't have a way Today (it's coming) to add a PowerApp in a SPO page

[#3]

I would try to add 3 calculated columns, like

Column name: Completed - Value: =IF([Status]="Completed", 1, 0)

Column name: In Progress - Value: =IF([Status]="In Progress", 1, 0)

Column name: Not Started - Value: =IF([Status]="Not Started", 1, 0)

Then use some JSLink to be able to Sum on the calculated columns, and finally create a view grouped by UserName, and with totals on all calculated columns

https://social.technet.microsoft.com/wiki/contents/articles/30317.sharepoint-2013-displaying-sum-for...

For JSLink Info related to SharePoint online:

https://social.technet.microsoft.com/wiki/contents/articles/37203.sharepoint-online-customize-list-v...

[#4]

Hello Juan,

Would you be able to help with achieving the below -

(1) By means of some custom code that read your tracker list, make the count calculations and shows the data in the format you want