BookmarkSubscribeRSS Feed
DannyC
Calcite | Level 5

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.

1 REPLY 1
SASKiwi
PROC Star

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.

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 749 views
  • 0 likes
  • 2 in conversation