How do i get a grand total in a column to show total time across all status's and tickets?

Question

I am using the Time in status report and have got all of the columns to show how long the tickets have been in each status. I have added a column that shows a concatenation of time for New and In process status by ticket, but i would also like to see the grand total of this column so i can see total time for all tickets in these status'.

What is the best way to do this?

Rahul_RVS · Answer

Thanks @Nikki Giddens for your reply.

If you are fine to try out our app. It allows to view page totals per status for upto 1000 issues per page.

Time in Status Reports

Disclaimer : I work for RVS, the vendor for this app

Nikki Giddens · Answer

Thanks Valeriia, i have tried downloading but im still not getting the grand total and its very manual to total up the hours etc - even if i change the column view to hours its still not the best formatting wise

Nikki Giddens · Answer

not as far as i am aware - its the time in status app that i have i believe