About sseanhennessyy

sseanhennessyy · ‎01-23-2019

I was able to get around this by making a calculated item using this formula in VA: TreatAs(_Datetime_, ( TreatAs(_Number_, 'Timestamp'n) - TreatAs(_Number_, TimeFromHMS(6, 0, 0)) )) the 6 in the TimeFromHMS( ) function is how many hours you need to move it, in this case, I'm calculating for central time. Visually it looks like this

sseanhennessyy · ‎01-23-2019

Yep, I think that is exactly what is happening. Thanks!

sseanhennessyy · ‎01-23-2019

I was playing around with our usage report today and noticed something strange. I'm seeing time recorded for usage later than the current time (see below). The 'Now' column is using the now() function from a calculated item. Any ideas why this might be happening? The most current actions look to be the one I am currently taking within SAS VA.

sseanhennessyy · ‎11-15-2018

Ah yes, that works. Didn't think to do the counts in VA. Perfect! Just for reference, here is the actual text that is working for me: IF ( 'STATUS'n In ('SOLD') ) RETURN 'COUNT'n ELSE 0

sseanhennessyy · ‎11-14-2018

I'm wondering if there is anyway to do a calculation by specific groups within the same column of data. If I have the following data set, I want to be able to sum the Count column by Status then divide the sum of sold status count by the sum of proposed status count. Is this possible is VA? Status Count Proposed 1 Sold 1 Proposed 1 Sold 1 Proposed 1 Proposed 1 I know I can manipulate the data prior to bring it into VA and columns for 'Sold Count' and 'Proposed Count' and would be able to do the calculation that way, just curious if there is another way. Thanks!

sseanhennessyy · ‎10-26-2018

So this one is a little complex and I'm not sure if it can be done or not. I'm attempting to create a report where the user can enter a date in CYYMMDD format to pass through an advanced filter. Here is the filter: AND [ Policy Effective Date =< parameter [ Policy Expiration Date >= parameter Both Policy Effective Date and Policy Expiration Date are in the same CYYMMDD format. The filter works when I create a custom parameter for a static value, however I want the report user to be able to change that parameter value through a text input control. Is this possible? Can a user change a parameter value through a text input option?

sseanhennessyy · ‎10-13-2017

Ahhh, figured it out. It is due to the Report Theme. The SAS Snow theme makes the target lines grey, the SAS Light theme makes the target lines black.

sseanhennessyy · ‎10-13-2017

Hmm, its strange because a co-worker of mine, using the exact same version, has a report where the target lines are defaulted to black. We compared the two side by side and can not find anything that would indicate why his would be different than mine.

sseanhennessyy · ‎10-13-2017

I must be missing something here. I'm creating a targeted bar chart but cannot seem to find how to change the target line color. It's defaulting to this grey color. On another report I've created it defaults to black. I've tried changing all the items under 'styles' but nothing seems to change the target line color. I feel like it should be changed by the 'Reference Lines' option under 'Frame Styling' but that doesn't change it. For reference, I am in SAS 7.3 Hotfix 06

sseanhennessyy · ‎11-10-2016

Thanks for the quick reply! Unfortunely I don't think that article will help with what I'm trying to do, although it is a good read and I will likely refference it in the future! For this I have 3 different pie charts that show different metrics and a hierarchy over them that starts at state level and goes down to different product types. I'm hoping to have it so that if I drill down on one of the pie charts, the other two will drill down as well thus eliminating the need to click and drill down on each pie to see the product level for the different metrics.

sseanhennessyy · ‎11-09-2016

Let me preface by saying I'm not sure if this is even possible in SAS VA. I have three seperate graphs on a report all of which utilize the same heirarchy. I would like it so that if you drill down in one of the graphs, the other two will drill down as well. This way you wouldn't have to click on all three graphs to get the desired visualization. If there is no way to do this, another thought I had was to have a button bar or dropdown which would let you select the desired drill down level you wanted to see. Anyone know a way to do either of these?

sseanhennessyy · ‎10-18-2016

Hey Varsha, Yes that worked as long as the file is saved in a folder that all users have permissions to. Thanks! 🙂

sseanhennessyy · ‎10-11-2016

Hey all, I am using SAS VA 7.1 and am trying to find a way to link to a specific SAS VA visualization. When I am in the visualization and copy the web address into another browser it brings me to the SAS Visual Analytics Explorer menu where I can either select a data source, select a recent exploration, or browse but I would like to have it go directly into a saved visualization. The visualization is stored in a public shared data folder. Is this possible?

Online Status	Offline
Date Last Visited	‎06-05-2019 07:53 PM

Re: Administrator Report Showing Usage Later Than Current Time?

Re: Administrator Report Showing Usage Later Than Current Time?

Administrator Report Showing Usage Later Than Current Time?

Re: Calculations on measure by category within same column of data

Calculations on measure by category within same column of data

Passing a parameter through an advanced filter

Re: Targeted Bar Chart - Target Line Colors

Re: Targeted Bar Chart - Target Line Colors

Targeted Bar Chart - Target Line Colors

Re: Drill down across multiple graphs

Re: Targeted Bar Chart - Target Line Colors

Re: Administrator Report Showing Usage Later Than Current Time?

Re: Administrator Report Showing Usage Later Than Current Time?

Administrator Report Showing Usage Later Than Current Time?

Re: Calculations on measure by category within same column of data

Calculations on measure by category within same column of data

Passing a parameter through an advanced filter

Re: Targeted Bar Chart - Target Line Colors

Re: Targeted Bar Chart - Target Line Colors

Targeted Bar Chart - Target Line Colors

Re: Drill down across multiple graphs

Drill down across multiple graphs

Re: Linking to a specific SAS VA visualization from a webpage

Linking to a specific SAS VA visualization from a webpage