03-14-2018 12:39 PM
I have created a bar chart with period parameter drop down lists so the user can compare periods on the same graph (method followed: https://blogs.sas.com/content/sgf/2017/11/13/using-date-parameters-in-your-sas-visual-analytics-repo... )
I have used an average aggregate to tell me the average percentage for the selected period.
However, when I select a period from the drop down list my average values fall from around 20% which is the correct value, to less than 2% for any period I select.
The ratios of column height are correct but the average values are wrong, is there a format my data should be in to counteract any automatic formatting sas va does when calculating averages or is there a problem with my date parameters?
03-14-2018 02:10 PM
What did you specify to be the denominator of the percent calculation?
I would guess that when the selected date is supplied the counts(or sums) within the date are being divided by the count(or sum) of the entire dataset if this is happening for all of your dates (especially if your total number of dates is near 10).
I don't use VA so can't point to the exact menu item but maybe you can tell by going back through your settings.
03-15-2018 06:25 AM
Av. completion period 1 is what I want to find, report completion rate is what i want to average for each quarter (YQ). The problem seems to be here as the values are showing 0 to 3sf for Av. completion period 1