I have the need to make a calculation between dates - start and end and the result would be the ticket duration can you help me?
DATA/IN - 01/02/2021 01:00 AM
DATA/FIM - 01/02/2021 02:00 AM
RESULTADO TEMPO = 2Hs
And there is another need, which is to calculate a specific date - time EXP:
DATE: 2/1/2021 3:00 AM
DATE - 3H
You could make sure that you imported all 3 date-time fields in eazyBI as measures and properties .
DateDiffMinutes( [Measures].[Issue DATE IN], [Measures].[Issue DATE FIM] )
The result should be a duration in minutes (displayed in a nice format to convert minutes into days and hours).
Then you could use this measure for issue-level reports.
And then create one more to calculate the time between the first and third field values.
See two attached images.
Martins / eazyBI support