New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

Calculate percent on top of sum

Hello Everyone!!

I need to calculate percentage on sum of Date which is in day, hour and min format. I have calculation in 2 columns:

Time taken by BAS Team

Formula used-

interval(sum(Aggr(
if ("Modified Group Name"='BAS',
Interval(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Modified Date],1) - [Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Ticket Number],([Modified Date], (NUMERIC)))),'d.hh:mm'),0),[Ticket Number],([Modified Date],(NUMERIC)))),'d.hh:mm')

Total Resolution Time- Overall time consumed

Formula Used-

Interval(sum(Aggr(Interval(Rangemax( Interval((Above(TOTAL [Modified Date],1) - [Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Ticket Number],([Modified Date], (NUMERIC)))),'d.hh:mm')

Now the requirement is , I want to calculate the time in percentage and not in sum. Like how much percent BAS team worked and how much percent in total time spent.

Please note I have multiple tickets.

 Ticket Number Modified Group Name Modified Date Time taken by BAS Team(Days/Hour/Min) Total Resolution Time(Days/Hour/Min) 2.01:59 25.15:37 17623648 Desk 9/6/2019 7:37 0.00:00 0.00:00 17623648 CEM 9/6/2019 14:51 0.00:00 0.07:13 17623648 OS 9/13/2019 6:44 0.00:00 6.15:53 17623648 CEM 9/17/2019 9:59 0.00:00 4.03:15 17623648 DESK 9/23/2019 8:52 0.00:00 5.22:52 17623648 CEM 9/24/2019 8:02 0.00:00 0.23:10 17623648 BAS 9/26/2019 10:02 2.01:59 2.01:59 17623648 CEM 9/26/2019 15:32 0.00:00 0.05:30 17623648 DESK 10/1/2019 23:15 0.00:00 5.07:43

Kindly help!

1 Solution

Accepted Solutions
Creator II

Hi,

Convert the duration into seconds  and then calculate the %.

or

(column(1)/column(2))*100

Thanks,

Priyanka

Creator II

Hi,

Convert the duration into seconds  and then calculate the %.

or

(column(1)/column(2))*100

Thanks,

Priyanka

Tags
Community Browser