Having problem with bar charts column displaying

[ppeng]

Hello Community,

I am trying to create a bar chart, which display in x-axis, the qaurter (1,2,3,4) and at the y-axis the percentage from column “OTD” which the “Delivery Status” is Ontime. So it only shows the on time delivery rate. I"m not sure what I have done wrong…

KNIME_praxisprojekt_Truck.knwf (3.8 MB)

Thanks in advance!

Best Regards

[HansS]

Hi @ppeng

When you convert your Quarter column from Number to String you can use it as the Category Column for the bar chart.

gr. Hans

[rfeigel]

Try this. I spent no time formatting the charts, but the prep is what you need.

KNIME_praxisprojekt_Truck w Chart – rfeigel

[ppeng]

Thanks for the help!

I am able to select quarter now. But having trouble to find out how I only display the “ontime” OTD.(Q1: 63,9% Q2: 62,4% Q3: 44,6% Q4:1,6%)

[rfeigel]

If you only want to display “onetime”, filter the onetime rows before the chart.