Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Add the capability to hide non-present values in a Stacked Bar Trellis visualization.
Kattia Binder
Rank 4 - Community Specialist
When using a Horizontal or Vertical stacked bar with Trellis rows or columns, the inner visualization always uses a common axis, so that all inner graphs are viewed on the same scale.
However, when there are multiple values in the axis, the chart should only display Trellis rows with values (or bars) to adjust spacing.
Example:
In this example, each trellis represents a Project Number, and the bars are the expenses by Supplier.
- The Trellis rows should only display the Suppliers with expense amounts (bars) to optimize space utilization. Currently, since all Trellis rows use the entire list of Suppliers (common axis), it becomes challenging to visualize multiple projects effectively.
- Also, when filtering by Top 10 expenses, the Trellis displays the top 10 Suppliers for the initial project and replicates the same 10 Suppliers for the remaining projects, even if they do not correspond to Suppliers with visible expenses (bars) in those projects.
22
Comments
-
Currently the trellis viz isn't useful when a parent/child attribute pair is used. In example below not all X-axis attributes rollup to the trellis column attribute. However, each value is repeated across the trellis column. This wastes real estate and hinders chart clarity.
2