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.
Creating formulas
...
Using the formula bar
The formula bar 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.
Formulas can be added manually or using Datameer's Formula Builder.
| Anchor | ||||
|---|---|---|---|---|
|
| Note |
|---|
As of Datameer 7.2 The formula bar 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. |
| Anchor | ||||
|---|---|---|---|---|
|
You can create formulas on worksheets that are editable. When you click the data area of a column that has a formula associated with it, the formula displays above the workbook in the Fx bar. You can also create a new sheet and create formulas that reference fields from other sheets. Click the Fx button on the formula line to display the formula builder. (As of Datameer 7.2, the formula builder is located in the worksheet inspector.)
...
- Click the Fx button on the formula line 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 the Plus icon icon to enter additional arguments (if supported).
- Click Click OK.
The resulting function displays next to the fx icon. To learn more, see see using the Formula Builder.
...
- Click the data area in a column and the current formula if one exists displays above the workbook.
- Create or edit the formula using regular expressions press Enter.
See See Using Regular Expressions to see some examples. Datameer offers an API to extend the built-in formulas. See the Developer's Guide to learn more.
...
- Click the data area in a column and the current formula displays above the workbook.
- Edit the formula and press Enterpress Enter.
Completing Workbook Level Tasks
...