Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
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

you could just divide your minutes by 1440