0

Time Calculation

Robert John Ramirez

October 11, 2018 09:03

None

Follow

Hi All,

I am working on a report which requires a calculated field, Technically these requirements will use the time value from dimensions. How will i be able to calculate time difference/combination if the values are from a dimension?

for example:

Order Time: 10:00 AM

Assigned order in to driver Time: 10:10 AM

Assigned order out to driver Time: 10:30 AM

I have to get the "at Door Time" by [(Assigned order in to driver Time)+(Assigned order out to driver Time)]/2

how will i able to compute the required value in JDM?

 

Thanks in advance.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jae Wilson October 11, 2018 12:40

  The easiest way to build this would be to implement an “accumulative snapshot” table

  Where you have one row for each order and then a column for order time, assigned to driver, order relievered etc.

  then you can just take the DateDiff to calculate minutes between dates. and then create the measures in JDM using basic Sum() function.

  Feel free to email me directly jae@onyxreporting.com