topic Re: Dynamic graph using distinct Parameters in SAS Visual Analytics

Dynamic graph using distinct Parameters

chrisjab — Mon, 29 Aug 2016 21:26:35 GMT

Good afternoon,

I am trying to create custom categories for my dynamic parameters using SAS VA; however, I am experiencing some limitations with my data set:

Currently I have the following tables:

CustomerID Gender Age Group Region Assets Liabilities

156254 Male 20-30 NE $120,000 $56,000

264856 Female 30-40 NW $200,000 $115,000

354128 Male 30-40 SW $115,000 $50,000

123254 Male 20-30 SE $135,000 $60,000

264586 Female 20-30 NE $215,000 $15,000

315238 Male 50-60 NW $155,000 $90,000

I am trying to create three pie charts based on:

Count of Total Customers
Sum of Total Assets
Sum of Total Liabilities

Using Gender, Age and Region as the parameters

I found a few examples where the parameters were Assets, Liabilities, Profit, Expenses ...;however nothing where the parameter is a defined category. If anyone has any idea on how to proceed, please let me know. Thank you,

Re: Dynamic graph using distinct Parameters

MichelleHomes — Mon, 29 Aug 2016 21:43:00 GMT

What about using a stacked container to achieve what you are after? Check out this blog post which also has a link about setting up category parameters http://blogs.sas.com/content/sgf/2016/05/25/use-a-stack-container-to-pick-your-category-in-visual-analytics-reports/

Kind Regards,

Michelle

Re: Dynamic graph using distinct Parameters

chrisjab — Tue, 30 Aug 2016 13:37:34 GMT

Thank you Michelle, I will look it up.