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.
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
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
Great ! That clears it up, thank-you.
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.
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.