Joins , Filter, Sort, Group By

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.

• 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.

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".

Utilizing these features provides a customized and insightful perspective of your data in DataBrain.