Forum Discussion
Tell Us More: Views and Reporting Options in Planner
Hello Planner users!
Planner recently added a "Bucket Chart" to the Charts page, and we're continuing to think about ways to improve this view. I've heard snippets of feedback regarding pain po...
I have what I think is a very cool idea for my team at least. We are using checklists a LOT and love that technology. In the background in the List Tasks function we are pulling tasks and by way of checklist items completed versus created we are creating a percentage of task complete.
I was using Pivot Tables in excel based on all the data I can output from Connector and the CSV output to One Drive and then I tie all that data together in Excel. I will try and attach sample here. However, I can only output 400 items from the Preview Connector for Planner in Flow - not sure why the 400 item limit exists.
Last update of Planner however changed the order of columns in the CSV output so that is a pain. If you look at the PIVOT table tab in the attached you'll see what I'm up to. It is very handy for me for a staff of 11 to be able to see what everyone is working on with this PIVOT.
My best to you and your team - Planner keeps getting better and better - it would be nice to apply a time estimate or an effort rating to each task. We use labels for priority weighting already.
Cheers,
Tim Grim tim.grim@genexservices.com