topic Re: Script help to change time stamp and create days length categories in Dashboards & Analytics Discussions

Script help to change time stamp and create days length categories

Jkovachi — Wed, 23 Mar 2022 13:47:20 GMT

Good day, Incorta community. I would really appreciate any help with my script.

Trying to update date from time stamp to date
Days difference to create length categories “1-7 days”, “8-14 days”, etc.”

Re: Script help to change time stamp and create days length categories

RADSr — Wed, 23 Mar 2022 15:09:29 GMT

Not sure you need the "format date" bit in there - can you just produce a formula column for days between?

If you can do that you can wrap that formula in the case() function.

If not then something like CASE( daysbtween( (formatdate(blah)), (formatdate(blah2)) < 7 , '0-7 Days', 'More Days' )

But really, start the troubleshoot by producing a days between column and making sure that bit works before adding more parens ( parens are my nemisis 😉 )

Re: Script help to change time stamp and create days length categories

dylanwan — Wed, 23 Mar 2022 15:29:34 GMT

If you have a column loaded from the source and the column is recognized as a timestamp column, you can go to the schema page and change the data type explicitly to "date" and load the data again.

It can also be set before you save the schema table after the extraction SQL was entered.

If you want to keep the column with the timestamp data type and create another formula column that do not have the time component, the formula is removeTime().

Re: Script help to change time stamp and create days length categories

dylanwan — Wed, 23 Mar 2022 15:41:14 GMT

@RADSr is correct! I tried his suggestion and it works:

Re: Script help to change time stamp and create days length categories

Jkovachi — Wed, 23 Mar 2022 18:56:06 GMT

Ty, I don't have access to the schema. I can only do at the insight level.

Re: Script help to change time stamp and create days length categories

Jkovachi — Wed, 23 Mar 2022 20:35:40 GMT

Thank you! This worked. 😀 I really appreciate the step by step instructions. Very helpful.

Re: Script help to change time stamp and create days length categories

Jkovachi — Wed, 23 Mar 2022 20:36:11 GMT

Ty for sharing.