Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, )'
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
May be this
Avg(Aggr(Only({<source = {'Event'}>} TTR), ID, Week, source, create_date))
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
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