Create a custom column on Platform Analytics to calculate the days difference from two date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2025 10:44 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2025 12:01 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-01-2025 12:06 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2025 05:53 AM
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.