Compare differences over time
- Use keywords — For example, instead of “I want to see all the countries that these airports are in”, try “by airport and country”.
- Use exact wording for field names and values — For example, if your data source includes Airport Code, Airport Name, and Airport Region fields, specify those by name.
- See a ranked list — Ask Data maps terms like “best” and “worst” to Top 1 and Bottom 1, respectively. If you want to see broader rankings, use “high” and “low” instead. For example, enter “houses with low sale prices”.
- Surround unusually long values with quotation marks — To analyze long field values that contain line returns, tabs, more than two words, or more than 50 characters, surround them with quotation marks. To improve performance, Ask Data doesn't index fields of that length.