Multi-field formula returning null values

Hello Alteryx Community!

I am having issues with the multi-field tool and my expression returning null values for some rows. I am trying to calculate the duration between events in seconds and some of the rows are being calculated correctly while others are returning a null value.

I have tried to reformat the change timestamp field into a string and force a date / time format, but nothing has worked. I am still pretty new to Alteryx so I am guessing that this is an easy fix that someone has encountered before.

Thanks,

Matt

Agile lead time analysis 1.13.2021.yxmd

Data Investigation

Accepted answers

messi007

@MHS,

Please see below. The problem is the data type because the number of digit in result in second number is big.

Please let me know if it's okay 🙂

Attached the workflow.

Best Regards,

Agile lead time analysis 1.13.2021.yxmd

All comments

messi007

Hello @MHS,

Could you share the workflow with the data in order to help you 🙂

Best Regards,

MHS

I thought I had attached it earlier.

Let me know if this does not work.

Thanks,

Matt

Lead time analysis sample 1.14.2021.yxzp

Qiu

@MHS
I assume you are grouping by authors when using multi row tool so not suprise you get the null value for the last row.

So what is your desired output?

PS: your last share workflow is locked...😕

messi007

@MHS,

I agree with @Qiu about the group by.

However could re-share the zipped workflow because the last one is locked.

Best Regards,

MHS

Hi Qiu,

I believe I have uploaded the workflow without encryption so you can access the tools.

I am attempting to sort by the user ID column so that I can measure the duration from task to task (old and new status) to determine how much time was spent in a certain status. The output would contain a new column with the "Duration Seconds" listed for all the status's where the user ID column matches from row to row. Where the user ID column does not match would indicate a different user and should not be calculated and removed from the data set through the issue ID match multi-row formula.

There may be an easier way for me to get my hands on this and if so please share what your approach would be.

Hope this help and thanks again for all the help!

Matt

Lead time analysis sample 1.15.2021.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703