Text Box - Value link to an expression

[Anonymous]

Hi

I need help with an expression in a text box.  Attached herewith is data relating to Calls and the date the Call was created.

I want an expression to tell me which is the oldest call?  The answer should be IR1086.  How do i do this? I have worked out the number of days the oldest call is, which is 197 days.

Please can you assist.

Kind regards

Nayan

[yoganantha321]

Hi nayan,

try with this,

=Only({<[Created Date] = {'$(=Min([Created Date]))'},"Service Level={'Active'},Call Type={'Incidents'}>}Call)

[Anonymous]

Thank you all for the responses to my second question.

One quick question.  If there are 2 Calls that have the same oldest date, the Call numbers wont show.  Is that correct or is there a way to solve this?

Kind regards

Nayan

[sunny_talwar · Accepted solution]

Which of the two would you want to see? If Randomly any... you can try this

=FirstSortedValue(DISTINCT {<[Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, [Created Date])

If both, then this

=Concat({<[Created Date] = {'$(=Min([Created Date]))'}, [Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, ', ')

[awhitfield]

Hi Nayan,

this will work for multiple values:

=Concat({<[Created Date] = {'$(=Min([Created Date]))'}>}Call, ' ')

Andy

[Anonymous]

Thank you Sunny, it worked