Skip to main content

Hi, i have a Bar chart with the time axis on the x-axis and on the y axis how much the money was. Is there a way to break down the y axis graph into the specific vendor_names, there are around ten. 

How could i do it in a view.  Thanks in advance

Hi Louis,

You can do this by adding vendor_name as a dimension to your chart. Here's how you'd set it up in a Celonis View:

  1. Select your Bar Chart: Ensure your existing bar chart is selected in your Celonis View.

  2. Add vendor_name to Dimensions:

    • Go to the chart's configuration panel (usually on the right side).

    • Find the section for Dimensions (or "Breakdown" / "Group By").

    • Drag and drop or select your vendor_name column (e.g., "TABLE_NAME"."VENDOR_NAME") into this dimension slot.

  3. Adjust the Y-axis (Value) Aggregation:

    • Keep your current Y-axis aggregation (e.g., SUM("AMOUNT_COLUMN")). The chart will now automatically calculate this sum per vendor_name for each point on your time axis.

  4. Choose a Stacking Option:

    • In the chart configuration, look for "Stacking" or "Display Options."

    • You'll likely want to select "Stacked" or "Stacked (Percentage)".

      • Stacked: Shows the total money on the Y-axis, with each bar segment representing a different vendor_name's contribution. This is great for seeing both the total over time and individual vendor contributions.

      • Stacked (Percentage): Shows each bar as 100%, with segments representing each vendor_name's percentage of the total for that specific time period….Hope it helps, thank you

 

Reply


Community Code of Conduct