OBIEE 12c Funnel Graphs

OracleUser_MUC6U

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

[Deleted User]

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.