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:
...
| Note |
|---|
As of Datameer 7.2 Column names have a 255 character limit. |
To edit the column name:
...
You can create formulas on workbook sheets 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. Double-click a column to display the Formula Builder. 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.)
To create a formula using the Formula Builder:
...
- Full results sharing give the admin or owner the ability to give selected groups the ability to view the full data from the workbook.
- Only users that have access to the workbook in from the sharing section are eligible to view the full data of a workbook.
- In order to create infographics or export jobs from a workbook that you are not the owner of, you must have full results sharing permission.
Sharing workbooks with secure data sources
- Users that have permissions to view/edit a workbook but don't have permissions to view/edit the original data source being used in the workbook:
- Can't view the data source worksheet in the workbook.
- Can't view any worksheet in the workbook using data from the data source if the workbook hasn't yet run.
- For workbook users to view/use worksheets that use data from a data source for which they don't have permissions, the workbook must first be run.