We have SAS Visual Analytics 7.4, and I am looking for a way to make drop down report prompts dynamic. For our required prompts, they select a specific value, and that value needs to be manually changed. For example, we have a report prompt for term, and I have to save the report with the next term's value. Is there any way that I could have the prompt automatically select the first value in the list regardless of what was selected during development rather than the last value the prompt was when I saved it? Thank you! ... View more

I am new to use SAS VA 7.4, and I am currently having an issue with the gradient colors changing in my heat map based on the filters of the report. The scale is aggregated measure (percent) that 0% is blue and 100% is red, and the tiles are by department.   When the graph is not filtered everything looks fine, but when a user filters the graph down to a few tiles the colors change. A tile may be red when there are no filters, and that same time will change to blue when there are only a few tiles. The scale also changes to be more representative of the fewer tiles.    Is there any way to keep the gradient colors the same no matter what the report filters are, or be able to keep the scale static at 0% - 100%? Any guidance would be extremely helpful.  ... View more