To create a new partitioned variable, click + Create partitioned variable. New partitioned variables can be persisted in the output table, and also used in additional queries in the partition section.
Within the method definition, you'll choose one or more variables to Partition on, which defines a set of partitions, each of which contains the rows containing a unique combination of values across those variables.
For example, we can partition on the
provider_statevariables to create a set of partitions, each containing the rows with a given unique combination of
provider_state. Our partitioned variable
average_reimbursement_per_citycomputes a mean of
average_remibursementacross all rows in the partition and assigns that value to every row in the partition. So all records from
AZare assigned a computed
average_reimbursement_per_cityvalue, all records from
AZare assigned a different computed
average_reminbursement_per_cityvalue, and so on.