convert to set analysis

[gauravgg]

Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))

Hi Please find the attached excel for data

Convert to set analysis‌

[sunny_talwar]

What is the expected output here?

[gauravgg]

Hi

I have to convert

Sum(If( Aggr(nodistinct Min(Datetime), BusinessID) = Datetime, OpeningBalance))

into set analysis.

[MK_QSL]

I think he wants Opening Balance total for each BusinessID on Minimum DateTime.

[sunny_talwar]

I think this should work

Dimension:

BussinessID

Expression:

FirstSortedValue([Opening Balance], -Datetime)

[gauravgg]

yes

[Aurelien_Martinez]

Hi,

Sum({<Datetime={'$(=Date(Min(Datetime)))'}>} OpeningBalance)

[gauravgg]

hi sunny

I have to group businessid and get the min date of that particular businessid and its opening balance value

[sunny_talwar]

I guess try this:

Dimension:

BussinessID

Expression:

Date(Min(Datetime)

FirstSortedValue([Opening Balance], Datetime)

[sasiparupudi1]

=sum({<Datetime={'$(=Aggr(MinString(Datetime),BusinessID))'}>}[Opening Balance])