Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 MCHK
		
			MCHK
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I have an expression
Count({<Group_Class_Name = {'Pregnancy Essential'}>}groupDate)
How can I amend this so that it counts all Group_Class_Names that include the words 'Pregnancy Essential' As we have different vesions 'Pregnancy Essential:2023, Pregnancy Essential:2024, Pregnancy Essential:Pre natal' etc. I don't want to specify the exact name of each class as I would need to update the expression regularly as new classes are added.
Thank you!
 jochem_zw
		
			jochem_zw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		use double quotes and wildcard
Count({<Group_Class_Name = {"Pregnancy Essential*"}>}groupDate)
 jochem_zw
		
			jochem_zw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		use double quotes and wildcard
Count({<Group_Class_Name = {"Pregnancy Essential*"}>}groupDate)
 MCHK
		
			MCHK
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Thank you, that works. If I also wanted to use this query but to sum the Duration_Hours of those group_Class-Names that match and fall in the groupDate period being searched, how could I amend this?  I would then have the count of classes and also the total duration in hours of the classes that meet the criteria.
 jochem_zw
		
			jochem_zw
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Sum({<Group_Class_Name = {"Pregnancy Essential*"}>}Duration_Hours )???
