I have a function for building several types of control charts. The only variable in the function is "FilterType":
Local Data Filter(
Add Filter(
columns( :Reason),
Where( :Reason== {FilterType} )
)
)How do I make the function select ALL the ":Reason"s for one of the graphs? I have tried using empty() as the value for reason, but the code throws an error:
All samples have sample size equal to 1. XBar, R and S charts require sample size greater than 1. Switching to default I/MR Charts.
Specified Column not found in data table.{1} in access or evaluation of 'columns' , columns( :Reason ) /*###*/Thanks for any help!
Local Data Filter(
Add Filter(
columns( :Reason),
Where( :Reason != "" )
)
)