Currently the hyperlink function is not supported in Nathean Analytics Spreadsheets, so a workaround has been created.
The workaround is based upon providing 3 fields in the row before the cell containing the hyperlink formula. They must be calculated fields.
Field -1 – URL Field
This is the url which will be used to construct the hyperlink. It should include the query operator “?”.
Field -2 – Query Field
This is the field which will contain the search value for the query and would normally be a field from the dataset in the normal field notication.
It’s recommended that these three columns are then hidden. Once the hyperlink formula also works in Excel, you have a mechanism for the hyperlink to work in both Excel and Nathean Analytics
Field -3 – Message Field
This is the field which will contain the text which will appear in the label for the hyperlink.
eg =“View Data”