Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

X-axis Date Label of Fiscal Year Averages line on double line chart in VA 7.3

Reply
Regular Learner
Posts: 1

X-axis Date Label of Fiscal Year Averages line on double line chart in VA 7.3

Hi, community!

 

I tried to build two trend lines on one chart in VA.

  1. I used custom graph build to build double lines on one chart which includes one line chart and one time series plot. The two lines has shared role of date for x-axis
  2. I used period to date function to build time series plot

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

date         score

1/1/2016    0

1/21/2016  1

2/2/2016    1

2/23/2016  0

.......

 

Thanks!

 Double line.jpg

 

 

 

Ask a Question
Discussion stats
  • 0 replies
  • 153 views
  • 0 likes
  • 1 in conversation