Page Comparison

• • • 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

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
inspector inspector

Workbook

inspector

Available as of Datameer v6.4

The column 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

Column Column width 80% Information displayed in the column inspector: The name of the column being inspected. The number and percentage of valid and empty rows. A vertical bar chart displays all the different values and their frequency. Mousing over a bar in the chart displays the value(s) and count. If there are over 32 unique number type values, the bars group the values in bins. If there are over 32 unique non-number type values, the vertical bar chart is not displayed. The middle row of statisitcs displays the column's count of unique, minimum, mean, and maximum value. Mousing over a value displays the full value. Number and date field types are display all values. Othe field types display only the unique count. The bottom horizontal bar chart displays the top unique values for the column and their respective counts. Mousing over a bar in the chart displays the value and count. Click the See more link below the bar chart to view additional column values in decending order.

Anchor
inspector_tabs inspector_tabs

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. Image Added 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. Image Added

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.