Oracle Fusion Data Intelligence Idea Lab

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.

Under Review
72
Views
1
Comments

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
22 votes

Under Oracle Review · Last Updated

Comments

  • Rank 4 - Community Specialist
    edited Aug 27, 2024 6:31PM

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.