Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
use double quotes and wildcard
Count({<Group_Class_Name = {"Pregnancy Essential*"}>}groupDate)
use double quotes and wildcard
Count({<Group_Class_Name = {"Pregnancy Essential*"}>}groupDate)
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.
Sum({<Group_Class_Name = {"Pregnancy Essential*"}>}Duration_Hours )???