1 Reply Latest reply on Oct 31, 2016 1:02 PM by Raj Kumar

# Calculated field for defining ranges using Count of aggregated measure

Hi,

I have two date fields [Start Date], [Closed Date]. 10 issues started and closed between these dates which belong to Group A and B. The difference between [Start Date] and [Closed Date] gives the days it took to close the issue. 5 issues have been closed, their status is Closed and remaining 5 are still open. 1 issue took 2 days, remaining 4 issues took 6 days to close. I want to see the issues closed under the ranges 0-4 days and > 4 days for groups A and B. Group A has 2 issues that are closed in 6 days, while Group B has 2 issues closed in 6 days and 1 issue in 2 days.

Created a calculated field to find the difference of days.
[Days Diff] = DATEDIF('day', [Start Date],[Closed Date])

Trying to create a calculated field to find the issues closed under different ranges.

[Range] = IF { FIXED [Group]: SUM([Days Diff])} >= 0 and { FIXED [Group]: SUM([Days Diff])} < 5 then " 0 - 4 days"
ELSEIF { FIXED [Group]: SUM([Days Diff])} > 4 then "5 days and Over"
ELSE "Null"
END

But this is not giving me desired result. Need help.

Thanks

Raj

• ###### 1. Re: Calculated field for defining ranges using Count of aggregated measure

Issue is resolved, find the attached workbook for more info. One thing I found from this issue is, if we can recreate this issue with less sample data, we will get some ideas of how to get the solution. It worked for me.