Data Explorer is a tool that allows you custom data exports by allowing you to select from available data groups and fields to create a query that can then be run and exported. The query can then be saved as a Layout to quickly use again.
To create a queryuse Data Explorer:
In eGenuity, select the Business Management tab.
Select Data Explorer. Data Explorer will open.
In the Views field, select the group that best describes the type of information you are wanting. ( The Layouts field is set to the default layout. After creating your own layouts, they will appear in the dropdown list.)Views available are not customizable. Layouts, however, can be customized and saved.
All available fields are listed and marked as “visible”. Click in the Visible column may be checked or unchecked.. You may want to click the Hide All Columns button to hide all in fields for the query and then select only the ones to be included in the query.
Some fields will require entering additional informationallow you to further filter query results. For example, a Date field will require allow for a date range for the query. The Operator is set to “Between” and then Value #1 nad and Value #2 are the beginning date and end date.
Note: If you want a date to be included, select the day after as the end date being that 12:00 a.m. is the of the date selected is the beginning and ending times.
After all query options are complete, click on the Run Query icon on the menu bar.
Review the query results. The results rows and columns can be further edited. You can:
Resize the columns;
Sort data by any of the columns;
Filter results further by using column filters;
Group results by column header.
After data is as needed, you can:
Print preview the results;
Export results as an Excel file;
Export results as a CSV file;
Limit the number of rows to export.
If the data parameters will be needed often, the layout can be saved by clicking the Save icon. Loyouts can be deleted by selecting them and then clicking on the Delete icon.
