topic Re: Period parameter bar chart displays wrong averages in SAS Visual Analytics

Period parameter bar chart displays wrong averages

stevens1895 — Wed, 14 Mar 2018 16:39:43 GMT

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-reports/ )

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?

Without date parameter selected (correct average)When date parameter is selected, very low average below the true value

Re: Period parameter bar chart displays wrong averages

ballardw — Wed, 14 Mar 2018 18:10:05 GMT

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.

Re: Period parameter bar chart displays wrong averages

stevens1895 — Thu, 15 Mar 2018 10:25:40 GMT

Calculation

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

Re: Period parameter bar chart displays wrong averages

stevens1895 — Thu, 15 Mar 2018 10:26:30 GMT

Date 1 is my date parameter