Hi,
I want to create a bar chart that shows the number of on time/late activities per department. I have 3 fields, [department], [planned finish date], and [actual finish date]. I was wondering if there was a way on the fly in the field expression to calculate a total count of late and on time activities by an if statement like if([actual finish date] - [planned finish date] > 0, 'Late', 'On time'). I would like to do this without having to add a calculated field in my data manager section.
thanks.