topic Avg Logging Time calculation in App Development

Avg Logging Time calculation

chaitanyajami — Wed, 25 Jul 2018 15:35:23 GMT

Hi All,

iam adding new visualizations in existing Qliksense operations monitoring app, required your suggestions or inputs to derive certain kpi's , i want to calculate Daily Avg Logging time ,we have Log Entry Period Start and Log Timestamp fields in Log Content table, are those to be used to achieve the kpi? how do i achieve it ? and also what is the difference between Logging time & Session time in context of Qliksense environment?

Re: Avg Looging Time calculation

YoussefBelloum — Wed, 25 Jul 2018 15:52:34 GMT

Hi,

don't know what is the fields you can use and what type of Kpi's you need exactly.. but it is clear that you will have to calculate the difference between two timestamp fields.

you will need to evaluate your fields using Timestamp#()

and then calculating the difference of time using Interval()

like this:

Interval(Timestamp#(....) - Timestamp#(....),'the format you need')

Re: Avg Logging Time calculation

chaitanyajami — Thu, 26 Jul 2018 11:24:29 GMT

Hi Youssef,

Thanks for the response, i want to calculate the average logging time by users in Qliksense operational monitoring app which collects all the log information. but above expression was not working if iam using in KPI object

Re: Avg Logging Time calculation

YoussefBelloum — Thu, 26 Jul 2018 11:59:34 GMT

If you make some selections on the Log Id it works?

you need to have an aggregated view ? or by Log Id after selections ?

Re: Avg Logging Time calculation

chaitanyajami — Thu, 26 Jul 2018 14:27:56 GMT

i need to show this avg logging time as kpi object as aggregated value

Re: Avg Logging Time calculation

YoussefBelloum — Thu, 26 Jul 2018 14:35:49 GMT

try nested aggregation using Aggr() outside of the existing expression, aggregating on the Log Id field for example

like this:

=AGGR(your_expression,LOF_ID_FIELD)