How to compare conversion by price bracket

[AC921]

Hello, 

I am comfortable comparing metrics, such as orders and AOV, by price brand using a segment.

For example between £30 and £1000: HIT Revenue is greater than or equal to £30 AND Revenue is less than £1000. 

However, this doesn't work for conversion as it shows at 100%+. Does anyone know how to compare conversion rate by price brand?

Many thanks

[Jennifer_Dungan]

While I am not sure what sort of conversion you are looking for here, you should be able to do a calculated metric using nested IF statements and Greater Than or Equal To and Less Than or Equal To in order to form your "bucket"

Something like:

IF [

    Logical Test [

        Greater Than or Equal [

            Metric X - Revenue

            Metric Y - Static Number 30

        ]

    ]

    Value_if_True [

        IF [

            Logical Test [

                Less Than or Equal [

                     Metric X - Revenue

                     Metric Y - Static Number 1000

                 ]

            ]

            Value_if_True [

                Value That You Need Here (Not sure if this should be a 1 for a purchase in this bucket? Or something that makes more sense to your conversion)

            ]

            Value_if_False [

                 Static Number 0

            ]

        ]

    ]

    Value_if_False [

        Static Number 0

    ]

]