AWS re:Post Knowledge Center Feedback Survey

Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.

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

Topics: Analytics Business Applications Machine Learning & AI
Tags: Amazon Quick Sight Analytics Amazon Redshift
Language: English

Shiva

asked 4 years ago381 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

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'.

EXPERT

Brettski-AWS

answered 4 years ago

Shiva
4 years ago
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
4 years ago
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)

Relevant content

How to resolve the issues in viewing the dataset and creating the calculated fields when using edit dataset option in quicksight?
AWS-User-2532357
asked 4 years ago
Error in Visual: The dataset changed too much for QuickSight to automatically update your analysis. You can edit the fields or filters in the current dataset, or replace it with a different dataset.
jros14
asked 4 years ago
Weekly Data metrics
Shiva
asked 4 years ago
In Quicksight, how do I filter out the CVE-number field (or any specific data item) from the Security Hub security findings dataset loaded from Athena (via Glue)
Okey
asked a year ago
How do I troubleshoot row-level security issues in Quick Sight?
AWS OFFICIALUpdated 2 months ago
How do I use templates to set up cross-account access in Quick Sight?
AWS OFFICIALUpdated 2 years ago
How do I troubleshoot issues with joined data sources in Quick Suite?
AWS OFFICIALUpdated 2 months ago
What do I do if I didn't receive a call from AWS to verify my new account or the PIN that I entered doesn't work?
AWS OFFICIALUpdated a year ago
Gathering QuickSight Dataset details for showback cost reporting
EXPERT
Heverin, Stephen
published a year ago
Enhancing backup governance with AWS Backup and QuickSight visualizations
AWS OFFICIALUpdated 9 months ago

Week number with If else

Add your answer

Relevant content