how to show min and max values between start and end time in table

[balarajua]

Hi All,

I have to show the min and max value of downtime of websites with start and end time in below attached table format

Data:

Website	Starttime	Endtime	Downtime_in_minutes
https://abc1.com	3/15/21 18:57: 00 PM	3/16/21 5:32:00 AM	635
https://abc.com	3/15/21 18:57:00 PM	3/16/21 5:32:00 AM	63
https://abc2.com	3/15/21 18:57:00 PM	3/16/21 5:32:00 AM	64
https://abc.com	3/14/21 18:57:00 PM	3/15/21 5:32:00 AM	14
https://abc1.com	3/13/21 18:57:00 PM	3/14/21 5:32:00 AM	6

 Expected Result:

Type	Starttime	Endtime	DowTime
Miumum	3/13/2021 18:57	3/14/2021 5:32	6
Maximum	3/15/21 18:57: 00 PM	3/16/2021 5:32	635

[GaryGiles]

To get the Expected Results, you could use the following approach:

In a chart table, add a dimension with following:

=ValueList('Minimum','Maximum')

Then add 3 Measures with the following for Starttime, Endtime and Downtime, respectively:

=if(ValueList('Minimum','Maximum')='Minimum',Only({$<Downtime_in_minutes={$(=min(Total Downtime_in_minutes))}>} Starttime),
Only({$<Downtime_in_minutes={$(=max(Total Downtime_in_minutes))}>} Starttime))

=if(ValueList('Minimum','Maximum')='Minimum',Only({$<Downtime_in_minutes={$(=min(Total Downtime_in_minutes))}>} Endtime),
Only({$<Downtime_in_minutes={$(=max(Total Downtime_in_minutes))}>} Endtime))

=if(ValueList('Minimum','Maximum')='Minimum',Only({$<Downtime_in_minutes={$(=min(Total Downtime_in_minutes))}>} Downtime_in_minutes),
Only({$<Downtime_in_minutes={$(=max(Total Downtime_in_minutes))}>} Downtime_in_minutes))