Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Period parameter bar chart displays wrong averages

Reply
New Contributor
Posts: 3

Period parameter bar chart displays wrong averages

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?

 

 

VA bar chart problem 1.JPGWithout date parameter selected (correct average)VA bar chart problem 2.JPGWhen date parameter is selected, very low average below the true value

Super User
Posts: 13,947

Re: Period parameter bar chart displays wrong averages

Posted in reply to stevens1895

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.

New Contributor
Posts: 3

Re: Period parameter bar chart displays wrong averages

VA bar chart problem 3.JPGCalculation

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

New Contributor
Posts: 3

Re: Period parameter bar chart displays wrong averages

Posted in reply to stevens1895
Date 1 is my date parameter
Ask a Question
Discussion stats
  • 3 replies
  • 97 views
  • 0 likes
  • 2 in conversation