Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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>)