Relatively simple and effective method to modify charts in Oracle BI is to use the editing option marks scale chart. Its lesser-known options - input pomoných lines or stripes - I will try to illustrate a simple example. I created a view: Whose is the result of this bar graph: Select the scale axis and the other choice, select Edit tags scale scale axis. The simplest treatment is to insert an auxiliary graph line or bar at a certain value. The result is a chart: Another option is to insert a line in the instrumental value of a column: First Column will create value by selecting the Advanced options (make hands to the left of the box color). Tick the column name and select the Unit, an auxiliary line is created automatically in the value represented by the first column. For a helping line for the value of the Third column, third column that is already not avoid using the SQL query: The result is a graph where the black line represents value of the first column and third column the value of brown. Of course, for the placement of auxiliary lines in the graph can be used in SQL queries and aggregate functions: Using the gradual aggregation function min (), max (), avg (), work his way up the chart:
Posts
