How to dynamically transform the value from a dataset query resultTopic: Administration
In order to dynamically transform the output of a value returned by a query without changing the data-source you can use the field Value Formatting available in your dimension property.
Dataset contextual window -> Schema -> Select your Dimension -> Value Formatting
In order to extract "John Doe" from a string that is "Prefix - John Doe - Suffix"
You can use the following function:
var my_list = value.split('-'); var first = my_list[list_gestore.length-1] ; var last = first.split('–') ; last[last.length-1]