I have a timestamp that represents when an item has been scanned by a barcode reader. I want to count these timestamps to determine how many scans are occurring during a given time period. I'm a little stumped, as my attempts to count using aggregation functions don't seem to work. Any help provided will be greatly appreciated!
Hello Marco! Thanks for responding. The relevant expression I'm using to create the time stamp is below:
------ begin code snippet --------------------------
IF([AUDIT_POSTNAME]='CASING_EDIT' OR [AUDIT_POSTNAME]='INITIAL_INSPECTION' OR [AUDIT_POSTNAME]='BUFFER' OR [AUDIT_POSTNAME]='CIA' OR [AUDIT_POSTNAME]='SKIVE' OR [AUDIT_POSTNAME]='REPAIR' OR [AUDIT_POSTNAME]='PRE_MOLD' OR [AUDIT_POSTNAME]='FINAL_INSPECTION' OR [AUDIT_POSTNAME]='SHIPPING' OR [AUDIT_POSTNAME]='RECIEVING' OR [AUDIT_POSTNAME]='ADJUSTMENT', timestamp(Min([Audit Create])))
------ end code snippet --------------------------
Where Audit Create is a date/time dimension.
I want to count the number of these 'timestamps' created over a specified time period to represent on a bar chart to see when the greatest number of them occur.
