How to become professional and more efficient using SAS Visual Analytics   An elegant IsSet solution   In one of my previous videos, IsSet for Success, one of my use cases was how to make a busy line chart less busy. Just a few weeks ago, my Norwegian colleague Tom Arne Orthe (@TomArne) mentioned a similar use case, but with a more elegant solution that I really want to share with you all.   In this video, I'm using the same busy line chart use-case. But, instead of displaying nothing when no selections have been made, a line representing a total will be shown instead.   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data. SAS Visual Analytics version used in this video: 2024.08   Important Message: As of version 2024.05, parameters are now assigned using the left action pane/menu     ... View more

  How to become professional and more efficient using SAS Visual Analytics   Working with URL links   URL links are often used to access web services or other resources from a SAS Visual Analytics report/dashboard. In this video we are going to look at some use-cases how URL links can be used, such as accessing a web service and how to access other resources.   During this video, I’ll use three different use-cases to inspire you how URL links can be used and created in SAS Visual Analytics.   1. How to access a web service such as Google Search (0:30) 2. How to dynamically generate URL links based on your data (2:30) 3. How to dynamically create URL links to access PDF files (5:29)   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 2024.05   Important Message: As of version 2024.05, parameters are now assigned using the left action pane/menu   ... View more

  How to become professional and more efficient using SAS Visual Analytics   10 Quick Ones   10 quick tips how to make your life even easier when working with SAS Visual Analytics. As I often say, small things matters… Here are the 10 quick ones:   A quick way to get data source information (0:34) A quick way to add filter information using the text object (1:15) Quick calculations (2:04) Quick calculations using the crosstab object (3:41) Create hierarchies using the data pane only (4:26) Create a date hierarchy with just two clicks (5:11) Create a hierarchy directly in a crosstab (6:02) Manage multiple data items at the same time (6:51) Get your parameter definitions right the first time (7:58) Save things into the object pane (incl. containers for design purposes) (9:22)   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 2024.05   Important Message: As of version 2024.05, parameters are now assigned using the left action pane/menu   ... View more

    How to become professional and more efficient using SAS Visual Analytics   IsSet for Success   This time I want to introduce a nice little function called IsSet, very powerful and adds new possibilities in SAS Visual Analytics. IsSet can be used to determine if a parameter is set or not. But when is IsSet useful? In this video, I showcase some examples to introduce how IsSet works and when it can be useful.   1. Short IsSet function introduction (0:34) 2. Using IsSet in a calculated data item (1:47) 3. Forcing a control object not to load any data with IsSet until mandatory selections are done (3:56) 4. Making a messy chart less messy using IsSet (6:22)   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 2024.05   Important Message: As of version 2024.05, parameters are now assigned using the left action pane/menu   ... View more

  How to become professional and more efficient using SAS Visual Analytics   The Mystery behind the Hidden Role   You might have seen it, the hidden role that can be assigned in some objects in SAS Visual Analytics.  But when is the hidden role useful? In this video, I have three different use cases where the hidden role can be very useful and valuable:   1. When using calculations that are dependent on other columns (1:05) 2. When using a non-displaying category in a display rule (2:52) 3. When you need to add non-displaying columns as parameters into an URL link (04:31)   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 2024.02   ... View more

  How to become professional and more efficient using SAS Visual Analytics   How to freeze parts of your report for better experience using Scrolling Containers   Another tip using containers in SAS Visual Analytics, based on a real use-case that I picked up couple of weeks ago.   This time we will take a closer look at the Scrolling Container, how it can be used to freeze parts of your report page for better end-user experience.   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 2024.01       ... View more

    How to become professional and more efficient using SAS Visual Analytics   A smart and dynamic way to create intervals/groups based on a numeric column   Sometimes we want to transform a numeric column into a category or group-by column. In this video I will show an interesting approach to create dynamic and flexible intervals/groups based on a numeric column.   During this video, I will show-case different calculations/expressions and I have put all of them into a PDF document (see attached PDF file above, upper left corner), just follow the instructions and copy them into your environment.   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 8.5.2 (Viya 3.5)   ... View more

  Merry Christmas to all SAS Visual Analytics fans and I hope you all are doing very well.   Over the years I have done several tips & tricks presentations/demos, especially here in the Nordics. I have created a landing page here on communities.sas.com with my current launched tips & tricks videos, just follow this link: SAS VA Tips & Tricks Series   Here are the current available tips & tricks videos:   How to use custom images in Geographic Maps In this video, we will look at how we can make Geographic Maps more interesting by replacing the standard bubbles with custom images. Click here to view the video…   Simple steps to make your list table shine Maybe you think the list table is a bit boring? In this video we will look at simple steps how to make your list table shine. Click here to view the video…    Tips & Tricks mini-series in four episodes: Why I love working with containers Part 1 - Introduction to the basics of how to work with containers and how I use containers when designing reports and structuring report pages. Click here to view the video… Part 2 - We will take a closer look into how I use containers and container techniques for better design and appearance. Click here to view the video… Part 3 - We will look at how we can re-use containers (or page sections) to speed up report/dashboard development. Click here to view the video… Part 4 - In this last episode I will inspire you by showing some of my design examples I’ve created over the years using containers. Click here to view the video…   New videos will be added, and I will announce them both on communities.sas.com and LinkedIn (linkedin.com/in/carl-olow-magnusson-116a445)   Enjoy and have fun! Kalle ... View more

    How to become professional and more efficient using SAS Visual Analytics   Simple steps to make your list table shine   Maybe you think the list table is a bit boring? In this video we will look at simple steps how to make your list table shine.   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data SAS Visual Analytics version used in this video: 8.5.2 (Viya 3.5)   ... View more

      How to become professional and more efficient using SAS Visual Analytics     Welcome to my SAS Visual Analytics Tips & Tricks series. Over the years I have done several Tips & Tricks presentations/demos for customers, especially in the Nordics. I have now decided to share these Tips & Tricks with everyone in the SAS Visual Analytics community.   I really hope these Tips & Tricks can help you solving your specific use-case challenge or give you some new insights. I also do believe that some of my Tips & Tricks can give you some inspiration for your upcoming projects.   I also want to thank all my customers and colleagues who have contributed with support and with some great Tips & Tricks ideas.   Below you will find a list of current published Tips & Tricks and it is a living list, new Tips & Tricks will be added over time.     New Videos Here you will find my new shared tips & tricks videos. As new videos are added, these videos will be moved to the categories below...   [NEW] An elegant IsSet solution Another IsSet example. This time I have a more elegant solution how to solve the busy line chart use case. Instead of displaying nothing when no selections have been made, a line representing a total will be shown instead. Click here to view the video…     Small Things Matters These tips might take you to the next level working with SAS Visual Analytics, even small features can be very powerful and make your work shine. It might be a hidden feature that you didn’t know existed.   How to use custom images in Geographic Maps In this video, we will look at how we can make Geographic Maps more interesting by replacing the standard bubbles with custom images. Click here to view the video…   Simple steps to make your list table shine Maybe you think the list table is a bit boring? In this video we will look at simple steps how to make your list table shine. Click here to view the video…    10 Quick Ones 10 quick tips that can make your life even easier when working with SAS Visual Analytics. As I often say, small things matters and they can make you more efficient when working with SAS Visual Analytics. Click here to view the video…     Report/Dashboard Design and Layout Here are some Tips & Tricks that can be very helpful in a design and layout perspective.   Tips & Tricks mini-series in four episodes: Why I love working with containers   Part 1 - Introduction to the basics of how to work with containers and how I use containers when designing reports and structuring report pages. Click here to view the video…   Part 2 - We will take a closer look into how I use containers and container techniques for better design and appearance. Click here to view the video…   Part 3 - We will look at how we can re-use containers (or page sections) to speed up report/dashboard development. Click here to view the video…   Part 4 - In this last episode I will inspire you by showing some of my design examples I’ve created over the years using containers. Click here to view the video…   How to freeze parts of your report for better experience using Scrolling Containers Another tip using containers in SAS Visual Analytics. This time we will take a closer look at the Scrolling Container, how it can be used to freeze parts of your report page for better end-user experience. Click here to view the video…     Solving Different Challenges You might be sitting right now trying to solve a specific use case challenge in SAS Visual Analytics. I really hope you can find the answer here!   A smart and dynamic way to create intervals/groups based on a numeric column In this video I will show an interesting approach to create dynamic and flexible intervals/groups based on a numeric column. Click here to view the video…   The Mystery behind the Hidden Role You might have seen it, the hidden role that can be assigned in some objects in SAS Visual Analytics. But when is the hidden roll useful? In this video, I have three different use cases where the hidden role can be very useful and valuable. Click here to view the video…   It IsSet for Success IsSet is a nice little function, but very powerful and adds new possibilities in SAS Visual Analytics. IsSet can be used to determine if a parameter is set or not. But when is IsSet useful? In this video, I showcase some examples to introduce how IsSet works and when it can be useful. Click here to view the video…   Working with URL Links URL links are often used to access web services or other resources from a SAS Visual Analytics report/dashboard. In this video we are going to look at some use-cases how you can manage and dynamically create URL links. Click here to view the video…         ... View more

    How to become professional and more efficient using SAS Visual Analytics   Why I love working with containers – Part 4   When working with design and layout, I often work with different types of containers to achieve my design goals. In this mini-series, I will explain why I love working with containers in SAS Visual Analytics, especially in a design and layout perspective.   Part 4, in this last episode I thought it would be interesting for you to see some examples I’ve created over the last couple of years. Let’s get inspired by some of my design examples using containers. Enjoy the video below and use the chat if you have any questions or comments.   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data. SAS Visual Analytics version used in this video: 8.5.2 (Viya 3.5)   ... View more

    How to become professional and more efficient using SAS Visual Analytics   Why I love working with containers – Part 3   When working with design and layout, I often work with different types of containers to achieve my design goals. In this mini-series, I will explain why I love working with containers in SAS Visual Analytics, especially in a design and layout perspective.   In part 3, we will look at how we can re-use containers (or page sections) to speed up report/dashboard development. Enjoy the video below and use the chat if you have any questions or comments.   To get back to the main page of the SAS Visual Analytics Tips & Trick Series, just follow this link!   Please note: All data used in my videos are either fictive demo data or open public data. SAS Visual Analytics version used in this video: 8.5.2 (Viya 3.5)   ... View more