A quick update - that I added a link to the related blog post with details how the visualization was created.  ... View more

Thanks Fredrik! Yes, all your comments make sense and many are on my list of things to improve. Yes, I don't like the legend either - far too small. I was actually planning to replace the legend with another chart (maybe a bar chart showing the frequency distribution for each type).    Yes, the report is interactive and you can select bars etc to filter the impact locations. But you are right - in a static report screenshot like this - a hint may be useful though if you have the live report - it's actually quite natural to click on bars or data points - just because you curious what happens     Will also add some general explanations about classes/types in version 2 - which makes it more like an infographic / poster.   Thanks again! Cheers, Falko ... View more

Hi, Have you tried creating a hierarchy out of the described levels (e.g. customer -> accounts -> ..)? The network analysis supports hierarchies as input - some details are here. Just make sure to switch to hierarchical type in the options panel first. And yes, you can also assign related measures to things like node color or link width to highlight the level of relationship.   Once you have your network - there is also the option to set a specific node as root (RMB click -> Set as source node) and have predecessors/successors selected given the distance to this node. Some details are here. This is sometimes useful in order to filter out unwanted sub graphs.   Alternatively - you can create a special table with source and target columns as described in the doc - this is known to VA as 'ungrouped' network. This is a very common structure when doing network analysis - but given your details below it seems your current structure is rather transnational so a hierarchical network may be easier.     Hope this helps. Regards, Falko ... View more

Thanks Sundaresh. Appreciate your suggestions and comments. And yes, the playable dashboard feature in VA 8.3 is used to transition through multiple tabs - just like a slideshow. If data changes - individual visualizations will also smoothly transition into the new state and visualize new data.   This particular dashboard was created as an interactive report though - so one can select teams to compare against and probably doesn't have enough pages to go through in play mode.    I may have to check regarding the export to animated GIF or SVG as I'm not sure whether that's an option. I guess one could just record the screen using any of the screen recording tools as well.    Thanks again.  Regards, Falko ... View more

As mentioned in https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-First-var-Last-var/m-p/484219/highlight/true#M10816 - VA doesn't allow row based calculations such as sequence or lag (as these require special sorting to work). Did you try using path analysis to see whether this is suitable for your needs? Things like customer count on given paths and measuring overall customer journey / contact points is part of sankey diagrams.   Otherwise you could create a SAS job to create and update the table using data step. Yes, you can use SAS Enterprise Guide (or even SAS Studio if you are on SAS Viya already). Probably easier just to have the job replacing the in-memory table on regular basis so any report consumer gets updated values when viewing the report.   Hope this helps. Falko ... View more

Assuming you refer to this infographic about flight cancellations and not fatality analysis?   Yes, the left side is just a normal flow container in vertical direction (so the visuals appear from top to bottom). The right side is indeed a precision container (with a light gray background) given the number of visuals and the fact I had to overlay some of the visual on top of the geographical map. I often use the options panel (Options -> Layout) to fine tune the actual position of a visual given you can enter values. In VA 8.3 we also introduced a nice grid which makes it pretty straight forward to snap visuals into position. If you hold CTRL key down while dragging the grid becomes even more fine grained for more precise positioning.   Cheers, Falko ... View more

Unfortunately there are some limitations in terms how row-based calculations can be done in VA. You have a related discussion here: Re: SAS Visual Analytics create a Sequence variable   You can certainly use your original table straight as input to path analysis (sankey diagram) - it would render similar to this:     Note, that a sankey diagram is really designed to be used on high volume data so you rarely look at an individual but rather at the overall customer journey here. For example, what percentage of my customers first contact by phone and then visit a store? How many customers do not come back (contact) after visiting a store? How many purchase a product? etc.   The sankey diagram shows you the total count (small numbers to the start and the end of a path) taking this particular step.   No, the labeling in a sankey diagram is done given the event identifier. in your example this is probably 'wayOfContact'. You can however use special path filters here to identify a particular path(s) of interest. For more detailed investigation - you can create other visualizations given a path or event selection (e.g. bar chart showing the customers behind this path). Such visualization can have additional labels, measures etc to describe this path subset.   Hope this helps. Falko ... View more

Unfortunately the VA query engine doesn't allow such sequence or row based calculation and I'm not aware of a work-around other than calculating such as part of the data preparation step. ... View more

Thanks Sundaresh. Yes, that makes sense as a weighted measure would better show the manufacture relationship here. Clearly - as you figured - GM is top on the list given its higher sales volume but of course we shouldn’t give the impression these cars are less safe than others (well, we will see once we use a weighted measure ;-). I will put this one the list of things to check/improve in version 2 - I got a few other tweaks to make anyway.   But really appreciate your feedback!   Regards, Falko ... View more

That would be great thanks!   ... View more