Configure function field on report

[Alon Grod]

 I have a report on metric_instance table. I want to add a function field that will calculate the duration from the start field of type Date/Time to the current time at the moment. What should i write instead of ‘end’?

I attached image

[Alon Grod]

@Ankur Bawiskar Hi im doing this on a report on the metric_instance table. start is a field on this table and i need the difference between start and now (the current time)

[Ankur Bawiskar]

@Alon Grod 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Nishant8]

Hello @Alon Grod, you can create a 'Duration' type field in the 'metric_instance' table as depicted below and then make use of the same field in reporting ( while creating report, you can find the same field in the Configure -> choose columns step). please give a reasonable name as below screenshot is just for the reference

Regards,

Nishant

[Alon Grod]

@Nishant8 Hi but i need the difference between start field to the current time of the login user

[Nishant8]

Hello @Alon Grod, you can replace the glidefunction as below:

glidefunction:datediff(now(),start)

Regards,

Nishant