BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
twillkickers
Community Trekker

Make Continuous Delay Filter Select All

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!

 

0 Kudos
1 REPLY 1
txnelson
Super User

Re: Make Continuous Delay Filter Select All

Local Data Filter(
			Add Filter(
				columns( :Reason),
				Where( :Reason != "" )
			)
		)
Jim
0 Kudos