BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ndonnelly1
Calcite | Level 5

I am a little confused when it comes to choosing between an Aggregated Measure and a Calculated Item, they seem to me to have the same functionality. Could someone provide an example of the difference and when to either option. 

1 ACCEPTED SOLUTION

Accepted Solutions
Sam_SAS
SAS Super FREQ

Hello,

 

A calculated item is evaluated at the row level whereas an aggregated measure is evaluated in an aggregated context.

 

 

Generally speaking, you can use a calculated item anywhere in VA you can use a normal data item (category, measure, or date).

 

Aggregated measures can be used only in a report object where the data is being aggregated. For example, you cannot display an aggregated measure in a list table that shows detail data.

 

There are certain types of expressions that can only be used in an aggregated measure, like the periodic operators used to calculate year-to-date.

 

Hopefully that clears things up a little bit. For the most part if you are not sure which one to use, then you probably want a calculated item.

 

Sam

View solution in original post

2 REPLIES 2
Sam_SAS
SAS Super FREQ

Hello,

 

A calculated item is evaluated at the row level whereas an aggregated measure is evaluated in an aggregated context.

 

 

Generally speaking, you can use a calculated item anywhere in VA you can use a normal data item (category, measure, or date).

 

Aggregated measures can be used only in a report object where the data is being aggregated. For example, you cannot display an aggregated measure in a list table that shows detail data.

 

There are certain types of expressions that can only be used in an aggregated measure, like the periodic operators used to calculate year-to-date.

 

Hopefully that clears things up a little bit. For the most part if you are not sure which one to use, then you probably want a calculated item.

 

Sam

ndonnelly1
Calcite | Level 5

Great ! That clears it up, thank-you.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 5270 views
  • 3 likes
  • 2 in conversation