I want to create a list box and remove the values that dos not have any available data. I have tried a few different formulas with no success. For instance if AM Compliance doesn't have any available data I don't want it to appear in the list box.
May be create a flag in the script...
LOAD If(Len(Trim(Field1&Field2&Field3.....&FieldN)) = 0, 0, 1) as DataFlag,
and then this as your calculated expression for list box object
Aggr(If(Max(DataFlag) = 1, Region), Region)
Retrieving data ...