Can I create a dashboard widget that shows a count of unique date/time values?
We have a board where team members record training activity conducted. Each row item is an individuals name, with key column fields (company, duration, status and date/time).
If a group session is conducted, the team member still records each individual as an item, even if they all attended the same session. I.e. a 1 hour group session on 29/01/2021 at 10:00am with 10 individuals means there are 10 items with the same time/date.
Currently, these would all be counted as individual sessions totalling 10 hours of activity instead of 1 hour. I’m looking to be able to count only the unique date/time values so we can distinguish one-to-one sessions from group sessions.