Using Super columns in your Queries
Super columns can be added to your Query to manipulate your data in other ways.
There are 3 types of Super columns:
- Number - Use basic formulas to create new data using static values and column data
- Text - Transform text columns into a new format
- Date - Extract or reformat date elements from a date column
Super columns are new columns that get added to the Query. They are not added to the original dataset and they don't change the existing data in anyway.
To add a Super column, simply click on the 'Add Super column' button just above the data table, give it a name and select a Super column type to get started.
Number Super columns
Number super columns can be used to create dynamic formulas in your Query. You can combine the data from your dataset together, or add in hard coded numbers to create new values.
Any number columns in your dataset will be listed in the Data columns section which you can use to create formulas to generate new data.
Super columns will be added to the right side of your dataset so you may need to scroll to the right if you have a number of columns already displayed.
NOTE: If you have applied calculations, filters or groups, the only columns that will be visible in the Data columns section will be the ones used in the calculation, filter or group.
More Super column content coming soon