{"id":138895,"date":"2023-02-18T10:14:12","date_gmt":"2023-02-18T16:14:12","guid":{"rendered":"https:\/\/www.uscho.com\/?page_id=138895"},"modified":"2023-02-18T11:49:59","modified_gmt":"2023-02-18T17:49:59","slug":"pivot-stats-faq","status":"publish","type":"page","link":"https:\/\/www.uscho.com\/pivot-stats-faq\/","title":{"rendered":"Pivot Stats FAQ"},"content":{"rendered":"
How to use USCHO Pivot Stats<\/strong><\/span><\/p>\n USCHO Pivot Stats tool is based on similar principles as a pivot table in spreadsheets.<\/p>\n Step 1: Pick a dataset<\/p>\n You start by picking the dataset to analyze by clicking on the big buttons at the top. USCHO has three datasets at this time.<\/p>\n <\/p>\n An Example using Game time class:<\/p>\n https:\/\/stats.uscho.com\/pivotstats\/division-i-men\/team\/4e3ef01a073f87451df9de9b0387ed65ff85bce9<\/a><\/p>\n You next need to drag fields between the rows, columns and values (what you are trying to analyze). The data will refresh showing your result.<\/p>\n We recommend you run the example by selecting it from the saved configuration dropdown menu to the right of the Team Period Stats button.<\/p>\n How do I get rid of a column I don\u2019t want anymore?<\/strong><\/span><\/p>\n Just drag it back up to the available fields.<\/p>\n How do I start over with my config?<\/strong><\/span><\/p>\n Just hit the Reset Config Button.<\/p>\n <\/p>\n What\u2019s the Values header? <\/strong><\/span><\/p>\n It places all the value fields in columns and allows you to put fields before or after. The result will be a loop through the value of the field and all its values displaying the first value field. Then loop through the second field value\u2026<\/p>\n Notice how it loops through goals, assists and points for freshmen before going to sophomores:<\/p>\n <\/p>\n And if we drag YR (player\u2019s year) below values:<\/p>\n <\/p>\n How do I filter the results by a field?<\/strong><\/span><\/p>\n \u00a0<\/strong><\/p>\n How do I see the detail behind the data?<\/strong><\/span><\/p>\n If you click on a row it will drill down and show you raw data for that row. Click the Back button to return to the list.<\/p>\n How do I save a configuration?<\/strong><\/span><\/p>\n <\/p>\n Hit the Save Config button. A window will pop up where you add a title. Hit the save button. The URL will change to include a unique string.<\/p>\n https:\/\/stats.uscho.com\/pivotstats\/division-i-men\/scoring\/4ae014dd8335bac467c31ad7630c41c75fb68b70\/<\/a><\/p>\n You can bookmark that URL to return or share it.<\/p>\n Why does my save config not show in the dropdown after I come back?<\/strong><\/p>\n \u00a0<\/strong>The dropdown is a list of saved configurations USCHO has flagged for everyone to see. You need to bookmark your save config. It will get added to the dropdown until you change datasets or refresh.<\/p>\n How do I download the results as a spreadsheet?<\/strong><\/p>\n <\/p>\n Click the Export to XLSX button. It will show a download button.<\/p>\n <\/p>\n The file will show in the downloads for your browser.<\/p>\n <\/p>\n The tool is hard to use on a mobile device.<\/strong><\/p>\n Unfortunately, this kind of tool is not well suited for a phone. If you have a saved link it will use a responsive table you can slide right and left.<\/p>\n \u00a0<\/strong><\/p>\n I don\u2019t see a field I am looking for.<\/strong><\/p>\n This is a brand new tool. We will be adding fields and features in time. You can request an upgrade by sending a request via the helpdesk. Requests will help us prioritize fixes.<\/p>\n\n
\n
\n