topic Re: Missing weekends in Line Graphs becouse of not having values in those weekends in SAS VA in SAS Visual Analytics

Missing weekends in Line Graphs becouse of not having values in those weekends in SAS VA

Pmahendra — Mon, 18 Feb 2019 06:54:18 GMT

Hi all,

My problem with SAS VA 7.4 is that when I am using a Line chart, some of my groups don't have values in every Weekend. Thus in these Weekends, X axis skipping these weekends which do not have values. is there a way to include these weekends on the Line Graph.

Beetween 12 jan 2019 to 16 feb 2019 we have weekends 19 jan 2019, 26 jan 2019, 2 feb 2019 and 9 Feb 2019 but I am not getting these Weekends in line Graph since we do not have any values on those weekends.

I want solution for this problem in SAS VA Only because I am dealing with large data and adding those weekends in SAS EG or DI makes the data too large to load.

Re: Missing weekends in Line Graphs becouse of not having values in those weekends in SAS VA

FredrikE — Mon, 18 Feb 2019 07:29:51 GMT

Hi!

Using the time series graph instead, might help you 🙂

//Fredrik

Re: Missing weekends in Line Graphs becouse of not having values in those weekends in SAS VA

Pmahendra — Mon, 18 Feb 2019 09:26:14 GMT

Hi fred,

In my Graph the requirement is to show weekly data,Time series graph split the interval based on the Range of Date available we can not manually fix the interval.

for example if we have dates in x axis from 1 jan to 30 feb than the interval would be weekly but if it varies across two years the interval automatically become monthly in time series plot

I want to show data on weekly basis only irrespective of whatever date range available.

Thanks

Mahendra