SAS VA Bar Chart Rank (Banking Project)

[Suprodip98]

I wanted to show top/bottom 5 zones of total business based on the difference of business as on date and business on last FY.

While calculating the difference I had used sum(by_group) in it and named the variable 'X'.

The variable 'X' is not showing in rank , this is the problem.

Can anyone please guide me on an alternative?

Thanks!

[TeriPatsilaras]

Hi @Suprodip98 

In order to use a date data item in the Rank object, you'll need to use the TreatAs operator to convert the SAS date into a number.  

I have a blog using an older version of SAS Visual Analytics here:  Use Rank in SAS Visual Analytics to display the last date, month or rolling window 

Let me know if you have additional questions.

Thank you,

Teri