topic Re: Counting Time Stamps in App Development

Counting Time Stamps

aschmeelk — Tue, 08 Mar 2022 20:29:20 GMT

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!

Re: Counting Time Stamps

MarcoWedel — Tue, 08 Mar 2022 20:45:48 GMT

There should be nothing special about counting timestamps.
Can you describe the relevant parts of your data model and the expressions you are using?

Re: Counting Time Stamps

aschmeelk — Tue, 15 Mar 2022 14:04:07 GMT

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.