I have a dataset for API log, we need to see last 7 days API logs but need to exclude weekends . I tried to use day of week date formula in recipe but failed to exclude weekend date . Because output format is numeric. Anyone know workable date formula which valid in recipe in TCRM
5 answers
@Junaid Liaquat But you dont need to convert this field, cause you'll use it just for filtering, not for grouping. For grouping you should use the original date field, and then filter the query by this created field that i mentioned
