Calculate field - Quicksight

0

I have a date like this '26 jun. 14:06:00', but i need only the time, how i can extrac only the time ?

已提问 1 年前250 查看次数
1 回答
0

You can combine formatDate and substring to extract the relevant piece of information that you want.

formatDate(date, ['format']) https://docs.aws.amazon.com/quicksight/latest/user/formatDate-function.html

substring(expression, start, length) https://docs.aws.amazon.com/quicksight/latest/user/substring-function.html

If that doesn't work for any reason you can try extract to pull out only hours, minutes, and seconds then concat the fields together or use separate calculated fields.

extract(period, date) https://docs.aws.amazon.com/quicksight/latest/user/extract-function.html

I hope one of these solutions helps you.

专家
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则