Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
There should be nothing special about counting timestamps.
Can you describe the relevant parts of your data model and the expressions you are using?
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.