11-10-2017 03:55 PM
I tried to build two trend lines on one chart in VA.
It is quite successful using calendar year to show monthly scores and YTD scores.
However, our fiscal year starts April each year. If I convert calendar year date to fiscal year date, for an example, convert 4/1/206 to 1/1/2017, fiscal YTD (calculating between April and March) can be shown on the graph. The issue on x-axis is that it shows fiscal month instead of calendar month, which is hard for user to convert back to calendar month. How can I use calendar year month to show monthly score and fiscal year month to show FTD score and in x-axis label showing calendar year month?
The sample data file is listed below