Week number with If else

I am new to create calculated fields with the Quicksight. I have some dataset with the resolved tickets information which needs to be shown with the tag and with the week of the year. Is it possible to show through table ?

Example ) I have 10,000 resolved tickets for each week which needs to show through week numbers only and with the selected tag with the ticket. I have access to the dataset but unable show the same through Week numbers

主题

分析

标签

分析 Amazon QuickSight Amazon Redshift

语言

English

Shiva

已提问 2 年前237 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

I'm not a QuickSight expert but a search turned up this which may help:

Click the dropdown for your date field, mouse over Format and select 'More formatting options'. On the left panel in the Custom dropdown type 'w'.

专家

Brettski-AWS

已回答 2 年前

Shiva
2 年前
Thanks for your comment.I am able to extract for the visualization purpose with the drill down to Week and Month is there.When tried to use a table to show the weekly numbers of the tickets i am unable to do that
MLGuy
2 年前
Create a calculated field that will use the w format from https://www.joda.org/joda-time/apidocs/org/joda/time/format/DateTimeFormat.html, using the formatDate function (https://docs.aws.amazon.com/quicksight/latest/user/formatDate-function.html)

Week number with If else

相关内容