Categories
Change colors in bar chart with graph prompts
Hi All,
We need to change the colors of some bar charts to fulfill a requirement provided by our users. We have been able to satisfy the requirement for most of the charts. However, there are a few where our approach is not working - bar charts containing a graph prompt. The prompt only contains two values, and the requirement is to have a different color bar chart for each value. We have tried to use the graph properties > style tab > style and conditional formatting > style formatting tab. But, it only works on column positions. So, for example, we get the same thing for both values in the prompt.
Is there any way to have all columns in each bar chart display as different colors, when a different prompt is selected?
OBIEE 11.1.1.9.x (OBIA 11.1.1.10.1)
Regards,
Charles
Answers
-
One specific solution that may not fit your situation, is to use a Column Selector as one of your dimensions (instead of a dashboard prompt).
In the two examples shown below, I'm using a column selector to control the row dimension in the pivot table.
That enables me to place a Conditional format on all values of "Light Conditions" to be red, or for all values for "Weather Conditions" to be blue.
That works in this example because there are no common values between the two attributes.
The conditional formatting persists, even after the column selection has changed:
0 -
Thanks Jerry. I'm trying it out on my end, but I don't get any column values in the selector. It looks like there is a formula for this particular column/value. It is:
Case, When (SA.column1 <= SA.coulumn2) Then 'Value A' Else 'Value B'.
Maybe the formula is preventing it from fuctioning in the intended way?
Charles
0 -
The column selector has to be built, and it will only accept existing columns from your model.
- Start by adding a new column to your query.
- Open the Add a new view/Column Selector
- Under your new column, check the "Include Selector" box
- Double-click or drag columns from your model into the selector
- Then, you can edit one of those column selections to hold any formula you need.
Unfortunately, this means you have to re-create your existing columns.
As you see below, the Col Selector dialog shows the formula, but the label in the selector drop-down will be the name you place in the formula editor.
0 -
Thanks Jerry. I'm still working on it. Taking a step back though ... one thing I don't understand is that the graph prompt (in this case a formula) doesn't appear in the conditional formatting tab, as an option. Even when I made it into 2 sections, neither one had the column to do conditional formatting. To be clear, there is no column selectors at this time. This is is all under the edit option of the graph. But, when I go to the pivot table itself and edit it, then pick "graph pivoted results", I can find the column/formula in the conditional formatting tab. It almost works that way, but the grouping isn't quite correct.
0 -
The column should appear under conditional formatting by whichever name is currently selected in the Col Selector.
The Col Selector takes a little practice to get familiar with, but it's a pretty powerful tool for the right task.
I hope I didn't lead you into a blind alley. This was just one way I could think of to get where you wanted to go.
0 -
Hi Jerry,
No worries. It sounds like this is a good feature. I'm reviewing some materials on it to get a better understanding. Then, I'll dig back in ...
Charles
0 -
Just an update here. I think we ran into the issues described here:
OBIEE 12c : Does OBIEE Have An Option Of Conditional Formatting Graph Based On Another Column Of The Same Graph Views. (Doc ID 2263081.1)
OBIEE 12c: Custom Heading May Not Be Used For Conditional Format Column (Doc ID 2263628.1)
If that is the case, not much we can do.
@Jerry Casey - thanks for the ideas though. I may be able to use it for other things.
0