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?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.