Count unique date/times on Dashboard

FAQs
#1

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.

#2

Of course, I am open to suggestions on how to modify our processing of these items if it achieves the goal.

#3

Hi @SteveE - Without seeing your boards or knowing more, perhaps using SubItems for the individual records when something is a group training event, with the main Items being kept for sessions?

#4

Hi,

Screenshot of the board attached. You can see these are all group sessions, where the item is the individual.

What I’d like to count is how many unique instances there are, based on the date column. Using the attached example, there are 4 group training sessions as there are four specific dates/times set - just some have more than one individual attending.

The reason we’ve not used subitems is that it would require replicating all columns for ea

Screenshot 2021-02-02 103039
Screenshot 2021-02-02 1030391506×408 70.2 KB
ch individual, and they can’t be imported in bulk like a main item would.

#5

Hey @SteveE,

Would filtering be at all helpful here? You could filter by one of the four group training sessions or specific dates/times to see how many unique instances there are. The Board Filters

#6

Thanks for replying.

Filtering works on the main board which is great for snapshots of certain activities, but I was really hoping there would be a way to display a summary ‘count’ of the unique entries on a Dashboard view.

The Pivot function may have allowed me to achieve this but it’s Enterprise-only so really looking for a workaround of sorts.

Thanks.

#7

Hi @SteveE - If you want to expand your reporting capabilities without upgrading to Enterprise, have you checked out the Screenful reporting app in the official monday․com Marketplace? monday.com: Apps Marketplace may be helpful for you.

1 Like
#8

Appreciate the suggestion - we trialled Screenful and found the dashboards very visually useful but are yet to figure out whether the original query can be resolved on a Pro plan without having to extract all data to Excel and manipulate it there.