Creating Custom Data Fields

For Data Scientists, Visualization Experts, and Excel Formula Architects, the standard Dimensions and Measures may not completely fit your needs. Your story has a deeper level of complexity which requires a deeper connection with the data. Custom Fields give you greater flexibility with your data.

There are 3 types of Custom Fields you can create:

• Custom Dimensions: BLAH 
• Custom Measure: BLAH
• Table Calculations (or Table Calcs): perform mathematical, logical (true/false), lexical (text-based), and date-based calculations on the dimensions, measures, and other calculations in your query. Table Calcs are similar to Excel functions.

Using Custom Dimensions

Using Custom Measures

Using Table Calculations

With Table Calculations (or 'Table Calcs'), you can create metrics on-the-fly. They are similar to formulas found in spreadsheet tools like Excel, and you can perform mathematical, logical (true/false), lexical (text-based), and date-based calculations on the dimensions, measures, and other calculations.

Table Calcs appear as green columns in the data table, rather than as blue columns (Dimensions) or orange columns (Measures).

Taking a simple example, 

Heading 2 looks like this - choose Heading 2 and then change the color to the top row, 5th from the left.

and Heading 3 should look like this - choose Heading 3 and then change the color to the top row, 5th from the left.