Hi I have this image where they have the same Process Name and with an END and START message. How is possible you can get the duration between the Start of the Process and End of the Process?
1 Like
Hello @danielreyes3rd, is the process name that is linked to the created date and message going to be unique for each process with a start and end message? My initial thought is you could nest a minOver and maxOver aggregation within a dateDiff function to find the difference between the start and end messages. Also, since it looks like they occurred within the same minute, we can use seconds as the period portion of the aggregation. It would look something like this:
dateDiff(minOver({created_ts}, [{process_name}], PRE_AGG), maxOver({created_ts}, [{process_name}], PRE_AGG), 'SS')
minOver will retrieve the Start timestamp and maxOver will retrieve the End timestamp. These functions are great so we can have both values on the same row and run aggregations on them.
I can include some documentation on the calculations I mentioned. Let me know if this helps!
1 Like
Hello @danielreyes3rd, were you able to implement the calculation I wrote above? Did it lead you to the expected output? If so, please mark my last response as the solution, otherwise let me know if you have any remaining questions. Thank you!
1 Like
Hi Dylan, yes I tried that but it wont show the right calculation. by the way I have another screen shot. I tried using that calculation but it wont work.
Hello @danielreyes3rd, did you receive an error when you tried to implement the calculation or was the output not what you were expecting? I don’t see it being utilized in the screen shot above, so I need some more information about the issue you are facing to help you further.
1 Like
Hello @danielreyes3rd, I wanted to check in since we have not heard back from you. In order for me to help guide you further, can you please follow-up with some more information related to the questions I asked above?
If we do not hear back from you in 3 days, I will archive this topic. Thank you!
Hello @danielreyes3rd, since we have not heard back from you with any further information, I will archive this topic. If you still need assistance please post a new question in the community and link to this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our Quick Sight experts. Thank you!