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.
...
If the worksheet's calculations 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:
...
Anchor reorder_column reorder_column
Reordering columns in a workbook
| reorder_column | |
| reorder_column |
...
Anchor sheet_dependency sheet_dependency
Displaying sheet dependency (graph overlay)
| sheet_dependency | |
| sheet_dependency |
...
A formula can only reference columns from it's own worksheet and one other worksheet in the workbook. Referencing columns from different worksheets is possible after a join sheet has first been created.
| Syntax for referencing a worksheet and column | ||
| Syntax | Example | |
|---|---|---|
| Worksheet | # | #apache_log |
| Column | ! | !remoteUser |
| Worksheet and column | #apache_log!remoteUser | |
Writing a function in the formula editor
...
Enter a function name into the formula editor (case insensitive) with variables separated by a semicolon within parentheses.
Example: | Result explained |
|---|---|
| GE(#apache_log!status;400) | The Greater Than or Equal To function is being used comparing the "status" column from the "apache_log" worksheet |
Writing nested functions in the formula editor
From the formula editor, you can enter functions and operators within functions.
| Example | Results explained |
|---|---|
| IF(EQUALS(#apache_log!status;400);"Bad Request";"other") | The IF function is being used with the Equals function as one of the variables. |
| Anchor | ||||
|---|---|---|---|---|
|
...
| Anchor | ||||
|---|---|---|---|---|
|
Production mode can be applied to a workbook to accelerate performance by skipping the calculation of metrics used for columnmetric, flip sheet displays and generation of data samples.
To launch production mode for a workbook:
...
Sheet summary information gives advanced information on individual pages within the current workbook including the following:
| Sheet type | Sheet type | Description | Job path | Connection | Last executed | Kept | Partitioned | Formulas used | Filter source | Filter connector | Filter arguments | Join type | Join pairs | Sort source | Sort arguments | Sources of union |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Source sheet | x | x | x | x | x | x | ||||||||||
| Formula sheet | x | x | x | x | ||||||||||||
| Filtered sheet | x | x | x | x | x | x | ||||||||||
| Joined sheet | x | x | x | x | x | |||||||||||
| Sorted sheet | x | x | x | x | ||||||||||||
| Union sheet | x | x | x | x |
To view workbook details:
...