Chen Shimon

Hi Gentry,

Thank you for your answer. 

My view looks like this: 

I created a calculated attribute for the hour of the day (Columns)  and I am counting the number of tickets. 

I tried to use the path you mentioned: Under result manipulation > Totals > Advanced > Add New Total (Attribute:All Columns, Aggregator: AVG) > Add New Total (Attribute:All Columns, Aggregator: MED).

but I can't see the relevant option :

Any idea why?

 

Thank you

 

Hey,

 

I am using the Zendesk Tickets dataset. 

How can I create the average and median number of tickets created per hour metrics?

 

Thank you,

 

Chen