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

Changing Time Series Bins

Reply
Regular Learner
Posts: 1

Changing Time Series Bins

Hi,

 

I am using SASVA (Version 7.4) to build a dashboard of daily badge swipes for different buildings. I have multiple years of data (xxAug2016 - xxJuly2018) and can subset my report by building. I then set an aggregated value to count distinct badge swipes per day and automatically binned the time series to essentially show variability in how many people are swiping into buildings over time. I put the dates and unique swipes into a time series plot.

 

When I change the date slider to show about a year or less of data, the time series shows daily changes. The issue I run into however is when trying to show the full time frame (all 2 years of data), the time series re adjusts by binning to show monthly counts. Since the aggregated measure is set to count distinct badge swipes, I believe the time series plot counts distinct swipes per month (not day) and therefore inaccurately shows the data.

 

Is there a way to change this so binning stays at a daily level (although I know manual binning caps at 500 bins), or at the least accumulate daily unique swipes and not monthly unique swipes in the time series values?

 

Thanks.

Super User
Posts: 4,030

Re: Changing Time Series Bins

If you add a column in your data that counts distinct badge swipes per day, that should aggregate correctly regardless of how the data is binned in the time series.

Ask a Question
Discussion stats
  • 1 reply
  • 58 views
  • 0 likes
  • 2 in conversation