View the original community article here
Last tested: March 2021
You may be wondering how to plot a dimension on the y-axis of a visualization.
Quick Solution
The quick way to do this is with a table calc involving an existing measure.${dimension} + ( ${measure} * 0)
A similar approach can be taken with this table calc for a String dimensionif(is_null(measure),string_dimension,string_dimension)
More details on this method in the Help Center article here.
Proper Solution
The right way to do this is with an aggregate in LookML.
measure: sum_dimension {
type: sum
sql: ${dimension} ;;
}
This content is subject to limited support.