Help required regarding select in field

[Anonymous]

Hi All

i calculated the response time for opening a dashboard in access point , audit timestamp - session start , which is giving me the result , i took this this expression with different aggregations like max,min,avg .

Now the requirement is when i click on the Max text box it should show me the session is associated with it , so what i did is i took select in field in actions and field as session and i have given the same expression there but it is not working , please help kkkumar82‌gwassenaar‌swuehl‌kush141087‌mby‌mrkachhiaimp‌maxgro‌rwunderlich‌Robert_Mika‌AndreeBauer‌

[Anonymous]

Please find the attached QVW

[sunny_talwar · Accepted solution]

So you basically want to be able to select 1576?

Try this ->

=Concat(DISTINCT {<[Response Time] = {"$(=Max([Response Time]))"}>} Session)

or

=Concat(DISTINCT {1<[Response Time] = {"$(=Max([Response Time]))"}>} Session)

[Anonymous]

Awesome !!!!! Cheers bro

i am looking forward to connect with you 

[Anonymous]

Somehow this is not working for Min

[sunny_talwar]

Try now

Min -> ='(' & Concat(DISTINCT {1<[Response Time] = {"$(=Min([Response Time]))"}>} Session, '|') & ')'

Max -> ='(' & Concat(DISTINCT {1<[Response Time] = {"$(=Max([Response Time]))"}>} Session, '|') & ')'

[Anonymous]

Somehow this is not working for Min

[sunny_talwar]

Look at my response above. I have attached the qvw also to my response. See if that helps

[Anonymous]

HI

sorry for the ad hoc request . i am trying to build a master calendar but failing as the time stamp format  in the sever  and the calendar which i am trying to build is in different formats , i request you to help me to build a master calender so that i can extract day ,time , hour , week , month,month name and all possible fields from it

[Anonymous]

hi sunny i have extracted the date and other fields from session start but whats happening is the time stamp of the

session start contains nano seconds i guess , my response time filed is showing minimum response time as 0 secs i want to ceil it to 1

in short 0.5673 as 1 how can we do this  stalwar1‌

[sunny_talwar]

May be try this: Ceil(FieldName, (1/(24*60*60)))