Total time(mins) column to be display in descending order in view
Posted on 2004-10-05
I have created a view and there are 6 columns in this view.
Category Month Date Total Cases Duration Total Time(mins)
I would like my total time(mins) column to be the 1st column and the time which is highest to be display in the first row then second highest in second row.
My formula for my total time(mins) :
xDif := @If(to>from;to-from;from-to);
Hour := @Integer(xDif /3600);
Min:= @Modulo(xDif; 3600)/3600;
Tot := @Integer((Hour + Min)*60) ;
Second column to be Category which will be corresponding to total time in 1st column
Thus, I would like my view to be like this :
Total time(mins) Category Total Cases
950 Trouble 20
600 Project 10
500 Daily 8
445 Upgrade 12
334 Others 20
Thus, how do I configure my view?