Currently in DPAS Log Team needs to pull a 93 page xls report and filter out data. Once extracted the 93 pages are now 1 xls page. The recommended solution is a front end filter for "Cond CD". The Cond CD has 17 alphabetic codes of which for this report we needed only three codes, H, P, and S.

The solution. Add "Cond CD" filter under Queries/Asset when searching DPAS data.

 

Yes

Reduces time to run metrics report efficiently.

 

Affects any DPAS user pulling excess data.