Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

biee funnel view rules

Received Response
41
Views
6
Comments
1415129
1415129 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi guys,

   I'm wondering how biee caculate the pencentage of each stage if  i choose Last-stage Only.

   Please check below snapshot as belows(Funnel graph with Last-stage Only, First stage 5 X  final stage target value):

   20161116152851.png

      The first stage i m trying to calc like this: (28/30*5)=0.1867, so this is 18.67% with percentage.

       But for the other stage how it is calculate, such as 84.56%, 55.88%, 84,97% etc.

     

       Apprecatiated if you can share the rules.

Thanks and Regards,

Alv

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Apparently based on the doc there is a constant coming into the calculation:

    Last-Stage Only:Uses a standard shape with equal stage widths. It is similar to standard funnel except that the target values of all the stages before the last is calculated based on the last stage target value and a constant called target factor.

    The simple part is that it's based on last stage target, the unknown part is the "constant called target factor".

    Not really sure where this one come from or how it is calculated (the doc doesn't say anything special on that).

  • Ankita Pangul - BI Developer
    Ankita Pangul - BI Developer Rank 1 - Community Starter

    Hi,

    As you can see in the following screen shot, in funnel view always there is one expected value must be present for each stage. In your case, I think

    pastedImage_1.pngthe highlighted values are getting vary as per order status.

    pastedImage_0.png

    Thank you.

  • 1415129
    1415129 Rank 3 - Community Apprentice

    Yes, i have not found any docs on how to caculate this. That is what i am looking for.

  • 1415129
    1415129 Rank 3 - Community Apprentice

    Hi Pangul,

       What you said is for standard funnel chat, not Last-stage Only.

         Expected value is caculated by obiee automatically. That's  what i am trying to find out.

    Correct me if misunderstood you.

    Thanks and Regards

    Alv

  • Ankita Pangul - BI Developer
    Ankita Pangul - BI Developer Rank 1 - Community Starter

    Hi,

    It is similar to standard funnel except that the target values of all the stages before the last is calculated based on the last stage target value and a constant called target factor.

    Thank you.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    A Pangul wrote:It is similar to standard funnel except that the target values of all the stages before the last is calculated based on the last stage target value and a constant called target factor.

    That's what we already said and all agreed about, the point is what is the "constant called target factor" and where does it come from, what value does it takes and why ...