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

주제

분석

태그

분석 아마존 QuickSight 아마존 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

관련 콘텐츠