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 年前檢視次數 249 次
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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南