cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
The_blue
Helper III
Helper III

How can i show totals of overdue training?

I've inherited a big Sharepoint list of live data. It's rows of people then columns if training and other stuff its 350 columns wide by 5000 rows... I'm over faced by the numbers 😯

 

 

All the columns 

NameTraining 1: dateTraining 1: StatusTraining 2: dateTraining 2: StatusTraining 3: dateTraining 3: StatusTraining 4: dateTraining 4: Status
Bobetc..Overdueetc..Overdue Overdue Complete
Anne Overdue Overdue Overdue Overdue
Claire Overdue Complete Due Overdue
Simon Overdue Overdue Due Complete
Sarah Complete Overdue Due Overdue
pat Complete Due Complete Overdue
Chris Complete Complete Complete Complete

 

 

I want to see the data in 2 ways

 

1. What's due in a number summary

TrainingDueOverdueTotal
Training 1044
Training 2145
Training 3325
Training 4044

 

2. Needs training:

Training 1
Bob
Anne
Claire
Simon
0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,365)