Query
Simple SQL query builder. Helps to do 1 or multiple of these steps:
adding computed columns
filtering your data
summarize columns across rows
sorting your data
The order of operations in the SQL follows the list above.
New_Columns: Takes a SQL expression and adds it to the table as a new column. i.e.: LEFT(ACCOUNT_ID, 5)
Filters: Adds row filters to the WHERE part of the query
Summarize and Group_By: Aggregate a column and group by another column
Order_By_Columns and Order_By_Direction: Order the final table by one or more columns
Parameters
new_columns
math_list
One or more SQL expressions to create new calculated columns in your table
True
filters
filter_list
Remove rows using filter logic on one or more columns
True
summarize
column_agg_list
Columns to summarize
True
group_by
column_list
One or more columns to group by A categorical column by which to pivot the calculated metrics. Including this argument will generate a new metric calculation for each distinct value in the group by column. If this column has more than 20 distinct values, the plot will not generate.
True
order_by_columns
column_list
Pick one or more columns to order the data by
True
order_by_direction
sort_direction
Order the data ASC or DESC
True
Example
Source Code
Last updated