BookmarkSubscribeRSS Feed
Ninan
Obsidian | Level 7

In visual analytics, table crosstab object has an option to sum the column total, but is it possible have additional customization to modify the summary line like in PROC REPORT computational override? Ie instead of sum of a column, I want to a different value like weighted average and instead of literal "Total" something like "National"?

Ie I have data related to all 50 USA states and I want the summary at bottom, and few columns have special formula and summary national numbers are not just sum of all the individual states.

Considering this is not possible in my 6.3 version, I am thinking to have a workaround to have separate  row for national and values readily calculated in the data itself before presenting it and to have a “list” control to display the national value,

but second question I have is that is it possible to have a default list selection in list control? 

Ie initially I had only states values and when I open the visualization, it will show the summary of all data without any filtration, due to above mentioned first problem I included a separate summarized row for national, now the total value will be double at the initial screen, but users can select national from list to get the correct value, so is it possible to have a default national selection in the first place when the visualization is displayed?

2 REPLIES 2
Ninan
Obsidian | Level 7
  1. I was able to achieve my goal using Aggregated Measures, unlike Calculated Data Items, it summaries the data based on the group value after aggregation. Ie in total column, it doesn't summarize the data from it's column data, but recalculates based on the formula using final grouped numbers of other columns in the formula. There may be limitations in Aggregated Measures, but few of those can be overcome by prior data preparation.
  2. it is possible to have default selections in list control, ie once we link (interaction)  list control with an object and save with a selection,  then we can reopen it with same selection which will serve as the default selection.

note: still using VA Ver 6.3

AnnaBrown
Community Manager

Thanks for updating the community with your resolution, Ninan!


Join us for SAS Community Trivia
SAS Bowl XXIX, The SAS Hackathon
Wednesday, March 8, 2023, at 10 AM ET | #SASBowl

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 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
  • 2 replies
  • 850 views
  • 3 likes
  • 2 in conversation