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.