Hello, I want to plot the percentage of total appts that are completed, canceled, no show, or left without seen by month (see the crosstab) in a time series plot. For crosstab graph, this works as I can calculate a Percent of Row Total - Sum as a measure. However, SAS VA is not allowing me to plot this same calculated measure in a time series plot. In a time series chart (see pic), when I plot Frequency Percent, it is taking the percent of the grand total, and not the total by month, and I cannot seem to change how this percentage is calculated. Do I really have to create a custom calculation to get to the line chart I want? In Tableau, you could easily select how you want percentages are calculated for each graph... Thank you!
... View more