I'm not familiar with a dataset called ACCEPTS that comes with SAS Visual Analytics. Are you sure this is a SAS provided table, and if so which product it might be part of? For Visual Analytics, there is a CAS LIbrary called Samples that has several sample tables in it you might be able to use instead. I'm not aware of a data dictionary for any of them though but that might be intuitive enough to understand. They are described here: https://go.documentation.sas.com/doc/en/vacdc/v_031/vareports/n1dj9jn3klf501n1ovpkkahcegot.htm   ... View more

You should be able to do this by creating a Distinct Count of your Date data item, then using that new measure in the KPI. 1. Right-click on the Date data item and select New Calculation 2. First option should be Distinct so create that 3. Use that distinct count in the KPI 4. Ensure the list control filters the KPI.   Now by doing this if you have 0 selections in the list, then the KPI is going to show a distinct count of all date items (because it's not being filtered by anything). If you need the KPI to show 0 then you can take the following extra steps: 1. Right-click on the List control and select New Parameter 2. Create the new parameter, you shouldn't need to make any changes to it aside from the name if you want 3. Back on the KPI, add a local filter that does something like this: IF (IsSet('Date Parameter'p)) RETURN 1=1 ELSE 1=0 This is checking to see if the Date Parameter is set (meaning at least one selection has been made). If so, then we return true, else we return false.  When it's all done it should work like this:   ... View more

I can't be certain without better understanding your data but I suspect you'll need to use the AggregateTable function and create something like this (this is from Visual Analytics 2025.04 so may look a little different if you are on Viya 3.5): AggregateTable(_Sum_, Table(_CountDistinct_, Fixed('Dir'n), 'Taille totale du FS(Go)'n))   If that's not getting you what you are wanting, could you provide some sample data and what kind of results you are expecting?  ... View more

I am sorry you have encountered this. #2 is an unfortunate bug in version 2025.02 that is fixed in the 2025.04 release. There is no other fix for 2025.02 I'm afraid. Once you move to 2025.04, the existing duplicated entries in Recents will remain initially but new reports added to the recent list will no longer be duplicated, and over time the list will get back to normal.  ... View more

I haven't fully thought this through yet and am not 100% certain I would fully endorse this process, but I was able to get something working here: Overall this is not something Visual Analytics can easily do. The way I was able to get it to work is a bit complicated and involves a couple of aggregated datasources and joined datasources so if your tables are very large, I would not advise doing this in a real report.  The process though is this. I'm going to call your original datasource "Original". 1. Create an aggregated datasource with just the "ItemID" column 2. Create a second aggregated datasource with just the "ItemID_reference" column 3. Join the two aggregated tables together using an INNER join and matching the two ID columns. The end result should be a table that only has matches (2 rows in this example, one for 1111 and one for 7777). 4. Join Original and the new join back together using a LEFT join on Original. Map the ItemID_reference columns from each. I included all columns, and you should end up with something like this, and I've renamed each column to make it clear where they came from: 5. Create a calculated item like this: IF ('ItemID_reference (original)'n = 'ItemID_reference (1st join)'n) AND NotMissing('ItemID_reference (1st join)'n) RETURN (1) ELSE (0) Outside of something like that, I don't see how this can be done in Visual Analytics. The major downside to creating Aggregated Datasources and Joins like this is that the tables get created at runtime in the user's personal CAS library so if your real table are large, you have some risk of performance issues and using up space in CAS.  The better answer might be to handle this calculation outside of Visual Analytics before loading the data into CAS.  ... View more

This is not something VA can easily do. I thought I might be able to make this work but unfortunately so far each idea I come up with has ended up me up in the same position you have found yourself in. I hate to say it but I'm thinking this won't be possible.  The closest I can get is having a form of the pivoted table you mention where the forecast and actual values are part of the same column and then a second column that differentiates between the two. THEN I also included columns for each predicted and actual values as well so something like this, along with a calculation I made concatenating the Year and Type to be used for the filter.   Then my custom line chart uses Month, Actual Total, Predicated Total, and grouped by Year, so it looks like this:   Then the filter uses the concatenated item I made, and the lines themselves are right when used, but the legend is wrong and confusing because the legend will always include missing values: I cannot find a way around this or a better solution I am afraid.  ... View more

No problem at all and glad that worked for you! For this second question do you mind starting a separate thread for that? This will be a different solution so would be more helpful in a different thread. AND I believe we can make this work so I'll respond there.  ... View more

The Now() function in VA can be controlled by a JVM property timezone setting for the reportExecution service/pod described here: https://go.documentation.sas.com/doc/en/vacdc/v_029/varef/p1t3sqzzeb69h1n1t52gw8nr73eb.htm   If this property is not defined for the service, then it defaults to the timezone of the report execution pod, which you could check with this kubectl command:  kubectl -n <namespace> exec <report execution pod name> -- date where namespace and report execution pod name are the right values for your environment. I suspect though you just need to set the JVM property from the link above to your timezone and that should do the trick.  ... View more

Ok, so the report link itself works the way you want it to, but in report 2 selecting something from the drop down does not filter the table in this report? If that is correct, then we can forget report 1 for now, that sounds like it is working the way we want. Instead, something must not be right with the mapping that was created in report 2. In order for the mapping the work, the source data item in the mapping must be used in the drop down list. Further the two data items you are mapping must use the same format.     I think the only way to help here is to see some screenshots of what you have done. Can you provide a screenshot of what your mapping looks like, as well as what data item is used in the drop down list?   In your earlier example, this "All Category" data item used in the drop down list must be the source data item for the mapping.  ... View more

I have not tried this myself yet but I think the only possible way this would work is if that dropdown list used a completely separate datasource and that it was not mapped from Report 1.   Something like this: 1. Report 1 uses Datasource 1.  2. Report 2 uses Datasource 2 for that drop down list, and then Datasource 1 for the remaining objects (button bar, table). 3. Within report 2, creating a mapping between Datasource 2 and Datasource 1 so that the drop down list will properly interact with the button bar and table.  4. In your report link from Report 1 to Report 2, do not create a data mapping here from Datasource  1 to Datasource 2.   The only potential issue is that the mapping you create in step 3 might be enough to cause the report link in step 4 to filter the drop down list anyway. I'm hoping that is not the case.   ... View more

Visual Analytics is not really great for being able to take and store a value from one row (Lead = yes for example) and apply that to other rows in a single calculated item. If this doesn't need to be anything fancy then would you be able to get away with counts that then link to the detail table? For instance I took your data, and I created a calculated item converts Lead from Yes/Missing to 1/0: IF ( 'Lead product'n In ('yes') ) RETURN 1 ELSE 0 This is necessary to apply a filter a bit later. Then I renamed Frequency to Sales Count since each row appears to be a Sale, and created this table: Then add an aggregated filter against Lead Number to get it down to just the customers that bought leads:   This should give you a quick look at how many total Sales were for customers that also bought leads. Then you can add a second detail table if you need to see the individual sales, and create a filter action from the Lead table to the Detail table:     ... View more

Report Distribution is the primary way to achieve this so if this didn't work for you, we'd need some more details on what went wrong there. That also might be better suited for a tech support case as well rather than trying to resolve in the communities.   If you're on Viya 4, the next best alternative is to use the Rest APIs to do this, which is what you probably meant by HTTP request? The /visualAnalytics/reports/<report_ID>/pdf api will do it and then scripting the email job to send it out to anyone you'd like. However this can be a somewhat complicated approach if you're unfamiliar with using these APIs. But if you say you tried it and the PDF doesn't open, then we'd need more details here on what exactly you were doing. Again depending on how complex troubleshooting this gets, this might also be better suited for a tech support case.  Beyond that, I do not think there are any other options to automatically generate and email a PDF of a report. ... View more