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”.
Utilizing these features provides a customized and insightful perspective of your data in Databrain.