Plywood expressions use Druid columns, not Pivot dimensions.
You can build custom dimensions and measures using Plywood. Add a Plywood-based dimension or measure to Pivot by entering it in the Formula field of a New dimension or New measure dialog box. See Creating dimensions and Creating measures for more information.
Before you can build custom dimensions and measures, you must know the following:
- Dimension fields always start with a
$character in custom mode.
- Measures always start with a
$mainobject in custom mode.
- Since measures are always aggregated values, the end result of a custom measure must be an aggregated value.
- Plywood functions are case-sensitive.
- Do not add a
;character to the end of your Plywood expression.
- You cannot build custom dimensions and measures based off other custom dimensions and measures.
Build nested or chained Plywood expressions
You can nest or chain Plywood expressions together. For example, if you are familiar with
case, when, else logic from SQL or any programming language, you can create similar logic in Plywood using
in, then, fallback expressions, like this:
$cityName.in(['London','Aachen','Abbotsford']).then('Match Found').fallback('No Match').
fallback conditions can also contain other expressions, allowing you to create long fallback chains:
($cityName) .match('London') .then('A') .fallback( ($cityName) .match('Aachen') .then('B') .fallback( ($cityName) .match('Abbotsford') .then('C') .fallback('D') ) )