Percentile for Date time stamp

Hi,

Can you please help me to solve the percentile(95th) calculation for the Date time field in my data set. Attached is my dataset, it has three fields and I have mentioned what operations have to be done on each field - Wave number( Group by), Start time(minimum of date-time), End time( need to get the 95th percentile of date time). I tried to convert End time to integer and use a summarize widget to get the percentile but it didnt work. Can you please help.

Thanks,

Naveen

Percentile Sample Data.xlsx

Tips and Tricks

Preparation

Accepted answers

grazitti_sapna

Hi @NNaveen , I used your new dataset that you provided and matched the end result and it is working please refer to the screenshot and workflow for your reference.

Alteryx O/P-

Excel O/p-

In case you have any queries please reach me out.

Thanks.

PercentileDatatimestamp_V2.yxmd

All comments

grazitti_sapna

Hi @NNaveen , is this what you are looking for? If not kindly share a sample of desired output.

Thanks.

PercentileDatatimestamp.yxzp

NNaveen

Hi @grazitti_sapna,

The attached sample data file has the output I am looking for. Please check the formula or values in cells E452, E881,E1265,E1635 and E1947 to understand what I am doing.

In your workflow, if you add summarize widget after you convert the date-time to Epoch time in seconds it might work. Can you please help me to convert epoch time back to date-time format. I am including the workflow for your reference.

Thanks,

Naveen

Percentile Data set v2.xlsx

PercentileDatatimestamp.yxmd

grazitti_sapna

Hi @NNaveen , I used your new dataset that you provided and matched the end result and it is working please refer to the screenshot and workflow for your reference.

Alteryx O/P-

Excel O/p-

In case you have any queries please reach me out.

Thanks.

PercentileDatatimestamp_V2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703