topic Re: Sum or Avg same date field but previous step in App Development https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770599#M59633 <P>Sum of days between tasks based on action_date</P> Sun, 27 Dec 2020 08:38:14 GMT Alarkis 2020-12-27T08:38:14Z Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770597#M59631 <P>&nbsp;</P><P>I want to&nbsp;Sum or Avg same date field but previous step (Action_date)</P><P>So i can now how much days it takes between tasks</P><P>this is how table looks:</P><P>Count -No. -ACTION_DATE -Task</P><TABLE><TBODY><TR><TD>1</TD><TD>995098</TD><TD>20-07-09 12:11</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>02-08-09 8:59</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>02-08-09 13:01</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>13-08-09 10:21</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 12:58</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 13:25</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 13:36</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 13:38</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>25-10-09 12:10</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>25-10-09 12:10</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>06-11-13 12:15</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:13</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:21</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:21</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:21</TD><TD>New_Application</TD></TR><TR><TD>2</TD><TD>1025913</TD><TD>21-05-20 16:26</TD><TD>New</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>13-06-20 18:05</TD><TD>Update</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>14-06-20 0:17</TD><TD>UpdateRequest</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>14-06-20 8:42</TD><TD>Social</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>14-06-20 14:56</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>15-06-20 1:47</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>02-07-20 12:01</TD><TD>Committe</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>02-07-20 12:03</TD><TD>Committee</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>09-11-20 9:25</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>09-11-20 12:32</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>25-11-20 11:10</TD><TD>Committee</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>25-11-20 12:24</TD><TD>Council</TD></TR></TBODY></TABLE><P>expected output:</P><P>Count - No. - ACTION_DATE - expected outcome - Task</P><TABLE><TBODY><TR><TD>1</TD><TD>995098</TD><TD>20-07-09 12:11</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>02-08-09 8:59</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>02-08-09 13:01</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>13-08-09 10:21</TD><TD>11.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 12:58</TD><TD>5.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 13:25</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 13:36</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>18-08-09 13:38</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>25-10-09 12:10</TD><TD>7.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>25-10-09 12:10</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>06-11-13 12:15</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:13</TD><TD>30.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:21</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:21</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>1</TD><TD>1001675</TD><TD>24-12-13 7:21</TD><TD>0.00</TD><TD>New_Application</TD></TR><TR><TD>2</TD><TD>1025913</TD><TD>21-05-20 16:26</TD><TD>0.00</TD><TD>New</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>13-06-20 18:05</TD><TD>&nbsp;</TD><TD>Update</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>14-06-20 0:17</TD><TD>&nbsp;</TD><TD>UpdateRequest</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>14-06-20 8:42</TD><TD>&nbsp;</TD><TD>Social</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>14-06-20 14:56</TD><TD>&nbsp;</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>15-06-20 1:47</TD><TD>&nbsp;</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>02-07-20 12:01</TD><TD>&nbsp;</TD><TD>Committe</TD></TR><TR><TD>1</TD><TD>995287</TD><TD>02-07-20 12:03</TD><TD>&nbsp;</TD><TD>Committee</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>09-11-20 9:25</TD><TD>&nbsp;</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>09-11-20 12:32</TD><TD>&nbsp;</TD><TD>Approval</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>25-11-20 11:10</TD><TD>&nbsp;</TD><TD>Committee</TD></TR><TR><TD>1</TD><TD>995098</TD><TD>25-11-20 12:24</TD><TD>&nbsp;</TD><TD>Council</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 17:40:17 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770597#M59631 Alarkis 2024-11-16T17:40:17Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770598#M59632 <P>What are you expecing as outcome?</P> Sun, 27 Dec 2020 08:34:15 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770598#M59632 Anil_Babu_Samineni 2020-12-27T08:34:15Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770599#M59633 <P>Sum of days between tasks based on action_date</P> Sun, 27 Dec 2020 08:38:14 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770599#M59633 Alarkis 2020-12-27T08:38:14Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770600#M59634 <P>Output please?</P> Sun, 27 Dec 2020 09:24:47 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770600#M59634 Anil_Babu_Samineni 2020-12-27T09:24:47Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770601#M59635 <P>I added to main post&nbsp;</P><P>thanks</P> Sun, 27 Dec 2020 09:37:37 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770601#M59635 Alarkis 2020-12-27T09:37:37Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770602#M59636 <P>Will you able to share more data than 2-5 records? It would be easy to handle if you have different tasks and expected output?</P> Sun, 27 Dec 2020 10:22:24 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770602#M59636 Anil_Babu_Samineni 2020-12-27T10:22:24Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770607#M59637 <P>Updated please check</P> Sun, 27 Dec 2020 11:05:44 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770607#M59637 Alarkis 2020-12-27T11:05:44Z Re: Sum or Avg same date field but previous step https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770611#M59638 <P>Sorry, If i am asking too many questions, But I still not understanding your requirement? Why 1st count is Zero since it is counting the value of 2nd step? Can you please explain the logic behind. also confirm where you need script or design?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2020-12-27 14_31_06-Re_ Sum or Avg same date field but previous step - Qlik Community - 1770597.png" style="width: 608px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46162i6B49B9B329DDCE2A/image-size/large?v=v2&amp;px=999" role="button" title="2020-12-27 14_31_06-Re_ Sum or Avg same date field but previous step - Qlik Community - 1770597.png" alt="2020-12-27 14_31_06-Re_ Sum or Avg same date field but previous step - Qlik Community - 1770597.png" /></span></P> Sun, 27 Dec 2020 13:34:50 GMT https://community.qlik.com/t5/App-Development/Sum-or-Avg-same-date-field-but-previous-step/m-p/1770611#M59638 Anil_Babu_Samineni 2020-12-27T13:34:50Z