https://community.qlik.com/t5/QlikView/Set-Analysis-to-Calculate-Avg-Days-a-Lead-in-Each-Stage/m-p/1559706#M744297 <P>Hi All,</P><P>Can you please help me to write a set Expression to calculate a Avg days spent&nbsp; a lead in each stages</P><P>These are stages a Lead passes into :&nbsp; We have new value and old value of each lead</P><P>I want to create a Staked Bar Chart. Month has Dimension and Stages&nbsp;</P><P>Attached the Data set</P><P>Propose<BR />Qualify<BR />Negotiate<BR />Develop<BR />Closing Signed Won</P> Sat, 16 Nov 2024 21:12:17 GMT kishoreravi1983 2024-11-16T21:12:17Z https://community.qlik.com/t5/QlikView/Set-Analysis-to-Calculate-Avg-Days-a-Lead-in-Each-Stage/m-p/1559706#M744297 <P>Hi All,</P><P>Can you please help me to write a set Expression to calculate a Avg days spent&nbsp; a lead in each stages</P><P>These are stages a Lead passes into :&nbsp; We have new value and old value of each lead</P><P>I want to create a Staked Bar Chart. Month has Dimension and Stages&nbsp;</P><P>Attached the Data set</P><P>Propose<BR />Qualify<BR />Negotiate<BR />Develop<BR />Closing Signed Won</P> Sat, 16 Nov 2024 21:12:17 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-to-Calculate-Avg-Days-a-Lead-in-Each-Stage/m-p/1559706#M744297 kishoreravi1983 2024-11-16T21:12:17Z