In Datameer, you can create a workbook to get to new insights with your data. Inside the workbook, you can add additional data sources, change the column and sheet names, collapse columns, apply formulas, view workbook details, and more.
...
| Anchor | ||||
|---|---|---|---|---|
|
...
As of Datameer v6.4
Status notifications have been added to the bottom of workbook worksheets to show if the worksheet is dispaying information based on sample or full data and if the worksheet is filtered.
Sample data messages
If the worksheet's
...
calculations are based only on sample data, the notification is orange. It tells you how many sample rows are being displayed in the worksheet and that you can run the workbook to display the sheet
...
calculations based on the full data from the data source.
If the worksheet is displaying no information, this could be that none of the origial sample data fits the criteria of the caculations. Running the workbook takes into account all current worksheet caculations and might bring in new sample data to populate the worksheet if data from the data source meet the caculation criteria.
Full data messages
If the worksheet's caculations are based on the full data, the notification is green. It tells you how many sample rows are being displayed in the worksheet out of how many total records from the data source. If all the records of the source are being used, the status bar displays the total record count.
Opening Existing Workbooks
To open an existing workbook:
...
- Open the workbook you want to import the worksheet into.
- From the Workbook menu, select Add Data, or click the Add Data icon on the toolbar.
- Select the workbook you want to use and click Add Data.
- Select the sheets you want to import and click Add Data.
- The new worksheet tabs are added to the right of the existing worksheets.
Suggested column names
Datameer creates suggested column names when the user creates new columns using the Formula Builder.
These names are based off the column name used in the formula and the type of formula used.
If you want to change these names refer to setting up column names.
...
| Anchor | ||||
|---|---|---|---|---|
|
| Note |
|---|
Available as of Datameer v6.4 |
To access the cell context menu, right-click on a cell within a workbook.
...
- Column text color
- Column background color
- Column text alignment (right, left, center)
- Numbers
- Thousands separator (comma to separate numbers by thousand)
- Select the amount of decimal places to display in the workbook
- Date
- Input a parse pattern to display the date. (The default doesn't display milliseconds)
Shading rows in a workbook
The worksheet highlights rows by each group series when a GROUPBY function is used.
Copy cells
| Note |
|---|
Available as of Datameer version 6.3. |
Double-click a cell to select it, and then right-click it and select Copy Cell Content to copy its contents to the browser's clipboard. This functionality doesn't work with the Safari browser.
| Anchor | ||||
|---|---|---|---|---|
|
The inspector gives you important information about the data of each column in your workbook. Use this feature for quick insights into the data that each of your columns contain.
| Section | |||||||
|---|---|---|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
| Note |
|---|
As of Datameer 7.2 There are two tabs at the top of the workbook inspector. The inspector is separated at the worksheet level and column level. The worksheet level tab has a description box where text can be entered about each worksheet in the workbook.
The column level tab has a description box where text can be entered about each column of a worksheet. Below the description box, the column information is as described above.
|
To open or close the workbook column inspector:
- Click View in the menu bar and select/unselect Inspector.
- Click the Inspector icon in the tool bar.
Revert Actions
If you would like to revert an action that you performed in a workbook, you can use the Undo and Redo buttons available in the toolbar. By default, you can undo or redo the last two actions performed on a workbook that modify the workbook state in the database. These actions don't include changes such as font style or column size, as the workbook's state remains the same. You can also access these options through the Edit menu or using keyboard shortcuts (Cmd+Shift+Z for undo, Cmd+Shift+Z for redo). If the cursor is in a text field, using the keyboard shortcut reverts only the most recent changes in the text field, not the whole workbook.
Administrators can adjust the settings for these buttons in default.properties and system.properties. There, admins can edit the amount of time the history of a workbook is kept, the maximum number of actions a a user can revert, and how many workbooks can retain a history at the same time.
To make sure this functionality isn't causing performance issues, you can check various statistics about the memory usage and workbook states in <Datameer>/logs/workbook_undo.log. The log is set to record the following values separated by comma:
absoluteMemoryConsumption,absoluteMemoryUsageInBytes,generalMemoryUsage,historiesInUse,historyStatesInMemory,maxMemory,relativeUsageInPercent,usedMemory,usersWorking,workbooksInUse
All undo related actions are collected, but for memory performance, the system prints the values to the log once per minute.
...
To create a formula using the Formula Builder:
- Double-click the data area in a column and the Formula Builder opens. Or you can click the FxClick the Fx button on the formula line . (As of Datameer v6.4, click the Fx button to access the formula builder.)
- Select the categories in the left column to choose the type of function.
- Choose a function from the list on the right.
- Enter the argument or arguments shown for that function. You can click a sheet and select a column.
- Click the Plus icon to enter additional arguments (if supported).
- Click OK.
...
- From the File menu, select Save, or click the Save Workbook icon on the toolbar.
- Navigate to the folder where you want to save this workbook or choose to save the workbook in a new folder.
- Enter a name in the Save as field.
- Click Save.
- Fill in workbook settings:
- Select the appropriate trigger for when the workbook runs.
- Select data retention method for how long workbook runs is stored.
- Write a workbook description.
- Select which sheets need to have results saved. Storage space is saved by only selecting useable data.
- Specify how to deal with errors in workbook formulas.
- Add email addresses that receive a notification if the workbook experiences an error or each time the workbook preforms a successful run.
- Add custom Hadoop or logging properties.
- Select if the workbook should first run immediately after saving.
- Click Save when you are finished.
| Note |
|---|
As of Datameer v6.4 Steps 5 and 6 are no longer needed to save a workbook. If workbook settings need to be updated after saving, right-click on the workbook in the file browser and select Configure. |
If workbook settings need to be updated after saving, right-click on the workbook in the file browser and select Configure .
From the File menu, select Save As, or click the Save Workbook As icon on the toolbar.To save a copy of a workbook:
...
- Navigate to the folder where you want to save the workbook, enter a name, and click Save As.
...