BookmarkSubscribeRSS Feed
e487
Calcite | Level 5

Hello all,

 

I'm working with a calculated item which aggregates a percentage value cumulatively. The column it's based on has the data as a percentage of the total within that category. So this calculation should give a percentage running from 100% to 0 within each separate category.

e487_0-1614673754019.png

I've managed to get the data to display correctly in a crosstab:

e487_1-1614673972526.png

However when I'm trying to get the data displayed in a line graph the aggregation goes wrong, instead of aggregating within each group the aggregation happens over all together, which is then displayed by group:

e487_2-1614674290688.png

 

Is there a way to have the line graph aggregate over the categories in the by group and not the month? Either by some option in the line graph or by calculating the aggregation differently.

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 0 replies
  • 376 views
  • 0 likes
  • 1 in conversation