When working with queries, you may wish to assemble specific columns according to your needs.
Summarise Icon
This is simply achieved by selecting the summarise tool on the upper right-hand side.
Summarised Data
Summarisation settings will appear and from there, you can select what columns you want to summarise and which expression you want to use. Title your summarisation column under the 'Label' section.
Saving changes
Once you have updated the 'Summarise Data' settings, only the selected columns and the newly created column will be displayed. Now you can save the changes in the bottom right-hand corner.
Custom Expressions
You can also create custom expressions if the pre built 'Summarise Expressions' do not fit your requirements. To do this click on 'Create Custom Expression' in the bottom right hand corner. Give your summarisation column a title and then type in what you would like your expression to be. If you are unsure about how to write your own expression, please see Expression Guide HERE.
After clicking 'Apply Settings', only the selected columns and the newly created column will be displayed. Save the changes in the bottom right-hand corner.
Editing Project's name
If you wish to change the name of your project query, you should click on the name shown in the top left-hand side of the page.
