About FalkoSchulz

FalkoSchulz · ‎04-29-2019

I used a precision container and added the large mountain image as a background with the bar charts on top. Also adjusted slightly the transparency of the bar charts.

FalkoSchulz · ‎04-16-2019

Section link filters depend on actual selection. So in order to trigger a filter update in other sections - you would need to select data elements (e.g. table row, bubble, list item, etc.) in your first section. Instead of a fixed filter in the filter panel for the 'appeals tags' - you could use a list or drop-down component instead (so part of your report). Then a related selection in that list should also trigger a filter interaction in other sections. Hope this helps. Regards, Falko

icemanwill · ‎04-11-2019

Ok, thanks for the quick reply!

FalkoSchulz · ‎04-11-2019

Hi, This feels like a server side error in the query engine and could have one of many causes (data issue, formats, caching, configuration, etc.). It may best to open a SAS technical support track given these errors are usually well known and they will be able to help you quickly with recommendation how to resolve this. You may have to provide server side logs and query details. Thanks, Falko

FalkoSchulz · ‎04-11-2019

Well, aggregation needs to happen in this case if you have more than one row for a given location. So in your example - you have 3x rows for India. If you render such data on a geo map - there is only one single data point for India and the data query behind the scenes will try to aggregate the data given the selected aggregation method selected in the data panel. By default it's SUM - but if you get an average here - chances are you have selected AVG for your sentiment data item. Also, when you add an animation - the aggregation is not only done on location level but also on date level. So if you have more than one row for the same date - aggregation will also apply here. So in your example - what would be the expected outcome? You mentioned - you would expect two bubbles here but that really would mean a bubble at the same location overlapping each other. Such rendering is forced when you use a categorical data item as color (since we can't aggregate) - but it's not really a good representation of the data and your report consumer may struggle to understand what this means. Given you are forced to use a numeric data item for animation - you may want to show an average sentiment score here, e.g. 1 as per your example - indicating that overall sentiment was positive. You could also replace zero for the negative sentiment value with -1 and then use SUM as aggregation - giving you an overall sense of whether a location was positive or negative. As mentioned before - you could use display rules to better differentiate between negative and positive sentiment as well. If users need to drill into detail here - you could setup a second visualization (e.g. list table) and enable interaction between the geo map. This way you could show a complete list of all sentiments for a selected location. Hope this helps. Falko

AnjaliNair · ‎03-29-2019

Thank You Falko. It works perfect now.

FalkoSchulz · ‎03-29-2019

I don't think this is possible. The shortest refresh time is one second as far as I know. Regards, Falko

FalkoSchulz · ‎03-28-2019

This statement just loads the table in your local session. Using VA would create a new session and this table wouldn't be visible. If you want to load a table accessible across sessions - you will need to promote it. Example: proc casutil; load data=sashelp.cars casout="mycars"; promote casdata="mycars"; run; More information about promoting table is in the user doc. Hope this helps! Falko

FalkoSchulz · ‎03-26-2019

Decided to replace the screenshot with a more recent version using latest 2018 rodent inspection data.

FalkoSchulz · ‎03-21-2019

Yes, it actually doesn't matter how you select data points - whether it's manually via free-lasso, circle or using the geo search bar and creating related radius based selection by entering a distance. All result in data points selected and - if filter interaction is setup correctly - should trigger any target visualization to also update. I just had a quick try using VA 7.4 and VA 8.3.1 (current production on SAS Viya) and both work as expected (although VA 7.4 only supports manual selection). Can you double check that the actions panel correctly shows the filter interactivity between the two visuals - here a screenshot of my very simple test case: Note, the selected list table in the right action tab along with pressed filter action type. I used a basic 150mi radius selection to only have two data points selected (US state VA,WV) which results in only customers shown in these two states in the right hand list table. Hope that is what you are after. Thanks, Falko

MichelleHomes · ‎03-20-2019

Funny man @FalkoSchulz! I was looking for my pic in the quadrant with the others and then saw the outlier.... The last 2 weeks I’ve been tweeting at the SAS Nordic Forums #SASNF. That would also be an interesting analysis to do. https://twitter.com/search?q=%23SASNF&src=recent_search_click&f=live

FalkoSchulz · ‎03-13-2019

Whether your map uses standard geographical overlays (countries, states, etc.) or is based on custom polygon boundaries - won't change the behavior. The geo map will always zoom to a level to show all data points (or regions). If you want to restrict the view to a particular region and auto-zoom the map to a more granular level - you can apply filters or setup interactivity as mentioned in my previous reply. Hope this helps. Falko

FalkoSchulz · ‎03-11-2019

You could use a scrolling container and maybe use a list table to carry the actual news fields? You could style the table to hide things like borders etc - so it looks more like a flat list. If you need something more fancy - you could also look into data-driven content object which allows you to embed any 3rd party HTML5 code. I'm sure there are plenty of open-source examples around. More information about these VA objects can be found in the users guide. Hope this helps. Falko

Yiting · ‎02-20-2019

I did! Thanks! its crazy... it took me lots of time to query the coordinates of each customer and eventually I just need pairs of mean for each region... sigh...

FalkoSchulz · ‎01-23-2019

Hi David, When registering the MAPSCSTM library as described in http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n09tvhnyrosr8mn1nmw7u3akrb1e.htm - have you properly registered this library in the autoexec as well as restarted the object spawner to let changes take affect? Also, every time you update the lookup tables - you will need to restart the web application server as tables are cached. Can I assume you followed the specific example code for importing US counties as shown at http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n04ecrgh5srx06n1r4j4i8ggss08.htm ? When you say - nothing is plotted. Have you tried both a geo bubble as well as geo region map? Does the geo bubble plot render? If so - it indicates that the overall registration is correct and entries in centlookup contain the correct centroids for each region. If geo region doesn't work - it usually indicates that the table references in centlookup can't be resolved (e.g. library not registered, table missing, etc.). Finally, when defining the geographical item in VA - make sure to follow http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#p16obhz546nr6tn1aqkhaxlelswx.htm (Subdivision (State, Province) Names and select the entry matching you registered custom region) Hope this helps. Let me know how you go. Regards, Falko

Online Status	Offline
Date Last Visited	2 weeks ago