Hi Brian, You'll have to identify what it is about the hour that makes it irrelevant. It could be the hour's: · Owner o Name o Team o Custom Data · Project o Task o Issue o Portfolio o Program o Custom Data · Hour Type · Entry Date Once you know what it is about the hour that you don't want, the filter should be easy to set. Do you know what it is? Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank ------Original Message------ Hi everyone,
In excel, there is an easy way to filter the top/bottom X% or show/hide things that are above or below average.
I can't for the life of me figure it out in WF text mode.  My specific example is this:
I am building a Hours by Team bar chart as part of an Executive dashboard.  Some teams' values are insignificant for this view, so I want to filter them out to enhance the focus for this audience (CMO, leadership team).
Can anyone suggest how to EXCLUDE the bottom 10% values? (Then I can learn how to do the inverse as well!)
Thank you!
Brian Brian C. Mauger Bloomberg L.P.