Forum Discussion
Solved
help with pivot table
hello guys, i am new to pivot tables so please excuse me if this is easy for you. i have an excel sheet that contains IT tickets with their resolve time and response time. which from i created a pi...
That's with PivotTable based on data model if your Excel supports it. Creating PivotTable check "Add data to data model", create measures you need, like for such sample
as
Average Total:=AVERAGE(Table1[Time]) Average < 1 Hr:=CALCULATE( AVERAGE(Table1[Time]), Table1[Time] < 1/24 )create chart based on them and add cosmetic.
Easy by adding a formula next to the time which expresses these three periods. Assuming spent time is in B2:
=IF(B2<TIMEVALUE("1:00:00"),"<1 hr",IF(B2<TIMEVALUE("4:00:00"),"1 - 4 hrs",">4 hrs"))
=IF(B2<TIMEVALUE("1:00:00"),"<1 hr",IF(B2<TIMEVALUE("4:00:00"),"1 - 4 hrs",">4 hrs"))