I have noticed that when there is a section prompt in a Visual Analytics report (for example, a drop-down list), then the ability to export detailed data from a graph in that report disappears. I can still click on the 'Export data' icon and see the Export Data pop-up, but the 'Detailed data' check-box under 'Options:' is missing. This is a need for my end users, to be able to export all of the columns from a table via exporting in a graph, and having section prompts in my reports is also a necessity. Has anyone else experienced this? Any workarounds or fixes?
Export Data pop-up without a section prompt
Export Data pop-up with a section prompt
One thing that can prevent detailed data export is applying a post-aggregate filter to an object. Is your section filter filtering on a post-aggregated value? For example, Frequency Percent is a post-aggregate value.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
No, I'm not filtering on a post-aggregated value, but I was filtering on a custom category, and that turned out to be the issue! I can change the report to filter based on a non-custom category and the detailed data option re-appears. Thank you!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.