data-visualizationanalyticsamazon-quicksight

Is there any way to get day from date in quicksight?

I am trying to get day from date field in quicksight.

Following is date format in quicksight: 2020-09-29T00:00:00.000Z

I want some function which will parse the date and give the day from this date. i.e., Tuesday

Solution

  • In the QuickSight Dataset you can define a Calculated Field.

    In your case, e.g. toString(extract('WD',{transaction_date})). This returns the day of the week as an integer, with Sunday as 1. If you need it as a word, you can further translate it with ifelse function.