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

[Nishant8]

Hello @Alon Grod, can you please be specific about what's not working here?

as a next step, can you follow these steps once more and share the outcome:

- In you latest post, you seemed to be using wrong datediff(). 'now()' should appear before 'start' - glidefunction:datediff(now(),start)

- if you aren't able to configure function field directly in the reporting with now() method, then its an expected behavior, and for the same sake, it was asked to configure function field directly in the table and make use in the report. Configure as below and once done, don't try to manipulate the function field in the reporting:

- Now, select the same field in the reporting:

Regards,

Nishant

[Nishant8]

Hello @Alon Grod, can you please try to include the same function field in the reporting? I hope, it should display the desired outcome.

Regards,

Nishant