0

I have this dataset

weekday    hour    id    duration
Sunday     1       1     20
Sunday     1       1     30
Sunday     1       2     10

I want to have average duration for weekday hour. The step is sum over the weekday, hour, id and then average it over weekday and hour. I want the result like this on the AWS Quicksight or maybe another BI tools

weekday  hour  averageDuration
Sunday   1     (20+30+10)/2
OctavianWR
  • 217
  • 1
  • 16

1 Answers1

1

I used the following dataset:

enter image description here

I then added the following calculated field:

avgOver(sum(duration), [hour])/distinct_count(id)

to get the following result:

enter image description here

Frank Servy
  • 86
  • 7