Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Average duration i graph

Hi!

The example below shows duration (TTR Event) per ID for one week.

Some ID's are missing duration values.

I can get a correct average value in a table.

The problem is is when I try to present average duration per week in a graph. E.g. I want to see '19:24' for week 45 in the graph

The TTR Event is calculated as this: '=if (source='Event', TTR, )'

1 Solution

Accepted Solutions
sunny_talwar

Create your calculated dimension in the script... it is doing as simple as this

Week(start_date) as Week

and then use that in your Aggr() function

View solution in original post

3 Replies
sunny_talwar

May be this

Avg(Aggr(Only({<source = {'Event'}>} TTR), ID, Week, source, create_date))

stekol61
Creator
Creator
Author

Hi!

It doesn't work, I get no result.

'Week' is a calculatet value. '=Week (start_date)' so i added this to your expression but it doesn't help. Stil no result in the graph

sunny_talwar

Create your calculated dimension in the script... it is doing as simple as this

Week(start_date) as Week

and then use that in your Aggr() function