Finding min and max based on selection

krishna20 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

I have an requirement from the client side that is saying

my input is

What we need out put here

Scenario1: user select multiple months we need to take min month of PREVCLUSTER and max month of CURRCLUSTER

output:if we selected jan_apr for 235863 min start date of PREVCLUSTER Nuetral and there is no apr month for this account id

this senario we need to take mar as max start date and calculate

Senario2: if you select apr to july for 235863 there is no records for that range of selection

out put: we need to take may month of PREVCLUSTER and jun month of CURRCLUSTER

do you have any idea on this please suggest me

Thanks

Re: Finding min and max based on selection

Fri, 06 Jan 2017 10:00:31 GMT

Hi Krishna ,

Small clarification ,are you expecting output is date or account -id

sunny_talwar — Fri, 06 Jan 2017 10:39:07 GMT

This?

Expressions

1) =FirstSortedValue(Aggr(Concat(DISTINCT PREVCLUSTER, ', '), START_DATE, ACCOUNT_ID), Aggr(START_DATE, ACCOUNT_ID, START_DATE))

2) =FirstSortedValue(Aggr(Concat(DISTINCT CURRCLUSTER, ', '), START_DATE, ACCOUNT_ID), -Aggr(START_DATE, ACCOUNT_ID, START_DATE))