Dividing a timestamp by a Number

[QlikSenseUser2]

I'm trying to divide timestamp by a number and get day, hour, and minute results. I currently have 

Interval(END_DATE_TIME-WO_DATE_TIME,'hh: mm')/Sum([WO Count])  this give me a number I need it the be in DD MM HH format

[rwunderlich]

Interval( (END_DATE_TIME-WO_DATE_TIME) / Sum([WO Count]) , 'd mm hh')

-Rob

[QlikSenseUser2]

It gave me the right format but didn't divide it.

[Kushal_Chawda]

@QlikSenseUser2  for the first record 65:00, what is the number are dividing? Also, what should be the output for that?

[QlikSenseUser2]

Dividing by 2 and 32.99 hrs

[rwunderlich]

As a test, how about adding 

Sum([WO Count])

as a measure in that table?  I suspect you are dividing by 1. 

-Rob

[Kushal_Chawda]

@QlikSenseUser2  how about below

interval(Interval( END_DATE_TIME-WO_DATE_TIME) / Sum([WO Count]) , 'd mm hh')

[QlikSenseUser2]

The ones  that are divided by 1   work but anything above doesn't

[QlikSenseUser2]

The ones  that are divided by 1   work but anything above doesn't

[rwunderlich · Accepted solution]

I see. You will need to Sum() the timestamp deltas.

Interval( Sum(END_DATE_TIME-WO_DATE_TIME) / Sum([WO Count]) , 'd mm hh')

-Rob