topic Advanced Average Calculation for Multiple Averages in QlikView https://community.qlik.com/t5/QlikView/Advanced-Average-Calculation-for-Multiple-Averages/m-p/399289#M1157307 <HTML><HEAD></HEAD><BODY><P>I have two working "average" calculations I would like to find the average of for forecasting/what-if purposes:</P><P></P><P>This first one calculates the average time taken from beginning (add_date) to end (dev_finish_date) in hours. This only calculates completed requests that have a dev_finish_date.</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13575685157543682" jivemacro_uid="_13575685157543682"><P></P><P><SPAN style="font-family: courier new,courier; font-size: 12pt;">=avg({$&lt;dev_finish_date={"&gt;$(=Timestamp(now()-91))"}&gt;}(dev_finish_date-add_date))*24</SPAN></P></PRE><P>&nbsp; </P><P>The second expression calculates the average number of hours all "open" requests have been open. BM09 has '22' selected in the field "app_id", and all but 'Setup Complete' selected in the field "status_name".</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13575685035043964" jivemacro_uid="_13575685035043964"><P></P><P><SPAN style="font-family: courier new,courier; font-size: 12pt;">=avg({BM09}num(((today())-add_date),'#,##0.00'))*24</SPAN></P></PRE><P> <BR />What I would like to do is get an average of the two expressions to illustrate how the remaining requests would affect the overall cycle time if they were all finished sometime today.</P><P></P><P>Thanks for your help, and please be patient with my response time after 6PM EST since the next day I'll be in will be next Sunday Jan 13. Any clarification needed, feel free to ask.</P></BODY></HTML> Mon, 07 Jan 2013 14:24:26 GMT 2013-01-07T14:24:26Z Advanced Average Calculation for Multiple Averages https://community.qlik.com/t5/QlikView/Advanced-Average-Calculation-for-Multiple-Averages/m-p/399289#M1157307 <HTML><HEAD></HEAD><BODY><P>I have two working "average" calculations I would like to find the average of for forecasting/what-if purposes:</P><P></P><P>This first one calculates the average time taken from beginning (add_date) to end (dev_finish_date) in hours. This only calculates completed requests that have a dev_finish_date.</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13575685157543682" jivemacro_uid="_13575685157543682"><P></P><P><SPAN style="font-family: courier new,courier; font-size: 12pt;">=avg({$&lt;dev_finish_date={"&gt;$(=Timestamp(now()-91))"}&gt;}(dev_finish_date-add_date))*24</SPAN></P></PRE><P>&nbsp; </P><P>The second expression calculates the average number of hours all "open" requests have been open. BM09 has '22' selected in the field "app_id", and all but 'Setup Complete' selected in the field "status_name".</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13575685035043964" jivemacro_uid="_13575685035043964"><P></P><P><SPAN style="font-family: courier new,courier; font-size: 12pt;">=avg({BM09}num(((today())-add_date),'#,##0.00'))*24</SPAN></P></PRE><P> <BR />What I would like to do is get an average of the two expressions to illustrate how the remaining requests would affect the overall cycle time if they were all finished sometime today.</P><P></P><P>Thanks for your help, and please be patient with my response time after 6PM EST since the next day I'll be in will be next Sunday Jan 13. Any clarification needed, feel free to ask.</P></BODY></HTML> Mon, 07 Jan 2013 14:24:26 GMT https://community.qlik.com/t5/QlikView/Advanced-Average-Calculation-for-Multiple-Averages/m-p/399289#M1157307 2013-01-07T14:24:26Z