Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to calculate the projection of current average value for month. Till Oct 11, 2020 my average is 1.89 using the below expression:
avg({<
$(v_Incident_Exclusion),
[Resolved Date.autoCalendar.YearMonth]={"$(v_MTD3)"},
SNOW_incident_incident_state={"Resolved","Closed"},
[SNOW_incident_u_substatus] -={"Cancelled"}
>}[SNOW_incident_u_resolved]-[SNOW_incident_sys_created_on])
When I want to project this average for rest of the month I am not getting the desired answer.
What I did
avg({<
$(v_Incident_Exclusion),
[Resolved Date.autoCalendar.YearMonth]={"$(v_MTD3)"},
SNOW_incident_incident_state={"Resolved","Closed"},
[SNOW_incident_u_substatus] -={"Cancelled"}
>}[SNOW_incident_u_resolved]-[SNOW_incident_sys_created_on])/11(number of days so far)*31(total number of days for the month)
I am not getting the right result. thanks in advance
@pkseenu can you share sample with expected output?
HI Kush,
Sorry I can't share the sample qvf. it is not allowed in my company 😞