Sums up the specified column only for rows where the condition is true.Įxample: SumIf(, = "Valid") would add up all the subtotals for orders with a status of “Valid”. SumĮxample: Sum() would add up all the values in the Subtotal column. Low standard deviation indicates values cluster around the mean, whereas a high standard deviation means the values are spread out over a wide range.Įxample: StandardDeviation() would return the SD for the values in the Population column. StandardDeviationĬalculates the standard deviation of the column, which is a measure of the variation in a set of values. Returns the percent of rows in the data that match the condition, as a decimal.Įxample: Share( = "Blue") would return the number of rows with the Color field set to Blue, divided by the total number of rows. Presto only provides approximate results. Syntax: Percentile(column, percentile-value)Įxample: Percentile(, 0.9) would return the value at the 90th percentile for all values in that column.ĭatabases that don’t support percentile: H2, MySQL, SQL Server, SQLite, Vertica. Returns the value of the column at the percentile value. Returns the smallest value found in the column.Įxample: Min() would find the lowest salary among all salaries in the Salary column. Returns the median value of the specified column.Įxample: Median() would find the midpoint age where half of the ages are older, and half of the ages are younger.ĭatabases that don’t support median: SQLite, Vertica, SQL server, MySQL. Returns the largest value found in the column.Įxample: Max() would return the oldest age found across all values in the Age column. Duplicates (of the last name “Smith” for example) are not counted. Returns the count of unique last names in the column. The number of distinct values in this column.ĭistinct(). The rolling sum of a column across a breakout. The additive total of rows across a breakout. Only counts rows where the condition is true.Įxample: CountIf( > 100) would return the number of rows where the subtotal were greater than 100. Returns the count of rows (also known as records) in the selected data.Įxample: Count If a table or result returns 10 rows, Count will return 10. Returns the average of the values in the column.Įxample: Average() would return the mean for the Quantity field. They can only be used in the Summarize section of the notebook editor. For an introduction to expressions, check out Writing expressions in the notebook editor.Īggregation expressions take into account all values in a field.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |