Duration between Max date and Min date in selected Month
I have a field called begin in YYYY-MM-DD hh:mm:ss format. I need to calculate the duration between Max(begin) and Min(begin), which is working good. But I want to make this for max month. how to do this?
set v2 = min(begin);
In KPI Expression: Interval($(v1) - $(v2) ,'mm')*1440 --- this is working fine.
[begin] AS [begin],
Date(MonthStart(date#([begin],'YYYY-MM-DD hh:mm:ss')), 'MMM-YYYY') as Begin_Month_Year,
Set vMaxMonthOutage= max(Begin_Month_Year);
I want to apply this vMaxMonthOutage variable in interval expression. How to do this? Or any other way?
I want to calculate the duration in Minutes for between Maximum of Begin and Minimum of begin. that would be by default for current month. Lets say we have a table outage. Which is having data for system outage.
I want to calculate 5-Nov-2016 - 2-Nov-2016 in minutes.