Compare with previous records

[lalita_sharma]

App ID	Date	Feature	Feature Onboarding Date
IN-4030	Aug-21	CI	31/12/2020
IN-4030	Jul-21	CI	31/12/2020
IN-4030	Aug-21	DL	31/12/2020
IN-4030	Jul-21	DL	31/12/2020
IN-4030	Aug-21	DS	31/12/2021
IN-4030	Jul-21	DS	31/12/2020
IN-4030	Aug-21	FC	31/12/2020
IN-4030	Jul-21	FC	31/12/2020
IN-4030	Aug-21	LC	31/12/2022
IN-4030	Jul-21	LC	31/12/2021
IN-4030	Aug-21	LCN	31/12/2020
IN-4030	Jul-21	LCN	31/12/2020
IN-4030	Aug-21	LD	31/12/2022
IN-4030	Jul-21	LD	31/12/2022
IN-4030	Aug-21	PO	NA
IN-4030	Jul-21	PO	NA
IN-4030	Aug-21	SF	NA
IN-4030	Jul-21	SF	NA
IN-4030	Aug-21	VS	NA
IN-4030	Jul-21	VS	NA

I have dataset which looks like above. I want to find out the Features that have different Feature Onboarding dates for August and July. For Ex.: DS and LC in above sample data and display the names of Feature in a text box.

How can I achieve this?

[mato32188]

Hi @lalita_sharma ,

you can simply count unique occurrences of Feature Onboarding Date and then create flag to highlight particular Feature.

MAP_COUNT_ONBOARDING_DATES:

Mapping Load

Feature,

count(distinct [Feature Onboarding Date])

FROM xxx

group by Feature;

table:

Load

[App ID],

Feature,

Date, 

[Feature Onboarding Date],

ApplyMap('MAP_COUNT_ONBOARDING_DATES',Feature,null()) as [#Feature Onboarding Dates]

FROM xxx;

Then in text object use expression concat({<  [#Feature Onboarding Dates] = {">1"}>}distinct Feature,',').

BR

m

[Saravanan_Desingh]

Try this in a Text Box,

=Concat(DISTINCT{<Feature={"=Count(DISTINCT [Feature Onboarding Date])>1"}>}Feature,', ')

[lalita_sharma]

Hi @mato32188 

Thanks for the solution. This would work perfect in the script. But I want to do this in the front end in a text box. Can you suggest something that will work in the front end.

Thanks

Lalita

[lalita_sharma]

Hi @Saravanan_Desingh 

Thank you for the solution. This expression works perfect for the sample data set I provided above. But when I try to extend this expression to the larger dataset(attached) that has additional records for AppId's and Evaluation Year, it doesnt seem to work.

Expression I am using:   =Concat(DISTINCT{<[AppID] ={'IN-4030'}, Year ={'2021'}, Feature={"=Count(DISTINCT [Feature_Onboarding_Date])>1"}>}Feature,', ')

Out of this expression:  CI, DL, DS, FC, LC, LCN, LD

Desired Output : DS, LC

Could you please help me understand what is wrong with my expression?

Please refer to attached file for complete dataset.

[mato32188 · Accepted solution]

Hi @lalita_sharma ,

try to modify your expression

Concat(DISTINCT{<[AppID] ={'IN-4030'}, Year ={'2021'}, Feature={"=Count({<[AppID] ={'IN-4030'}, Year ={'2021'}>}DISTINCT [Feature_Onboarding_Date])>1"}>}Feature,', ')

br

m

[Saravanan_Desingh · Accepted solution]

Try this,

=Concat(DISTINCT{<[AppID] ={'IN-4030'}, [Evaluation Year]={2021},Feature={"=Count({<[AppID] ={'IN-4030'}, [Evaluation Year]={2021}>}DISTINCT [Feature Onboarding Date])>1"}>}Feature,', ')

[lalita_sharma]

Thanks @Saravanan_Desingh 

This works perfect!!

[lalita_sharma]

Thanks @mato32188 

This works perfect!!