Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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 NumberModified Group NameModified DateTime taken by BAS Team
(Days/Hour/Min)
Total Resolution Time
(Days/Hour/Min)
   2.01:5925.15:37
17623648Desk9/6/2019 7:370.00:000.00:00
17623648CEM9/6/2019 14:510.00:000.07:13
17623648OS9/13/2019 6:440.00:006.15:53
17623648CEM9/17/2019 9:590.00:004.03:15
17623648DESK9/23/2019 8:520.00:005.22:52
17623648CEM9/24/2019 8:020.00:000.23:10
17623648BAS9/26/2019 10:022.01:592.01:59
17623648CEM9/26/2019 15:320.00:000.05:30
17623648DESK10/1/2019 23:150.00:005.07:43

 

Kindly help!

1 Solution

Accepted Solutions
Highlighted

Hi,

Convert the duration into seconds  and then calculate the %.

or

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

Thanks,

Priyanka

 

View solution in original post

1 Reply
Highlighted

Hi,

Convert the duration into seconds  and then calculate the %.

or

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

Thanks,

Priyanka

 

View solution in original post