If Less than in line chart

[Amberj_29]

Hi All,

I'm looking to do something that is probably simple but I cannot get it to work. I'm wanting to show on a line chart all cases that took less than 15 days to resolve and show the average for that month, here is the formula I've tried and failed with:

=if(Avg([Last_Ammended_Date.autoCalendar.Date]) - ([Compl_Date_Created.autoCalendar.Date])<=15)

Help is appreciated.

Thanks.

[stevejoyce]

Best case would be you add the delta # days in your data model and use that in your set analysis.

Otherwise your calculation would be:

avg({<Case = {"=[Last_Ammended_Date.autoCalendar.Date]) - ([Compl_Date_Created.autoCalendar.Date])<=15"} >}    <measure>)