1
Join
- Activate Join: Select your table, then drag and drop a dimension or metric. Click on the “Joins” icon.
- Set Join Rule: Choose two tables and connect columns using the “ON” clause.
- Select Join: Choose your preferred join (Inner, Left, Right, Full)
- Finalize: Click “Apply Join” to complete.
2
Filter
- Access Filters: Click the “Filter” icon at the top right.
- Choose Filter Type:
- Simple Filter: Select a column, set a condition, enter a value, and click “Apply Filter”.
- Complex Filter: Write a custom SQL query to integrate directly into your SQL code.
- Client Filter: Choose a column (usually client ID) matching your data warehouse tenancy, then click “Apply Filter”.
3
Sort
- Access Sorting: Click the “Sort” icon at the top right.
- Configure Sorting: Choose the column to sort by and select the order (ascending or descending).
- Apply: Click “Apply Sort” to arrange your data.
- In addition to the lexicographical order provided by SQL, you can sort the chart in any desired order using “Complex Sort” with custom SQL.
4
Group By
- Initiate Grouping: Click the “Group By” icon at the top right to group columns.
- Select Columns: Choose the columns you want to group by and click on “Save”.
