This question is a little bit tricky. I'm trying to get the difference between the last head count for term one and the last head count for term two knowing that Head Count is a sum of individual registrations for that day. What this chart is doing is pulling daily enrollment. Daily enrollment increases by day and includes a sum of all individual registrations for that day.   The initial solution was to use Parallel Period and attempt to rank BUT we can't rank by most recent date because the max date is different between the two so Rank shows the most recent date that applies to both terms which is incorrect and if I change rank so it has the most recent date then the head count of the 2nd term would be excluded.   The other solution was to use an aggregate table BUT that would only work if we don't apply drop-down filters. If we add the drop-down filters then we end up in square one.  I tried using Max in a calculate item but I keep getting errors about a boolean value.    How do I get the latest number for term one form the chart below - the latest number for term two while having the numbers change depending on the drop down selections? I feel that there must be a logical way to do this.   Any ideas are appreciated!     ... View more

I'm wonder if it it possible to display a day and month only as a date in a time series chart?     As an example, 1Apr 2Apr 3Apr etc   I can't seem to find that format. If not, is there another way to achieve this? Because we are trying to compare 1Apr from 2019 for example to 1Apr 2020 so we can't include the years. Or do you think that I should just convert to a categorical value and use that in a line chart?   This is in SAS VA 8.5 or SAS Viya 3.5   ... View more

Has anyone attempted to display data from long surveys like NSSE in SAS VA or Viya? Right now, I'm focusing on a few snapshots because it's practically impossible to add charts for more than 112 variables given that each page is only the size of a screen with no options to scroll down. Plus each variable can be added to one table if I were to use tables instead since I can't group multiple variables with the same scale in one table and I would need to add a chart for every variable which becomes lengthy if I want to group by different characteristics. The problem is that some people want to see the results for all the variables.   Or can you display a list of categorical values as a drop down like the image below?   ... View more