Functions & Aggregates

QScend Academy Help Sheet Reporting Series

Functions & Aggregates Functions

●

Address Map -​ displays links that generate a pop-up map for the address

●

Age - ​calculates the number of days since the date

●

Coordinates Map -​ display links that generate a pop-up map for coordinates. The expected input is latitude, longitude (concatenated with a comma)

●

Cross Tab -​ breaks out values into new fields

●

Cross Tab (no sort) -​ breaks out values into new fields (does not automatically sort by total)

●

Cross Tab (no total) -​ breaks out values into new fields (but does not create a total column)

●

Date -​ formats values as a date

●

Date (Local) -​ formats values as a date based on local date and time

●

Date/Time -​ formats values as date and time

●

Date/Time (Local) -​ format values as date and time based on date and time

●

File Size -​ shows the file sizes in kilobytes

●

HTML -​ displays the HTML values

●

Lowercase -​ converts all characters to lowercase

●

Mailto - ​displays email address as mailto links

●

Phone -​ formats values as a phone number

●

Proper Case -​ convert values to proper case, with the first letter of each word will be capitalized and subsequent characters lower case

● ●

Remove HTML -​ removes all HTML from values Time -​ formats values as time

●

Time(Local) - ​formats values as time based on my local time

●

Uppercase -​ converts all characters to uppercase

●

Yes/No -​ formats values as Yes and no instead of true and false

●

Zip -​ formats a value as a zip code

Aggregates

●

Average - ​shows the average of all values

●

Count - ​shows the count of all rows

●

First -​ shows the first item found

●

Last -​ shows the last item found

●

Maximum -​ shows the highest value found

●

Minimum -​ shows the lowest value found

●

Sum - ​shows the sum of all values