https://community.qlik.com/t5/QlikView/Simple-day-average-from-2-fact-rows-aggregated-by-order/m-p/1688587#M450517 <P>Hello guys, I have a simple question about calculating average date diff (in days) between two facts of the same order.</P><P>Here is a sample data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik_DateDiff1.png" style="width: 264px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30763iD1F71550FA80452D/image-size/large?v=v2&amp;px=999" role="button" title="Qlik_DateDiff1.png" alt="Qlik_DateDiff1.png" /></span></P><P>The result should be 4,4.&nbsp;<BR />I think I should use Aggr by Order Id but I don't know how to calculate the delta using the 2 Fact Types (SENT and DELIVERED).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik_DateDiff2.png" style="width: 217px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30764i42922EBD5F96A1D7/image-size/large?v=v2&amp;px=999" role="button" title="Qlik_DateDiff2.png" alt="Qlik_DateDiff2.png" /></span></P><P>&nbsp;</P><P>Can you help with that measure? Thank you</P> Fri, 27 Mar 2020 16:50:38 GMT FinService 2020-03-27T16:50:38Z https://community.qlik.com/t5/QlikView/Simple-day-average-from-2-fact-rows-aggregated-by-order/m-p/1688587#M450517 <P>Hello guys, I have a simple question about calculating average date diff (in days) between two facts of the same order.</P><P>Here is a sample data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik_DateDiff1.png" style="width: 264px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30763iD1F71550FA80452D/image-size/large?v=v2&amp;px=999" role="button" title="Qlik_DateDiff1.png" alt="Qlik_DateDiff1.png" /></span></P><P>The result should be 4,4.&nbsp;<BR />I think I should use Aggr by Order Id but I don't know how to calculate the delta using the 2 Fact Types (SENT and DELIVERED).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik_DateDiff2.png" style="width: 217px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30764i42922EBD5F96A1D7/image-size/large?v=v2&amp;px=999" role="button" title="Qlik_DateDiff2.png" alt="Qlik_DateDiff2.png" /></span></P><P>&nbsp;</P><P>Can you help with that measure? Thank you</P> Fri, 27 Mar 2020 16:50:38 GMT https://community.qlik.com/t5/QlikView/Simple-day-average-from-2-fact-rows-aggregated-by-order/m-p/1688587#M450517 FinService 2020-03-27T16:50:38Z https://community.qlik.com/t5/QlikView/Simple-day-average-from-2-fact-rows-aggregated-by-order/m-p/1695451#M450920 <P>Best I have is the following, hopefully may put you on the right track:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822</A></P><P>Regards,<BR />Brett</P> Tue, 21 Apr 2020 20:50:47 GMT https://community.qlik.com/t5/QlikView/Simple-day-average-from-2-fact-rows-aggregated-by-order/m-p/1695451#M450920 Brett_Bleess 2020-04-21T20:50:47Z