Need help using date_diff with an if statement
SummaryI am trying to find the resolution time on incidents that are only in certain product families
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.