Hi,
Hoping this is a simple answer. In summary, the STDEV expression I have below is not working.
=vAvgLine_SSNAPCBOnSceneDuration
+ StDev (aggr (
avg
( { < [Duration Clock Start to OnScene] = { '>0' } ,
[Duration Clock Start to OnScene] = { "=min ( [Duration Clock Start to OnScene] ) " },
[Responder Primary Sub-Type] = {'AMB', 'RRV' , 'DECA' } ,
[Duration On Scene] = { '>0' } ,
[Duration On Scene] = { "=min ( [Duration On Scene] ) " }
> }
( [Duration On Scene] / 86400 )
) , [Year And Month Sort]
)
)
*
vStdDev
- Where 'vAvgLine_SSNAPCBOnSceneDuration' is :
avg
( aggr (
min ( { < [Duration Clock Start to OnScene] = { '>0' } ,
[Duration Clock Start to OnScene] = { "=min ( [Duration Clock Start to OnScene] ) " },
[Responder Primary Sub-Type] = {'AMB', 'RRV' , 'DECA' } ,
[Duration On Scene] = { '>0' } ,
[Duration On Scene] = { "=min ( [Duration On Scene] ) " }
> }
( [Duration On Scene] / 86400 )
), [Source Call Number], [Year And Month Sort]
)
)
I've done this for other similar measures (which were more simple e.g. the avg ( aggr (avg (fieldname) , yearmonth) ) but the above has me stumped. What would be the solution?
(I can't share the data due to confidential reasons).
Thanks in advance.
