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

[davideluvotto]

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

[OlaN · Accepted solution]

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.

[davideluvotto]

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

[OlaN]

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.

[paulmagaling]

Hi @davideluvotto,

I have the same problem currently. Any update if you were to achieve your goal for this requirement?