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 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:
...
Formulas provide the ability to analyze your data in powerful ways.
Using the formula
...
editor
The formula bar editor is located at the top of every worksheet within a workbook. Select a column on a worksheet and apply a formula with supported Datameer functions and operators.
...
| Note |
|---|
As of Datameer 7.2 The formula bar editor has multi-line functionality. Add more than one line when writing a formula so that it is easier to both read and write long and/or nested formulas.
The multi-line editor can be expanded or collapsed by clicking and holding the edge of the formula bar and dragging your mouse. |
...
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 | ||||
|---|---|---|---|---|
|
...