This content has been marked as final. Show 3 replies
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"
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.