FANDOM


In the EDM workspace, there are 6 main sections.

They are the Column Selector, the Data Set Selector, the Spreadsheet Selector, the Condition and Operation Panel, Results Panel and Interactive Charting.

These sections separate and makes it easier to explore the data set.

The Column Selector is on the top left section of the workspace. Columns can be selected by pressing the gray + button. The data set name will appear and by hovering over the data set name, a list of columns belonging to that data set will appear. Select these columns to operate and see the results from them. These columns can be moved by clicking and dragging them vertically to change the order of the columns. The ordering will corresponds to the ordering in the results panel. This is also important for charting because column one corresponds to the first variable which is the X axis variable and so forth. These columns also have button inside of them. The left buttons inside the columns are order by selectors. You can also use these to change the order of the columns. The right side button with the "f" symbol is the aggregation selector. You can select options to aggregate a column into one number. This functionality works properly when there is only one column in the column selector. The "x" button will remove the column from the column selector area. To the right of the columns, the refresh button will need to be clicked every time a new action is to be executed. The button next to the refresh button allows you to export the resulting data set into excel or csv into the downloads folder.

The Data Set Selector is underneath the Column Selector. Here you can select which data set you would want to work on. You can also delete a data set from your account. This is permanent deletion so make sure you have a copy of it before you delete it.

To the right of the Column Selector is the Spreadsheet Selector. Spreadsheets are instances in EDM where your work is automatically saved after each significant action. The gear on the right hand side have a drop down menu to create another spreadsheet, copy the current spreadsheet and delete the current spreadsheet. Click on the tabs to tab between spreadsheets.

Below the Spreadsheet Selector is the Condition and Operation Panel. Here is where most of the data analysis happens. Next to where, the blue words can be changed to all, any, none and not all. These are Boolean logic translated into English. These apply to the conditions in the Condition and Operation Panel. By clicking the Add New Condition, the data set will appear and columns can be selected to have conditions applied to them to filter the results that they will return. Sub queries can also be made to have a filter of a filtered result. To the right of the conditions there are two buttons. The circle button is a toggle. When the circle has a hole, it is active. By toggling the circle button, the condition will grey in and out indicating if it is applied to the results. The x button will remove and clear the condition. The operation selector behaves similarly except it is more a mathematical tool to apply mathematical analysis and other text based analysis to the selected columns.

Interactive Charts

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.