Skip to main content

Im creating a report to see how many hours it takes for the Gong-Gainsight integration to create timeline entries since the activity happened.

In the interval, I cant find Hours. Also the resultant value is not decimal either.

What is the reasoning for not having Hours, Minutes, Seconds when literally there is Milliseconds? Maybe I should submit that as an Idea.

Also I noticed, it ignores the “Time” portion and simply shows the “Day” difference. However same formula shows milliseconds in difference where it considers the time portion. Its confusing how same formula behaves differently based on Interval. This is incorrect as the interval should only affect the FRACTION of the result, not the behaviour.
 

 

So, we did a workaround by dividing the milliseconds with 3600000 and got the hours!! But that formula field is inconsistent.
 

 

It makes no sense that is missing, and is inconsistent with the Date Diff formula in Rules Engine where the hour unit exists☹️
The same is true the other way around, the formula in rules engine is missing all units >Day. Both formulas should have all the options… #parity 


 

Reply


Terms & ConditionsCookie settings