Oracle Analytics Cloud and Server

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

OBIEE 12c Funnel Graphs

Received Response
1
Views
1
Comments
OracleUser_MUC6U
OracleUser_MUC6U Rank 5 - Community Champion

Hi,

I want to display Site Traffic volume data using a funnel graph.  There is no Target values associated so I just want to use the funnel to visually represent the volume figures of each of data types.

Since I don't have Target values each of my stages on the Funnel shows green (default colour) and 100% (don't require any thresholds etc)

Is it possible to change each stage to a different colour?  I'm thinking it will need to be via CSS or hardcoding/hack. 

Also is it possible to remove the percentage figure (100%) from each stage?

Thanks

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That's simply not how a funnel works. You can't force a chart type to magically do what you desire and which goes against its intended usage.

    What you CAN do is adapt your use case to fit the acutal chart:

    Create a new measure which represents the maximum "traffic" - whatever your measure is there - across your currently applied dimensionality and use that as your "Target Measure".

    Like "MAX("Facts - Site Traffic"."Some Traffic Measure)

    Then the funnel will render your data as stages.

    But again: Your idea starts from a wrong assumption. Change that assumption and things will work. Or use a different chart type.