Hi all Below is the table for the analysis: * There can be various numbers of 'people' (rows) within in each group (can range up to 200 rows per group) * I want to be able to analyse per row within each group Ask: Within each group, I want to say * Oldest date column - identify the oldest date in each group and create a new column Oldest date * Analyse within each group if the search date is older than the oldest date column (e.g. 3 Nov is older than 17 Nov so an older date was found from within the group) * Where there is no individual search date,result should be cannot find search GroupIDRank in each groupInvidual SearchOldest date in the groupResultAABC117/11/202003/11/2020Older date was foundACDE217/11/202003/11/2020Older date was foundAEFG303/11/202003/11/2020No older date was foundBHIJ1 Cannot Find SearchBERT227/10/202027/10/2020 CFYU102/07/202002/07/2020No older date was foundCSDV221/01/202102/07/2020Older date was foundCBJY321/10/202002/07/2020Older date was foundCGJY4 02/07/2020Cannot Find Search

Analyse dates within a group in a dataset

h12

Hi all

Below is the table for the analysis:

There can be various numbers of 'people' (rows) within in each group (can range up to 200 rows per group)
I want to be able to analyse per row within each group

Ask:

Within each group, I want to say

Oldest date column - identify the oldest date in each group and create a new column Oldest date
Analyse within each group if the search date is older than the oldest date column (e.g. 3 Nov is older than 17 Nov so an older date was found from within the group)
Where there is no individual search date,result should be cannot find search

Group	ID	Rank in each group	Invidual Search	Oldest date in the group	Result
A	ABC	1	17/11/2020	03/11/2020	Older date was found
A	CDE	2	17/11/2020	03/11/2020	Older date was found
A	EFG	3	03/11/2020	03/11/2020	No older date was found
B	HIJ	1			Cannot Find Search
B	ERT	2	27/10/2020	27/10/2020
C	FYU	1	02/07/2020	02/07/2020	No older date was found
C	SDV	2	21/01/2021	02/07/2020	Older date was found
C	BJY	3	21/10/2020	02/07/2020	Older date was found
C	GJY	4		02/07/2020	Cannot Find Search

Workflow

Accepted answers

atcodedog05

Hi @h12

Here is my take on the usecase

Workflow:

Hope this helps : )

older data.yxmd

messi007

@h12,

Here you go

Attached the new version of the workflow

CheckDate_20211008.yxmd

All comments

messi007

@h12,

Please see below

Attached the workflow,

Regards

CheckDate_20211008.yxmd

h12

Thank you! You know where the search date is null , I would like the last column to say no search date, I think currently it brings through a date (row 4 in your screenshot)