Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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, ', ')
try this:
date(num(today())-(max(today() - [Created Date])))
hope this helps
May be use this?
=Only({<[Created Date] = {'$(=Max([Created Date]))'}>}Call)
Hi Nayan,
use the following:
=Only({<[Created Date] = {'$(=Min([Created Date]))'}>}Call)
as you are after the OLDEST date
HTH
Andy
Hi Nayan,
As Andrew mention use the following expression given by andrew:
=Only({<[Created Date] = {'$(=Min([Created Date]))'}>}Call)
It works perfectly
Or by using Firstsortedvalue:
FirstSortedValue(Call,[Created Date],1)
May be this:
=FirstSortedValue(Call, [Created Date])
Hi All
Thank you for your reply. It was helpful. I have additional conditions ,where the
See new data attached and the model.
How do I get the oldest Call number?
Kind regards
Nayan
May be this:
=FirstSortedValue({<[Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, [Created Date])
or this:
=Only({<[Created Date] = {'$(=Min([Created Date]))'}, [Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call)