Create a custom column on Platform Analytics to calculate the days difference from two date

davideluvotto
Tera Expert

Hi all,

 

Is there anyone who can suggest a method to add a custom column in Platform Analytics that calculates the difference between two dates?

For example, the difference in days between the opened date and the closed date of an Incident.

 

Thanks,
D

3 REPLIES 3

OlaN
Giga Sage
Giga Sage

Hi,

A while back I made a tool to calculate the difference between two dates with Flow Designer.

Perhaps you can use it to set the value of a custom field in your table.

Ffor instance when an Incident is closed, the value would be set,

and then you can perform the reporting directly on that field.

Hi OlaN, I don’t want to create a custom field on the table, but I would like to have a formula field within Platform Analytics.

Do you know any method to do this?

 

Thanks,
D

Sorry, no. As per my understanding, this is not possible unless you have a field that calculates and stores the values for you. Platform analytics can then present the data in various ways for you.

 

I might be mistaken, I haven't dived that deep into Platform analytics yet.