I have a table that records sales in each month for each group. Which looks like below.
Group Sales Period
Apples 20 01/01/2017
Bananas 40 01/01/2017
Citrus 10 01/01/2017
Apples 20 02/01/2017
Bananas 40 02/01/2017
Citrus 10 02/01/2017
Apples 20 03/01/2017
Bananas 40 03/01/2017
Citrus 10 03/01/2017
Apples 20 04/01/2017
Bananas 40 04/01/2017
Citrus 10 04/01/2017
Created a line chart using JET in Oracle APEX 5.1.4 that projects the sales for each group against each month and it is working fine, but have a requirement that says should display the date on x-axis in MM/YYYY for mat only, when using to_char(period, 'MM/YYYY') the graph says invalid data. It is working fine when no format is used on date (full date like 01/01/2017). Tried using pattern on apex jet charts but of no luck.
Need date on x-axis in MM/YYYY format. Please provide me with a working example, I really need this as urgent requirement.
Technology Used: ORACLE-APEX 5.1.4 Charts: APEX JET CHARTS.