Page | 1 Features Available in ATTAINS Summary Reports Version: 8/12/2019 - This corresponds with the July/August 2019 release of ATTAINS Purpose: To explain some of the new features available in the Assessments, Uses, Parameters, and Sources Summary Reports. These features include the ability to add columns to a report, filter results, and download the filtered results. Audience: Any ATTAINS user with access to an Organization. These features are available for users with Read Only access or higher. 1. Login to ATTAINS. 2. If you are an EPA user, select an Organization from the top right drop-down menu. State or Tribal users only have access to your own Organization, so you can skip this step. 3. Go to the Reports tab. {£)• % Home Assessment Units Assessments Actions Reports M Priorities Surveys Administration Cycle Summary Report type* Report* Cycle Summary Parameters Cycle" 2018 - Organization Draft (In Progres * Run Report 4. In Report Type, select "Cycle Summary". In the Cycle drop-down, select the snapshot or working copy you would like to summarize. In the Report drop-down, select either Assessments, Uses, Parameters, or Sources. Summary Report Options This example will show the Parameters Summary Report, but the same functionality exists for the Assessments, Uses, and Sources Summary Reports, except as noted below. 5. The report returns a bar chart (letter A in the graphics on the next page) and a summary table (letter B) at the top, and a results table (letter E) at the bottom. (The Assessments report returns a pie chart.) ------- Page | 2 Assessments Uses Parameters Sources Delistings Measures ~ Parameters A ENTEROCOCCUS [ EUTROPHICATION CHLQROPHYLL-A || 1,1,1,2-TETRACHLOROETHANE SALINITY P FECAL CO LI FORM F DISSOLVED OXYGEN ~~ CAUSE UNKNOWN ~ 1,2,4-TRICHLOROBENZENE F ESCHERICHIA COLI (E. COLL. B TOTAL SUSPENDED SOUDS (T... B CHLORINE ALUMINUM _ LOW FLOW ALTERATIONS ~~ SELENIUM | SEDIMENT Parameters Summary Parameter t Cause t Meeting Criteria Observed Effect" TOTAL ENTEROCOCCUS 4 0 0 4 EUTROPHICATION 3 0 0 3 CHLOROPHYLL-A 3 0 0 3 1,1,1,2- TETRACHLOROETHANE 1 1 0 2 SALINITY 2 0 0 2 1 2 3 4 18 F G ::: Columns © Download Assessment Unit ID ~ Assessment Unit Name " Parameter Name Parameter Status Use Name ; Use Attainment Parameter Attainment * ' ' 123456789 TEST DISSOLVED OXYGEN Cause Coldwater Permanent Fish Life Propagation Waters Not Supporting Not meeting criteria 123456789 TEST 1,1,1,2- TETRACHLOROETHANE Meeting Criteria Coldwater Permanent Fish Life Propagation Waters Not Supporting Not enough information 123456789 TEST CAUSE UNKNOWN Cause Coldwater Permanent Fish Life Propagation Waters Not Supporting Not enough information 123456789 TEST 1,2,4- TRICHLOROBENZENE Cause Coldwater Permanent Fish Life Propagation Waters Not Supporting Meeting criteria CCBA-L- FREEMAN_01 Freeman Lake ALUMINUM Cause Fish and Wildlife Propagation. Recreation, and Stock Watering Waters Not Supporting Not meeting criteria 2 3 4 5 6 » H a J 28 Records Bar chart (letter A): Mouse over the bar chart to see the legend for each bar, including the label and count for each section. Scroll down the bar chart to see additional results. Summary table (letter B): This table summarizes the results. a. The first 5 results are shown. Additional results can be seen by moving through the table pages (letter C). Or, you can click on the numbers in the bottom right of the summary table (letter D) to toggle between 5 results or a larger number or results per tabular page. ------- Page | 3 b. This table is sortable using the up and down arrows in each column name. The search boxes below the column name can be used to search for a specific value. 8. Clicking on a bar in the chart or a row in the summary table will filter the results table based on the selection. The number of records shown in the results table (letter J) will change to reflect the number of filtered results. a. To remove a filter that has been applied to the chart or summary table, click the Clear Selection button. You may need to manually remove any additional filters that have been applied to the results table at the bottom. b. Note: Clicking on the Assessments pie chart or summary table does not filter the results table, but the results table can be filtered by using the drop-down above in the IR Category field of the results table. 9. Results table (letter E): The results table is broken into tabular pages. a. Use the page controls (letter H) to navigate through the table, or switch between 5 records and a larger number of records using the numbers in the lower right (letter I). b. Note: Clicking on one of the links in the Assessment Unit ID column will take you to that Assessment record. If you want to download your data, do so before you click on one of those Assessment Unit IDs, because that will navigate you away from the report. Returning to the report will regenerate the report. 10. Adding Columns (letter F): You may choose additional columns to add to the results table. Click the Columns button. a. The optional columns vary depending upon the Summary report. The options for each report are shown in a separate section below. b. Note: As you add columns, you may need to use the horizontal scroll bar to see additional columns. 11. Downloading results (letter G): Once you have the data the way you want (e.g., have added the columns that you want, and applied filters if you would like), using the Download button will export the results table to .CSV format. If you want all the results from the table, remove the filters. ------- Page | 4 Additional Column Options Each summary report has different options for columns that may be displayed or hidden. Screen shots of the columns available in each report are provided below. Gray check marks are for columns that are locked and cannot be turned off. Additional fields are turned on by default (black checks) but may be hidden (i.e., unchecked). The empty boxes are fields that may be turned on. Select your choices and click the Save button. Assessments Summary Report Columns Assessment Unit Assessment Unit ID H Assessment Unit Name ~ State Code ~ Use Class Name Assessment Unit Status ~ Agency Code Location Description o Assessment Unit Comment IS EPA IR Category o Multi IR Categories Assessment Rationale 0 Water Type Water Size 0 Units Size Source ¦ Source Scale Estimation Method IS Cycle Last Assessed 0 Cycle Last Modified Cancel Uses Summary Report Columns Assessment Unit Use * Assessment Unit ID El State Code C Assessment Unit Status SJ Location Description ~ EPA IR Category ~ Assessment Rationale C Water Size J Size Source D Estimation Method Cycle Last Modified J Use Name IS Threatened D Assessment Basis ~ Monitoring Start Date 0 Use Agency Org Qualifier Flag O Use Comment Assessment Methods ¦t Assessment Unit Name B Use Class Name U Agency Code ~ Assessment Unit Comment L Multi IR Categories 0 Water Type SJ Units Source Scale ~ Cycle Last Assessed ' Use Support IS Use Org IR Category L! Assessment Date Monitoring End Date 0 "Trend Assessor Name 0 Assessment Types Save Cancel ------- Page | 5 Parameters Summary Report Columns Assessment Unit Assessment Unit ID 1/ Assessment Unit Name 0 State Code Li Use Class Name i Assessment Unit Status Li Agency Code LI Location Description [ 1 Assessment Unit Comment D EPA IR Category L Multi IR Categories [ 1 Assessment Rationale Li Water Type D Water Size Cj Units £ Size Source I 1 Source Scale ~ Estimation Method L Cycle Last Assessed L Cycle Last Modified Parameter '<* Parameter Name I* Parameter Status D Parameter EPA IR Category 1 1 Delisted ' Use Name ' Use Attainment bfl Parameter Attainment L Parameter Trend O Seasons(Start-End) Li Pollutant Indicator Li Cycle First Listed Cycle Scheduled for TMDL ~ Cycle Expected to Attain ~ Organization IR Category U Impaired Water Agency Li Alternate Listing Identifier L i CWA 303(d) Priority Ranking El Consent Decree Cycle Impaired Water Comment Cancel Sources Summary Report Columns Assessment Unit /i Assessment Unit ID ® Assessment Unit Name ~ State Code Use Class Name U Assessment Unit Status C 1 Agency Code ~ Location Description Li Assessment Unit Comment ~ EPA IR Category LI Multi IR Categories ~ Assessment Rationale C 1 Water Type ~ Water Size U Units ~ Size Source Li Source Scale ~ Estimation Method ~ Cycle Last Assessed ~ Cycle Last Modified Source w Source Name Si Confirmed ' Associated Cause Name O Source Comment Save Cancel ------- |