6 Replies Latest reply on Aug 11, 2020 2:07 PM by Joe Choueiri-Oracle

    Case Statement that is not generation a list of values

    Joe Choueiri-Oracle

      Hi

      Need your help, not sure if I have been through his before but can not recall.

       

      This is my case statement

      CASE

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" > 10000000 THEN '1. > $10M'

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" BETWEEN 5000001 AND 10000000 THEN '2. $5M-$10M'

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" BETWEEN 1000001 AND 5000000 THEN '3. $1M-$5M'

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" BETWEEN 500000 AND 1000000 THEN '4. $500K-$1M'

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" BETWEEN 350000 AND 500000 THEN '5. $350-$500K'

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" BETWEEN 200000 AND 350000 THEN '6. $200k-$350k'

      WHEN "Fact - Country Bookings Non-OU Opportunities"."USD Amount" < 200000 THEN '7. < $200k' ELSE '7. < $200k'

      END

       

      But for some reason, if I try to filter on any of the values, I get this, no drop down with values

      Which causing also not to see most values when I try to create a prompt with this case statement, any idea?

       

      My goal is to create a prompt with this statement and end up with checkboxes where users can check <200k or/and 200k-350k etc

       

      Thanks

      Joe