After creating a workbook and importing a data source, you are now ready to start analyzing the data present in your workbook.
The Formula Builder lets you create formulas by first clicking on a category and then selecting the appropriate function. When you click a function, the Formula Builder provides a description of the selected function along with the required arguments and the types of data supported (such as integer, date, string, Boolean). After choosing which function to use, you then need to enter the arguments into the function. You can either select enter the column from a worksheet in your workbook by adding it into a value field in the workbookinspector, or you can type the column reference into the Formula field at the top of the workbook beside the fx symbol.
If you are familiar with Excel, you are probably interested in the differences between a Datameer workbook and Excel - Tips for Excel Users highlights these differences.
Creating a Formula
...
With the Formula Builder in 7.
...
As of Datameer v6.4
...
1
Click the Fx button in the
fomula bar.
formula bar and Datameer's Formula Builder pops up.
- Select a category from the column on the left and select a function from the list on the right.
- Read the description for the selected function at the bottom of the Formula Builder, or you can click Help to see the online help with examples.
- Enter the arguments as shown in the Formula Builder. To do so, click the column that contains the desired data. The types of arguments required are displayed next to the arguments' names. You can also enter a null argument by typing in null, all lower case.
- If the function supports multiple elements for a single argument, a + (plus) button is available. Click to add additional elements.
- Click OK to finish entering the formula. The results are shown in the column selected in from step one.
| Note |
|---|
The Formula Builder can store up to 5000 characters. If you build a larger query outside of Datameer then paste the query in, the builder accept it. However, if you edit the query, the builder only displays the first 5000 characters. |
Creating a Formula With the Formula Builder as of 7.2
As of Datameer 7.2
- Access the formula builder by opening a workbook, click within the column you would like build a formula, and open the Fx tab in the workbook inspector.
- Select a category from the column on the left and select a function from the list on the right.
- Read the description for the selected function at the bottom of the Formula Builder. Click Online Documentation and Samples for additional information.
- Enter the arguments as shown in the Formula Builder. To do so, type the column that contains the desired data. The types of arguments required are displayed next to the arguments' names. You can also enter a null argument by typing in null, all lower case.
- If the function supports multiple elements for a single argument, a + (plus) button is available. Click to add additional elements.
- Click Add to Formula to finish entering the formula. The results are shown in the column selected from step one.
Editing a Formula
- Click a column in your workbook that already contains a formula.
- The formula is displayed in the Formula Bar - beside the fx symbol at the top of the workbook sheet.
- Edit the formula as appropriate and press enter.
- The results are now shown in the column selected in step one.
...