Visual Analytics has some refresh options. For example, in Visual Analytics Viewer, click on the icon representing your ID in the upper right, select Settings, look under SAS Report Viewer > Report Refresh.  In Visual Analytics on SAS Viya, there are options at the page and object level to periodically reload data.  ... View more

With SAS Visual Analytics 8.5, you can use the _Full_ parameter interval to calculate over multiple years rather than year over year.       Hope this helps, Jaime ... View more

Hi! One way is to create a group (or groups) for memebers with limited access. And for that (each) group you add a row level filter that limits the access.   This could be a good start: http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0hopehj2j9vzun1jm9rl56bpnrh.htm   //Fredrik ... View more

Dear Pavan,   Please share the screenshot how you created the calculated column.   what kind of interaction you fixed between your objects ?    by global filter do you mean report prompt ?     Regards, Ashish     ... View more

data TEST; format DAY1 DAY2 date9.; DAY1= "10mar2019"d; DAY2= "20mar2019"d; DIFF = intck('WEEKDAY', DAY1, DAY2); run; In fact, it's 8 business days and not 7. ... View more

You could use the INTCK function for this. This allows you to calculate the number of weekdays between two days, like in the following example:   diff = intck('WEEKDAY', start_date, end_date)   Chris Hemedinger wrote a blog entry with a function that will consider holidays as well. You can find it here: https://blogs.sas.com/content/sasdummy/2011/05/09/calculating-the-number-of-working-days-between-two-dates/ ... View more

Hello Pavan,   I believe that the workaround should be possible in any version (or at least those later than 7.1).   If you have 8.2 or later, however, it is much better to create "cumulative total" from the Data pane. Here is some documentation on that feature:   https://go.documentation.sas.com/?cdcId=vacdc&cdcVersion=8.2&docsetId=vareportdata&docsetTarget=p1tm26sodb94w9n1hz81bz75plk7.htm&locale=en#p1vsphor4qnevcn13p4bepmj5wwx   Thanks, Sam ... View more

With regard to your first issue, the "no data" message is displayed differently in the report viewer than in the report designer. The icon is different and smaller. Could this be what you are seeing? ... View more

Hello! We moved this post to the Visual Analytics Board from the New SAS User Board since it is about VA. You should get more views from people who can help with VA questions here! ... View more

Access to VA reports is controlled by the permissions set on the metadata folders where the VA reports are stored. If you are not familiar with the metadata authorisation model then this link will help: https://documentation.sas.com/?docsetId=bisecag&docsetTarget=n1fo8uwjqlx9uun1f4g6snhxo95c.htm&docsetVersion=9.4&locale=en   Also here are more VA specifics on controlling permissions: http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1r98i0vpddhgnn1mie67wfx3t4z.htm   This is not a simple topic and I would recommend SAS's VA training courses as the best way to learn about this. Alternatively you could use external SAS experts to implement your security requirements. ... View more

data x; do i=0 to intck('week','01jan2019'd, '01feb2019'd); date=intnx('week.7','01jan2019'd,i,'e');output; end; format date ddmmyy10.; run; proc print;run; ... View more

Hello Pavan,   Working with dates is sometimes a challenge in VA.     The thread below is about finding the maximum value, but it might be helpful for the minimum value as well: https://communities.sas.com/t5/SAS-Visual-Analytics/Getting-max-date-value-in-SAS-VA/m-p/455076#M9933   Thanks, Sam ... View more

Can you share the aggregated expression you are using to calculate "Difference in days for DTAT with frequency"? I am still not sure I understand why you do not simply assign the Average aggregation to the "Difference in Days" measure. ... View more

Hi , can u please share that script. ... View more