topic Calculating ticket resolution time on daily/monthly bases in Desktop
https://community.powerbi.com/t5/Desktop/Calculating-ticket-resolution-time-on-daily-monthly-bases/m-p/2427804#M868949
<P>hey all,</P><P> </P><P>im trying to calculate ticket resolution time without having to crossjoin the table with a DATE table.</P><P> </P><TABLE><TBODY><TR><TD>Date Created</TD><TD>Work Order</TD><TD>Vehicle</TD><TD>Status</TD><TD>Date Completed</TD></TR><TR><TD>1/5/2022</TD><TD>341364</TD><TD>AB230060</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341366</TD><TD>AB260242</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341367</TD><TD>AB210071</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341368</TD><TD>AB250554</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341379</TD><TD>AB230002</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341380</TD><TD>AB280023</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341394</TD><TD>AB230002</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341395</TD><TD>AB250426</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341396</TD><TD>AB250642</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341398</TD><TD>AB240121</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341399</TD><TD>AB230071</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341404</TD><TD>AB250692</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341472</TD><TD>AB250691</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341479</TD><TD>AB250570</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341481</TD><TD>AB250311</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341486</TD><TD>AB250309</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341488</TD><TD>AB250683</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341490</TD><TD>AB250460</TD><TD>Closed</TD><TD>1/5/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341491</TD><TD>AB250638</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341492</TD><TD>AB290059</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341496</TD><TD>AB250464</TD><TD>Closed</TD><TD>1/5/2022 0:00</TD></TR><TR><TD>1/2/2022</TD><TD>341497</TD><TD>AB250645</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341686</TD><TD>AB230137</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341688</TD><TD>AB240112</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341693</TD><TD>AB260054</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341779</TD><TD>AB230009</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341803</TD><TD>AB250088</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/1/2022</TD><TD>341811</TD><TD>AB260116</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341844</TD><TD>AB230307</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341867</TD><TD>AB250450</TD><TD>Open</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P>I'm hoping to end up with a Year/Month/Day table and see the trend of Mean Time To Resolution as a KPI</P>Wed, 30 Mar 2022 19:12:55 GMTAlasharim2022-03-30T19:12:55ZCalculating ticket resolution time on daily/monthly bases
https://community.powerbi.com/t5/Desktop/Calculating-ticket-resolution-time-on-daily-monthly-bases/m-p/2427804#M868949
<P>hey all,</P><P> </P><P>im trying to calculate ticket resolution time without having to crossjoin the table with a DATE table.</P><P> </P><TABLE><TBODY><TR><TD>Date Created</TD><TD>Work Order</TD><TD>Vehicle</TD><TD>Status</TD><TD>Date Completed</TD></TR><TR><TD>1/5/2022</TD><TD>341364</TD><TD>AB230060</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341366</TD><TD>AB260242</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341367</TD><TD>AB210071</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341368</TD><TD>AB250554</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341379</TD><TD>AB230002</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341380</TD><TD>AB280023</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341394</TD><TD>AB230002</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341395</TD><TD>AB250426</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341396</TD><TD>AB250642</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341398</TD><TD>AB240121</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341399</TD><TD>AB230071</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341404</TD><TD>AB250692</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341472</TD><TD>AB250691</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341479</TD><TD>AB250570</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341481</TD><TD>AB250311</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341486</TD><TD>AB250309</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341488</TD><TD>AB250683</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341490</TD><TD>AB250460</TD><TD>Closed</TD><TD>1/5/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341491</TD><TD>AB250638</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341492</TD><TD>AB290059</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341496</TD><TD>AB250464</TD><TD>Closed</TD><TD>1/5/2022 0:00</TD></TR><TR><TD>1/2/2022</TD><TD>341497</TD><TD>AB250645</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341686</TD><TD>AB230137</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341688</TD><TD>AB240112</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/2/2022</TD><TD>341693</TD><TD>AB260054</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341779</TD><TD>AB230009</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/5/2022</TD><TD>341803</TD><TD>AB250088</TD><TD>Closed</TD><TD>1/10/2022 0:00</TD></TR><TR><TD>1/1/2022</TD><TD>341811</TD><TD>AB260116</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/1/2022</TD><TD>341844</TD><TD>AB230307</TD><TD>Open</TD><TD> </TD></TR><TR><TD>1/5/2022</TD><TD>341867</TD><TD>AB250450</TD><TD>Open</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P>I'm hoping to end up with a Year/Month/Day table and see the trend of Mean Time To Resolution as a KPI</P>Wed, 30 Mar 2022 19:12:55 GMThttps://community.powerbi.com/t5/Desktop/Calculating-ticket-resolution-time-on-daily-monthly-bases/m-p/2427804#M868949Alasharim2022-03-30T19:12:55ZRe: Calculating ticket resolution time on daily/monthly bases
https://community.powerbi.com/t5/Desktop/Calculating-ticket-resolution-time-on-daily-monthly-bases/m-p/2434102#M870708
<P>Hi <LI-USER uid="370325"></LI-USER> ,</P>
<P>Is it convenient to share the results you are expecting regarding this data as a display? Not quite sure exactly what you are looking for.</P>
<P> </P>
<P>Best Regards</P>
<P>Lucien</P>Mon, 04 Apr 2022 02:32:48 GMThttps://community.powerbi.com/t5/Desktop/Calculating-ticket-resolution-time-on-daily-monthly-bases/m-p/2434102#M870708v-luwang-msft2022-04-04T02:32:48Z