Swap Columns in a Visualization

In Oracle Analytics, you can swap the columns used in a visualization to explore the data further and discover insights.

If your content author has enabled column swapping for a visualization that has a vertical axis, horizontal axis, or legend, you can change the columns used for those elements.

For example, you might have a bar graph showing Sales by Product Category, where Product Category is on the horizontal axis and Sales is on the vertical axis. This bar graph also shows the breakdown of Customer Segment for each product category using colors and a legend.

Description of the illustration column_swap_example1.png

If column swapping is enabled, you can click the column names Sales, Product Category, or Customer Segment in the visualization and select alternate columns from a list curated by the author. This way, you can explore the data in the visualization based on different column configurations.

If you're swapping columns in an overlay chart, when you click the column name on the vertical axis, you can specify which chart layer you want to swap the column for. For example, if the overlay chart displays a Bar graph and a Line graph, you can select the one you want before you select an alternate column.

The changes you make to the visualization are only temporary for your session, you can't save them in a workbook state.

1. On your home page, hover over a workbook, click Actions, and select Open.
2. In a visualization, click the column name for the vertical axis, horizontal axis, or legend.
3. Select a column from the list of available columns.
   
   
   Description of the illustration column_swap_example2.png
   
   

The visualization changes to reflect the data based on the column you chose. For example, if you swapped Product Category on the horizontal axis for Product Container, the visualization displays the sales values for the product containers instead of the product categories.

Description of the illustration column_swap_example3.png