Interval Statement

[Anonymous]

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)

[dwforest]

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}>