https://community.qlik.com/t5/App-Development/Response-Time/m-p/1707057#M54201 <P>Hi Everyone,</P><P>Hope to seek your kind assistance with this task I'm stuck with. In the table below, it shows the following columns. Here's a few things you may want to take note:</P><OL><LI>InstalledProductNumber have Onsite Service and Remote Service</LI><LI>CreatedDate for an InstalledProductNumber is always the same for Onsite or Remote</LI><LI>There could be multiple StartDateTime for Onsite Service and could be the same for Remote Service</LI><LI>The earliest StartDateTime of Onsite Service and Remote Service are used for comparison (in First Start Column)</LI></OL><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="table" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34747iF0503A815DBA9FDA/image-size/large?v=v2&amp;px=999" role="button" title="Table.JPG" alt="table" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">table</span></span></P><P>&nbsp;</P><P>This graph below shows the response time of Onsite Service and Remote Service.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Onsite-Remote.JPG" style="width: 916px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34749i22E3D62791EF2B76/image-size/large?v=v2&amp;px=999" role="button" title="Onsite-Remote.JPG" alt="Onsite-Remote.JPG" /></span></P><P>&nbsp;</P><P>This brings me to my question..</P><P>If the earliest StartDateTime of Remote Service starts later than the earliest Onsite Service, I would like to change the Remote Service Response time to 0, meaning I would only like to show the dark orange part with 03:12:09</P><P>But if the earliest StartDateTime of Onsite Service starts later than earliest Remote Service, I would like the graph to remain exactly the same as above.</P><P>Can somebody please advise me with some functions I could use? Much appreciated!</P><P>PS: i have attached the sample data in Excel for your reference.</P> Mon, 01 Jun 2020 09:28:30 GMT Choi_ChiMin 2020-06-01T09:28:30Z https://community.qlik.com/t5/App-Development/Response-Time/m-p/1707057#M54201 <P>Hi Everyone,</P><P>Hope to seek your kind assistance with this task I'm stuck with. In the table below, it shows the following columns. Here's a few things you may want to take note:</P><OL><LI>InstalledProductNumber have Onsite Service and Remote Service</LI><LI>CreatedDate for an InstalledProductNumber is always the same for Onsite or Remote</LI><LI>There could be multiple StartDateTime for Onsite Service and could be the same for Remote Service</LI><LI>The earliest StartDateTime of Onsite Service and Remote Service are used for comparison (in First Start Column)</LI></OL><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="table" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34747iF0503A815DBA9FDA/image-size/large?v=v2&amp;px=999" role="button" title="Table.JPG" alt="table" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">table</span></span></P><P>&nbsp;</P><P>This graph below shows the response time of Onsite Service and Remote Service.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Onsite-Remote.JPG" style="width: 916px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34749i22E3D62791EF2B76/image-size/large?v=v2&amp;px=999" role="button" title="Onsite-Remote.JPG" alt="Onsite-Remote.JPG" /></span></P><P>&nbsp;</P><P>This brings me to my question..</P><P>If the earliest StartDateTime of Remote Service starts later than the earliest Onsite Service, I would like to change the Remote Service Response time to 0, meaning I would only like to show the dark orange part with 03:12:09</P><P>But if the earliest StartDateTime of Onsite Service starts later than earliest Remote Service, I would like the graph to remain exactly the same as above.</P><P>Can somebody please advise me with some functions I could use? Much appreciated!</P><P>PS: i have attached the sample data in Excel for your reference.</P> Mon, 01 Jun 2020 09:28:30 GMT https://community.qlik.com/t5/App-Development/Response-Time/m-p/1707057#M54201 Choi_ChiMin 2020-06-01T09:28:30Z