Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 kkkumar82gwassenaarswuehlkush141087mbymrkachhiaimpmaxgrorwunderlichRobert_MikaAndreeBauer
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)
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?
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
How about this:
='>' & Max(Second(Frac(([Audit Timestamp]) - [Session Start])), 2) & '<' & (Max(Second(Frac(([Audit Timestamp]) - [Session Start]))) + (1/86400))
Nope , nothing is getting selected
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))
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;
Did you try with TOTAL? Did not work?
i tried total it didnt work ,here are the screenshots for better understanding
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])), '##'))