Rank on SAS VA cannot choose measure from aggregated measure

nic2 — Fri, 13 Aug 2021 09:00:27 GMT

Re: Rank on SAS VA cannot choose measure from aggregated measure

Sam_SAS — Mon, 16 Aug 2021 14:08:39 GMT

I believe this is specifically a limitation of aggregated measures that use a periodic (time) calculation. You cannot rank on a year to date calculation, but you can rank on aggregations that don't involve time, such as percent of total.

The documentation says,

SAS wrote:

Note: You cannot use aggregated measures with periodic operators in filters. You also cannot use calculated data items that reference periodic aggregated measures in filters.

I believe that this note should say "filters or ranks" instead of just filters.

topic Rank on SAS VA cannot choose measure from aggregated measure in SAS Visual Analytics

Rank on SAS VA cannot choose measure from aggregated measure

Re: Rank on SAS VA cannot choose measure from aggregated measure