Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jaswanthchitra9
Contributor II
Contributor II

convert calculated column from minutes to days in set analysis.

Hello Everyone,

I have set expression in that I'm using one calculated column that column in minutes and  that column need to convert it into days can anyone help me on that. find the below expression for your reference.

 

num(count({<Account={'xyz'},Source={'Problem'},Closed_13Month={1},[Assignee Group]={'Ntt*'},[Priority Text] = {'3 - Normal'},
[Short Description] = {'Root Cause Analysis'},UpElapsedTime={'<=2500'}>}[Ticket Id])/
count({<Account={'xyz'},Source={'Problem'},Closed_13Month={1},[Assignee Group]={'Ntt*'},[Priority Text] = {'3 - Normal'},
[Short Description] = {'Root Cause Analysis'}>}[Ticket Id]),'##.##%')

Labels (2)
1 Reply
MarcoWedel

you could just divide your minutes by 1440