Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Need help using date_diff with an if statement — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need help using date_diff with an if statement

Received Response
23
Views
1
Comments
edited Feb 6, 2020 8:31PM in Field Service 1 comment

Summary

I am trying to find the resolution time on incidents that are only in certain product families

Content

Hello,

I am trying to find the average resolution time on incidents that are only in certain product families.  and using the following expression but keep getting errors.  Any help would be greatly appreciated.

Here is the expression:

if(incidents.c$productfamily IN (75,91,811,812,833,840,841,844,845,948,952,955,956,966,968,969,970,971,972,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,990,992,993,994,995,996,997,998,999,1000,1001,1002,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1045,1046,1051,1084,1085,1131,1167,1168,1169,1170,1172,1186,1190,1194,1195,1197,1198,1199,1200,1201,1205,1206,1207,1214,1215,1216,1217,1218,1220,1221,1222,1223,1224,1225,1226,1227,1228,1232,1236,1283,1302,1315,1316,1317,1318,1319,1320,1369,1370,2219,2262,2280,2287,2288,2292,2363), avg (date_diff (incidents.c$actualstartdate, incidents.c$actualenddate)) / -86400

I have tried with the avg statement before and after the if statement but cant seem to get it to work.  I know i could use a filter but this is one "technology" grouping of product families and i have multiple other statements with other technologies, so report filtering wont work in this case.  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!