OBIEE11g -- changing Gauge view scale properties

Recently I was working on Gauges design and I had to display %Ratio of the % column in gauges. It looks straight forward requirement but could not find out a way to change % display on scales to data values easily.

searched google/helps, but could not solve it. My % Ratio column shows %of total in scales which makes no sense for the user to analyze it.

1. This is what being displayed at first when you pull the column in the Gauges view.

2. I thought there will be an option available in properties to change the % values to actual values. Tried multiple options under Layout/Settings but no change on the scales, yet :-(

3. Then I clicked on Edit Gauge Properties Properties and looked at all the options. Went through all the options like Style, Scale, Titles and Labels but no luck.

4.  Did I miss something? Well, Yes. Going through the options again, I show options called Scale Labels in Titles and Labels. Initially I thought it would be only for the formatting of the scale.

Along with options of Font/Number Format, this also gives you an option of "Display Options". Here I could change Scale Labels to Actual Values instead of Default (Percentage of Total)

5. After making this change, I could achieve my guage layout as expected. Wow, there was no bug :-). I feel, placement of this option should be placed at the first tab under Gauge properties :-).




Cheers...