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‌

[sunny_talwar]

You may not be able to equate timestamp due to rounding errors and may need to use greater then equal to and less than equal to conditions. Would you be able to share a sample to see what is going on?

[Anonymous]

cant share , its confidential

here is the expressions :

=max(Second(Frac(([Audit Timestamp]) - [Session Start]))) - i took this expression which is giving me the value of 54, so when i click on this text box i want the data get filtered and show me in which session it took 54 seconds to load

[sunny_talwar]

How about this:

='>' & Max(Second(Frac(([Audit Timestamp]) - [Session Start])), 2) & '<' & (Max(Second(Frac(([Audit Timestamp]) - [Session Start]))) + (1/86400))

[Anonymous]

Nope , nothing is getting selected

[sunny_talwar]

How about this:

Max(TOTAL Second(Frac(([Audit Timestamp]) - [Session Start])))

or

='>' & Max(TOTAL Second(Frac(([Audit Timestamp]) - [Session Start])), 2) & '<' & (Max(TOTAL Second(Frac(([Audit Timestamp]) - [Session Start]))) + (1/86400))

[Anonymous]

Here is the Script i am using :

LOAD //[Server Started],

     Timestamp as [Audit Timestamp],

     //Document,

     Type,

     User ,

     Message,

     Id as AuditID ,

     Session

LOAD [Exe Type],

     [Exe Version],

     [Server Started],

     Timestamp,

     Document,

     [Document Timestamp],

     [QlikView User],

     [Exit Reason],

     [Session Start],

     [Session Duration],

     [CPU spent (s)],

     [Bytes Received],

     [Bytes Sent],

     Calls,

     Selections,

     [Authenticated user],

     [Identifying user],

     [Client machine identification],

     [Serial number],

     [Client Type],

     [Client Build Version],

     [Secure Protocol],

     [Tunnel Protocol],

     [Server Port],

     [Client Address],

     [Client Port],

     [Cal Type],

     [Cal Usage Count],

     Session

Temp:

load

[Authenticated user],

[Session Start]

resident Session;

left join (Temp)

load

User,

[Audit Timestamp]

resident Audit;

Data:

load

User,

[Session Start],

[Audit Timestamp],

Second(Frac(([Audit Timestamp]) - [Session Start])) as Response

resident Temp;

DROP Table Temp;

[sunny_talwar]

Did you try with TOTAL? Did not work?

[Anonymous]

i tried total it didnt work ,here are the screenshots for better understanding

[sunny_talwar]

Is Session a number field or time field in seconds? You can check this by creating a list box with this expression -> Num(Session). If it is showing decimal numbers then it is in seconds, else it is number. If it is number, try this:

=Max(Num#(Second(Frac(([Audit Timestamp]) - [Session Start])), '##'))