Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to show the min and max value of downtime of websites with start and end time in below table format
Data:
Website | Starttime | Endtime | Downtime_in_minutes |
3/15/21 18:57: 00 PM | 3/16/21 5:32:00 AM | 635 | |
3/15/21 18:57:00 PM | 3/16/21 5:32:00 AM | 63 | |
3/15/21 18:57:00 PM | 3/16/21 5:32:00 AM | 64 | |
3/14/21 18:57:00 PM | 3/15/21 5:32:00 AM | 14 | |
3/13/21 18:57:00 PM | 3/14/21 5:32:00 AM | 6 |
Expected Result:
Type | Starttime | Endtime | DowTime |
Minimum | 3/13/2021 18:57 | 3/14/2021 5:32:00 | 6 |
Maximum | 3/15/21 18:57: 00 PM | 3/16/2021 5:32:00 | 635 |
@balarajualike
Dimension :
=Valuelist('Minimum','Maximum')
Measures:
Starttime->
Pick(Match(Valuelist('Minimum','Maximum'),'Minimum','Maximum'),
FirstSortedValue(Starttime,Downtime_in_minutes),
FirstSortedValue(Starttime,-Downtime_in_minutes))
Endtime->
Pick(Match(Valuelist('Minimum','Maximum'),'Minimum','Maximum'),
FirstSortedValue(Endtime,Downtime_in_minutes),
FirstSortedValue(Endtime,-Downtime_in_minutes))
DowTime->
Pick(Match(Valuelist('Minimum','Maximum'),'Minimum','Maximum'),
min(Downtime_in_minutes),
max(Downtime_in_minutes))
output :