View the original community article here
Last tested: March 2021
Anytime you have an aggregate that returns a string. A common example is a
listagg, though you could also concatenate two measures into a single string for aesthetic value.
The docs explain this in more detail.
This content is subject to limited support.