Interval Statement

Anonymous — Tue, 22 Jul 2025 14:29:37 GMT

I am not able to get this to work. Is my syntax off? I would appreciate your help.

Count(
{$<Interval(EncounterAppointmentDate-ReferralEntryDate, 'D')
={'<30'}
>},
DISTINCT ReferralID_Clarity)

Re: Interval Statement

dwforest — Thu, 21 Dec 2017 21:29:15 GMT

The left side of a set expression can only be a dimension and set expressions are only evaluated once per chart, not per row.

If possible, add the interval statement to the data load script and create a flag that could then be used as $<LessThan30={1}>