Hello!
I have a variable which contains several variables in the metadata field, I wonder if it possible to make a formula so that by default it shows one metadata field, but, if it’s empty show instead another one (depending on the serie). This value is meant to show in a dynamic table widget that is why I need to “check” the serie.
I do this kind of things all the time in analysis but I would like to know if this could be simplified by using formulas. In pseudocode (supossing serie is an index) would be something like this:

if variable[serie].metadata.variable1 is empty {
display variable[serie].metadata.variable2
}
else {
display variable[serie].metadata.variable1
}

Best regards,

Andrés