topic Re: Display annual change in rate in SAS Visual Analytics

Display annual change in rate

Jazzman — Wed, 19 Aug 2020 18:05:10 GMT

Hello, I'm trying to make my VA report display the change of a rate from last year to this year in percentage points. The rate is a calculated element that is the sum of one column divided by the absolute frequency of the table. When I try to create a new calculated element that divides the rate by the rate of the parallel period I get the error "nested aggregate expressions are not supported. So what is the correct way of doing this in VA?

Re: Display annual change in rate

PetriRoine — Wed, 26 Aug 2020 07:10:51 GMT

Hello @Jazzman ,

Since nested aggregate expressions are not possible you could possibly work around this using aggregated data sources and then data joins.

Best regards,

Petri