topic Re: SAS VA Bar Chart Rank (Banking Project) in SAS Visual Analytics

SAS VA Bar Chart Rank (Banking Project)

Suprodip98 — Tue, 17 Oct 2023 05:41:00 GMT

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!

Re: SAS VA Bar Chart Rank (Banking Project)

TeriPatsilaras — Thu, 26 Oct 2023 22:00:37 GMT

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