Average hour of the day plot

[prees959]

Hi

I have an expression to show the average time of day an event occurred :

=time(avg([Updated Time]),'hh:mm')

What I would like to show is a line chart with the Monday to Sunday along the x axis and show the average Updated Time as a line across the days.  Is this possibe?

Thanks,

Phil

[Anil_Babu_Samineni]

May be create Dimension as Days and use same formula as expression

[prees959]

Hi Thanks for your reply,

I have tried

which now gives this :

Can you help?

Thanks

Phil

[dinuwanbr]

Hi Phil,

Try to use this

=time(aggr(avg(Updated_Time),DayOfWeek),'hh:ss')

else Can you upload a sample here.

Rgds,

Tharindu

[prees959]

Hi,

is this the Expression ?

[dinuwanbr]

=time(aggr(avg(Updated_Time),DayOfWeek),'hh:ss')

[sunny_talwar]

Use DayOfWeek as dimension

and =time(avg([Updated Time]),'hh:mm') as expression