Show Start Time and End Time

[rustyfishbones]

Hi,

I am creating a straight table with transactions for today.

I want to add a Dimension for each user showing the first transaction time and the last transaction time

User Qty    Start Time End Time

Alan 1000   08:15        14:59

each transaction has a start time and an end time, so I could have hundred of them for each user.

I only want to display the very first StartTime for the selected Day and the very last EndTime for the selected day

What's the best approach.

[Anil_Babu_Samineni]

That is possible, Will you able to provide sample data set with Days combination ?

[rustyfishbones]

Hi Please see the attached sample data file

[rustyfishbones]

I am not looking to create this in the script, just within the chart Dimension

[sunny_talwar · Accepted solution]

Like this

[rustyfishbones]

Yes, that's it, I did try that as a calculated Dimension but it returned an error.

This is what actually worked for me.

TIME(MIN(StartTime),'hh:mm')

TIME(MAXEndTime),'hh:mm')

and as an Expression not a Dimension

[sunny_talwar]

As a dimension, you would need Aggr()...

=Aggr(Time(Min(StartTime), 'hh:mm'), Picker)

=Aggr(Time(Max(EndTime), 'hh:mm'), Picker)

[rustyfishbones]

Thanks Again