Data for multiple date fields to be displayed in a single line chart.
Hello everyone,
I have a requirement where the data is being pulled from excel sheet and the format is as follows: AOP and Forecast are in the format as shown in the attached screenshot. I have used the cross table concept and have brought in the month columns under one field. Now what I am trying to do is, create a line chart for forecast for F/T/O values that is in the excel sheet like shown in the picture which is related to months under forecast. Similarly we need to have a target AOP trend in the same chart (cumulative), but that corresponds to months under AOP. I am able to show two different graphs for this but unable to combine them under one. How can I achieve this? Is it possible?
Note: At the script side I have loaded months that come under forecast as one table using cross table concept and similarly have also created a separate table for months that come under AOP as shown below.
