BookmarkSubscribeRSS Feed

We have thousands of Statistical Process Control charts in SAS Visual Analytics that are controlled by many different controls. Many of our business partners that consume these charts often save the chart and add it to an executive summary in PowerPoint. We would really like to be able to pass categories and dates into the title of the chart itself. For example: Chart Title = "p Chart - [dynamic category value] - Baseline set to [Dynamic start date values] to [Dynamic end date values]". These dynamic values could come from a Calculated item or variable in the dataset. The values should be controlled by the controls and interactions. 


Custom_shewhart-1.png
9 Comments
MichelleHomes
Meteorite | Level 14

Dynamic text is available in SAS Visual Analytics 7.4. See screenshots I took from a recent webinar https://twitter.com/homesatmetacoda/status/862235613109538816

JoeRotford
Obsidian | Level 7

Hi Michelle, we just upgraded to 7.4 and the dynamic text object does not fulfil our needs. We need it in the chart object itself. 

MichelleHomes
Meteorite | Level 14

Whilst the chart object doesn't do this, I was thinking you could overlay a text object in the area in the chart where you want the dynamic text. 

JoeRotford
Obsidian | Level 7

I did try that. Two things:

 

1. If you maximize that chart the text object does not follow. It stays in place. Our users are exporting the image and putting it PowerPoint (I know this defeats the purpose of VA. We are working on them 🙂 )

 

2. The dynamic text object will only display Parameters, Measure and the "Interactive Filter". Parameters will not work for categories because there are many individual values in one category (Instrument 1, Instrument 2, Instrument 3,  etc...). The Interactive filter option is OK but our sections have many controls that are not in the Global prompt. 

 

@MichelleHomes Thank you for the suggestions. I appreciate it!

MichelleHomes
Meteorite | Level 14

Hi Joe,

 

It's very helpful to have your context here and a better understanding of what you've tried too. Thanks for sharing. Agree with your point with integration with AMO, it needs to be part of the chart object.

 

Thanks for expanding on the features request details. Will help others to vote and add their commentary too.

 

Kind Regards,

Michelle

lizmanger
SAS Employee

Hi Joe,

 

I was just looking for some info re dynamic text and your post came up.  The interesting thing is that you mention you are working with SPC charts in VA.  I am curios to know how you have created these, as I was recently working with a customer who was trying to create something similar.

 

Any details you can provide would be really helpful.

 

Thanks

 

Sanjay

JoeRotford
Obsidian | Level 7

Hi Joe,

I was just looking for some info re dynamic text and your post came up.  The interesting thing is that you mention you are working with SPC charts in VA.  I am curios to know how you have created these, as I was recently working with a customer who was trying to create something similar.

Any details you can provide would be really helpful.

Thanks

Sanjay

 

Hi Sanjay, this is how we are doing SPC in SAS Visual Analytics:

 

  1. Prepare your data in EG/SAS for Windows
  2. Run your data through PROC SHEWHART using the OUTTABLE= option in PROC SHEWHART
  3. Load the OUTTABLE into the LASR server
  4. Create a custom graph using these graphs in this order:
    1. Scatter
    2. Step
    3. Line
    4. Line
    5. Step
  5. Then you pick the appropiate data objects for each role. The UCL and LCL are the control limits. You'll need to duplicate the x axis role multiple times. 
AnnaBrown
Community Manager
Status changed to: Under Consideration

Thank you for this request. As you can see from the comments, dynamic text objects is moving in this direction. We're looking at adding dynamic titles in a future release.

JoeRotford
Obsidian | Level 7

Status changed to: Under Consideration

Thank you for this request. As you can see from the comments, dynamic text objects is moving in this direction. We're looking at adding dynamic titles in a future release.

 

Great news!