Hello i have the following salesforce query. q = load "Utilization"; q = filter q by 'IsReportMaster' == "true"; q = filter q by 'UtilizationCalculationName' in ["Planon LM, CM & NM Weekly", "Planon: LY, CY, NY monthly & yearly"]; q = group q by 'UtilizationCalculationName'; q = foreach q generate 'UtilizationCalculationName' as 'UtilizationCalculationName', count() as 'count'; q = order q by 'UtilizationCalculationName' asc; q = limit q 2000; I would like that in filter: UtilizationCalculationName, both values: ["Planon LM, CM & NM Weekly", "Planon: LY, CY, NY monthly & yearly"]; will be selected by default. Can you help me?
Yes, I can help. To select both values by default in the filter, you can modify the filter statement as follows:

"""q = load "Utilization";
q = filter q by 'IsReportMaster' == "true";
q = filter q by ('UtilizationCalculationName' == "Planon LM, CM & NM Weekly" or 'UtilizationCalculationName' == "Planon: LY, CY, NY monthly & yearly");
q = group q by 'UtilizationCalculationName';
q = foreach q generate 'UtilizationCalculationName' as 'UtilizationCalculationName', count() as 'count';
q = order q by 'UtilizationCalculationName' asc;
q = limit q 2000;
"""

The above code will select both values in the filter by using the or operator in the filter statement. The rest of the code remains the same.