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

相關內容