Descripción:
In this video we create 2 charts, 1 to compare High,Med,Low with Risk in a project and another to compare Actual Cost Vs. Planned Cost. One of these charts is a pie chart and we separate the data into 3 charts and then do a UNION and combine the data back together to avoid a delegation issue. The other is a Line chart and we use this chart to compare actual cost and planned cost to notice when we spend more than planned cost on a project. Hope you enjoy these videos and design your own charts using some of the skills learned here today. Thanks for watching! Previous Videos Related to this PowerApp: Part 5: Autonumber and Custom Form: https://www.youtube.com/watch?v=pB0-ggXpOls Part 4: Changing Order of Gallery: https://www.youtube.com/watch?v=Tou7Ru370Oo Part 3: Creating Project Center: https://www.youtube.com/watch?v=u7pnqo9TzW8 Part 2: Defaulting Content Types: https://www.youtube.com/watch?v=sQMMKb0UQT4 Part 1: Content Types: https://www.youtube.com/watch?v=KSpoAULE-UY Formula for OnVisible Property: Concurrent(Clear(colRedRisk),Clear(colYellowRisk),Clear(colGreenRisk)); Concurrent( ForAll(Filter(ProjectTasksList,ProjectID=galProjects.Selected.ID,Risk="High"),Collect(colRedRisk,{RTitle:"Red",Risk:Risk})), ForAll(Filter(ProjectTasksList,ProjectID=galProjects.Selected.ID,Risk="Medium"),Collect(colYellowRisk,{RTitle:"Yellow",Risk:Risk})), ForAll(Filter(ProjectTasksList,ProjectID=galProjects.Selected.ID,Risk="Low"),Collect(colGreenRisk,{RTitle:"Green",Risk:Risk}))); ClearCollect(colTaskRisk,CountRows(colRedRisk),CountRows(colYellowRisk),CountRows(colGreenRisk)); //////////////////////////////////////////////////////////////////////////////////////////////////////////// Clear(colActualCost); ForAll(Filter(ProjectTasksList,ProjectID=galProjects.Selected.ID,TaskStatus="Complete"),Collect(colActualCost,{Title:Title,ActualCost:Actual_x0020_Cost,Cost:Budget})); Chapters 0:00 Introduction 2:57 Introduction on Charts 4:40 Why do people use Line Charts? 5:50 Why do people use Pie Charts? 6:30 Writing Collection Statements for Pie Chart 7:05 Concurrent ForAll Filter 10:16 Concurrent Clear Collections 10:47 ClearCollect to Join the Collections in a Union 12:16 Change the ColorSet 14:05 Create a Line Chart 16:00 For All Collect Actual Cost and Planned Cost 17:30 Increate Number of series 18:47 Only Show When Task is Complete 20:00 Testing a New Task 21:50 Discussing Impact and Probability in a Risk 23:04 Conclusion
Preparación de las opciones de carga