Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Like this
That is possible, Will you able to provide sample data set with Days combination ?
Hi Please see the attached sample data file
I am not looking to create this in the script, just within the chart Dimension
Like this
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
As a dimension, you would need Aggr()...
=Aggr(Time(Min(StartTime), 'hh:mm'), Picker)
=Aggr(Time(Max(EndTime), 'hh:mm'), Picker)
Thanks Again