In addition to searching by column names, values, and filters, the search bar also accepts keywords. You can access a complete list of keywords and other reference materials in the reference section or within the help center. Open the help menu by selecting Help from the top navigation bar.
Within the help center, you'll find videos and documentation that correspond to the current version of Trends. This is where you can also find a comprehensive list of keywords. You can expand each section to see which keywords are available and view examples of how to use them effectively.
Example: Simplify Search with the "top" Keyword
The "top" keyword is a powerful addition to your search, and using it can greatly simplify your queries.
Some common search examples that it can simplify include finding the:
top transaction date for the year
top giving donor for the month
top gift made for the week
Types of Keywords
Types of Keywords
Keywords are categorized into different groups based on their purpose, offering a variety of predefined functions. The groups are as follows:
Basic keywords
You can use keywords such as "top" and "bottom" to, for example, only see results for the largest donor or the day with the lowest transactions.
Date keywords
Date keywords allow you to narrow your search by periods like days, weeks, months, quarters, or years. There are also a number of date-related keywords such as "after", "before" and "year-over-year". Use the new date keywords to find giving data for previous periods of time.
Time keywords
Time keywords are most useful when trying to figure out how many donations you've received within the "last n minutes or hours".
Text keywords
You can use text keywords to find similar words or phrases that contain a certain word. For example, "Donor name contains Smith".
Number keywords
These keywords allow you to define your search by aggregations such as "sum", "average", "count", "max", "min", and other accumulations.
Comparative keywords
Filter keywords function similarly to filters applied directly to table columns or chart axes.