Hello,
This is my first post here, so hopefully I am posting in the right place.
I have an analysis with which I want to display a bar/line graph. I am trying to display a line to show the change in yes/no rate, while the bars represent the volume of both.
I am using two identical measures, one showing data as values and the other as percentage of the column parent. My table is as I want it (though I just care about the "yes" rate and could make without the "no"l rate) but I cannot get the graph to display what I want.
The line remains at 1% instead of varying according to the rate.
This is with using a "graph pivoted result". I tried with a standalone graph, as well as with using calculated measures, but none of them gave me the results I want.
Could you please let me know how best to achieve my goal? Is there a way to indicate that the line should only show the column "Rate.Yes"?
I am a beginner with OBIEE so my understanding is still very basic.
Thanks.
