Skip to main content
Question

Summary Field that Counts how many Date / Time records are in that Date per User

  • February 8, 2022
  • 0 replies
  • 35 views

Forum|alt.badge.img+6
Hi,

I have a tough situation that I am desperately trying to wrap my head around.  I have two tables: A technician table (One) to a Measure table (Many).  So 1 Technician can have many measures. 

I have a report from the measure table where I can see that a technician, in this example Aaron with many Time_iM_SnapshotTI (a date /  time field).  I need to count how many snapshots happen per Time_iM_SnapshotTI date for that technician.  For example Aaron Smith will have 2 Time_iM_SnapshotTI for 9/3/2021 and 9/7/2021 respectively.  How do i go about summarizing based on that fields date and technician?


Thank you so very much in advance, you all blow my mind in terms of expertise and wisdom!

------------------------------
Lija Harris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
I suggest a simple Summary report.  

Group by:
Tech
Time_iM_SnapshotTI and group the date/time field by Day.  

This is a different type of report than the table report type you are currently using.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------