Last tested: Sep 6, 2019
Quite frequently, a sea of values need to be displayed in a visualization to capture the whole story, such as company growth over time and how different products compare to one another. Sometimes, to answer a specific question, a particular value needs to stand out from the rest. If the value is static, we can always use the filter parameter in the LookML; however, if we want the users to be able to edit the filter to their particular question, we need to use a parameter and a duplicate field.
The process is a variation of our doc on using Liquid Parameters
sql: CASE
WHEN ${original_field} = {% parameter name_of_parameter %} THEN {original_field}
ELSE null
END ;;
This content is subject to limited support.
This use case is exactly what I needed except for one thing. Since the data point I highlight is a special pivot, it is displayed seperately from other data points. How can I sort my data according to their value and not their pivot
Here I want the green line to be among the grey ones, and sort all the lines according to my percentage.