Using functions to retrieve outside data

Follow

You can use BIME's calculation engine to retrieve information on data that isn't included in your dataset. This information can include weather patterns, logos, or team names. In the formulas below, you can enter outside data as text in "double quotes." The calculation engine will retrieve information matching the entered text.

This article includes functions for the following:

URLs

You can use the functions below to display information on URLs.

Table 1. URLs
FunctionDefinition
LINK(URL, label) Returns a HTML link pointing to the entered URL.
TLD(URL) Returns the top level domain of the entered URL and any country domain in the URL.
HOST(URL) Returns the host name of the entered URL as a string.
DOMAIN(URL) Returns the domain of the entered URL as a string.

Locations

You can use the functions below to retrieve information on locations. If geographic attributes are included in your dataset, you can add them as attribute fields. You can also type in locations as text.

Note: These formulas are not available for Excel and CSV connections.
Table 2. Locations
FunctionDefinition
GEOCODE(place) Returns the latitude and longitude for the entered location.
LATITUDE(place) Returns the latitude for the entered location.
LONGITUDE(place) Returns the longitude for the entered location.
TEMPERATURE_CELSIUS(place) Returns the temperature of the entered location in Celsius. You can add a date as the last parameter to retrieve the temperature on that date.
TEMPERATURE_FAHRENHEIT(place) Returns the temperature of the entered location in Fahrenheit. You can add a date as the last parameter to retrieve the temperature on that date.
WEATHER_SUMMARY(place) Returns the weather summary of the entered location. You can add a date as the last parameter to retrieve the weather summary on that date.
WEATHER_ICON(place) Displays an icon representing the weather for the entered location. You can add a date as the last parameter to retrieve the icon on that date.

JSON

You can use the functions below to retrieve information on entered JSON.

Note: These formulas are not available for CSV and Excel connections.
Table 3. JSON
FunctionDefinition
JSON_EXTRACT(json,path) Selects a value in JSON according to the entered JSONPath expression. Then returns the value in JSON string format.
JSON_ARRAY_LENGTH(json array) Returns the number of elements in the entered outer array of a JSON string.
JSON_EXTRACT_ARRAY_ELEMENT(json, array, index) Returns a JSON array element in the outermost array of the entered JSON string, using a zero-based index. The first element is positioned at 0.

User and Company

You can use the functions below to display information about the current user or organization.

Note: These formulas are not available for CSV and Excel connections.
COMPANNY_LOGO(company name) Retrieves the organization's logo.
COMPANY_LOGO_URL(company name) Retrieves the URL of the organization's logo.
USER_NAME() Returns the name of the current user (the BIME sign in).
TEAM() Returns the names of team members.
BELONGS_TO_USERGROUPS(Text) Returns TRUE if the current viewer belongs to the entered group.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk