Covered in this video is how to create different filter types, including a slider for showing specific tasks for sprint and project work. We also describe how each dataset can be filter independently for each graph within the dashboard.
- [Voiceover] Now, I have the two graphics…built into a single page.…I'd like to further enhance this…by filtering on each of those graphics.…And as you can see, in each of the graphics now,…I have filtering capability to choose what I want.…So, I'm gonna select the Filter drop-down…for Sprint Number, and as you can see,…I have All selected here.…And if I select the check box,…I can even further define that into a single Sprint.…So, if I wanted to include all of the information…that was part of the Task data,…but not part of the Sprint information,…I could deselect everything and just select Null,…and that would give me the work value…for all of the resources associated with the summaries…for non-Sprint activities.…
I can also expand this by just dragging it up a little bit,…and just, in the Sprint one,…repeat that same filtering option,…again, selecting Multiple here…and expanding that out.…And if I was only interested in a specific Sprint,…I could clear this off and maybe, I'll select 1 and 2,…since those are the Sprints I'm interested in,…
NOTE: This course was designed in collaboration with Bonnie Biafore. The techniques shown work equally well with Microsoft Project 2010, 2013, and 2016.
- Explain how to edit a report template.
- Recall how to insert a graph into a visual Excel template.
- Recognize the steps to take in order to add additional functionality into a Visio WBS diagram.
- Determine the steps to expand on a data set in an Excel report.
- Identify three PivotChart tools.