Summarize

Filter and then aggregate columns in a table

The filter is applied first to the table. If no filters are included, then the full table is selected. Next, the table is aggregated.

Parameters

Name	Type	Description	Is Optional
filters	filter_list	Remove rows using filter logic on one or more columns	True
summarize	column_agg_list	Columns to summarize	False
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.	False

Example

internet_sales = rasgo.get.dataset(74)

ds1 = internet_sales.query(
  summarize={
      'SALESAMOUNT': ['COUNT', 'SUM'],
      'CUSTOMERKEY': ['COUNT']
  },
  group_by = ['PRODUCTKEY'])

ds1.preview()

Source Code

RasgoTransforms/rasgotransforms/rasgotransforms/transforms/summarize/summarize.sql at main · rasgointelligence/RasgoTransformsGitHub