Custom Fields - an introduction
Create a Custom Field (custom-calculated column) to add and test out new useful fields in a single table- without affecting your source data.
All types of users can create fields that may be useful for analysis, and test out the best way to tidy their table data without the need for a developer's time. Custom fields let you create charts and build dashboards to meet the needs of 'the last mile' of data analytics.
Changes may include creating a new column that displays data without commas, has trimmed spaces, or replaces month names with numbers.
This isn't creating measures - it allows you to transform your table data in the best way for your dashboard.
Custom column key facts
Calculated columns are always added to a single table. You can't share the custom field across multiple tables.
You can create multiple custom fields for more than one table, but only one table at a time.
Custom fields are derived from the columns in each table.
Astrato transforms the data for every row for a new column that you create.
These changes are kept in the semantic layer. That is, the custom field is only saved in Astrato - not in the original database content. If you find it's a really useful field, you may want to add it to your source data to use as a dimension available to all your charts.
Creating a custom field
1. In the Data layer view, click on the ⁝ Icon on the table header, and select view table.
2. Click on the Custom Field button in the top menu.
3. Select the type of Custom Field you want to create by clicking on the Fx icon, and the selected type.
There are four different types of custom fields:
Text- a free text editor, this field type supports any SQL code calculated on the row level. Sub-queries are not supported. - coming soon
String- Simple string functions
Date- Extract date parts from a date\timestamp field.
Calculation- define calculations using numeric fields. The mathematical operator's order is respected.
4. Give the field a unique field name and click create.
Viewing your new column
1. After you click Create, you return to the view where you were before creating the custom field.
2. Scroll to the right to see the new field and a sample of the values.
3. Your new column is added as the last column in the table.
Editing or deleting a custom field
1. View the table
2. CChange the view to fields in the top bar
3. Scroll down to the bottom to view your custom fields.
4. The column on the right displays a 'trash' bin to delete the custom field and a pencil to edit the measure.