3 Replies Latest reply on Jul 16, 2018 12:18 AM by Mahfooj Khan

    Creating Range Buckets using Average per Category ID

    anil kumar


            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.