Creating Range Buckets using Average per Category ID

Hi,

      My dataset has ID's with multiple orders. I am trying to calculate average discount across orders per ID.

      And want to filter by using dates.

      Using the calculated averages I am trying to create a range bucket.

(if [Avg per ID] > 0 and [Avg per ID] < 30 then "Green"

ELSEIF [Avg per ID] <= 30 and [Avg per ID] < 60 then "Yellow"

else "Red"

END )

Then I am counting ID's on the buckets. But when I am trying to filter by dates.

The created calculation is not filtered by dates.

Please help me with solution.