Hello,
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?
EXP:
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
Calculation:
DATE - 3H
Hi Henrique,
You could make sure that you imported all 3 date-time fields in eazyBI as measures and properties .
Then create a new calculated measure (and save it in one of the duration formats days hours minutes) with the formula DatediffMinutes:
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
