How to use max function with interval in dashboard

[abc_18]

Hi,

I am trying to use Max() function for below expression, and I am getting error in expression:-

if((Interval(

max(sum({<[WO edited new value]*={'Closed'},[WO edited field]*={'Field_Status__c'},[Owner = Editor]={'Yes'},[Work detail sub line type] = {'Labor'},

[WO retrospective]={'Correctly created'}>}

[WO edited date time]))-

max(sum({<[WO edited new value]*={'Closed'},[WO edited field]*={'Field_Status__c'},[Owner = Editor]={'Yes'},[Work detail sub line type] = {'Labor'},

[WO retrospective]={'Correctly created'}>}

[Work detail end date time]))

,'hh')*24)<24,'Yes','No')

output should be 'Yes' or 'No'

Please suggest.

[Gysbert_Wassenaar]

You are nesting two aggregations functions: max(sum. That's only possible if you use the aggr function so you can specify what dimension(s) the outer aggregation function needs to aggregate over. So you need something like max(aggr(sum(....), Dim1, Dim2, ... DimN)).

Replace Dim1, Dim2, ... DimN with the dimensions over which the sums should be grouped to calculate the max of the sums.