Create bar chart


#1

Hello,

I have tried to create a Bar-Chart but I have some prolems.

I have this:

Table: Items

ItemNo,ItemDescrition
1000,LED Screen
2000,Touchscreen

Table: Orders

CustomerNo,Orderdate,ItemNo,OrderQuantity
100,01/03/2018,1000,5
200,01/03/2018,1000,3
300,01/03/2018,2000,7
400,01/03/2018,2000,5
500,01/04/2018,1000,3
600,01/04/2018,1000,4
700,01/04/2018,2000,10

How could I cread Bar-Chart that will dispay OrderQuantity-sum per ItemNo per day?

So the chart should look like this:

Bar-Chart:

LED Screen XXXXXXXX (8) XXX (7)
Touchscreen XXXXXXXXXXXX (12) XXXXXXXXXX (10)

			01/03/2018			01/04/2018

I think Data-Property of the chart is Orders (getOrdersResult ?)

ValueProperty is orders.Orderdate ?
But when I select getProducsResult as Data-Property then I can not select orders.Orderdate as ValueProperty

CategoryPropery is Items.ItemDescrition ?

And how can I create sum of OrderQuantity per ItemNo per day?

I have tried some combinations but without any success.