Basic Calendar

Question & Answer
,
2

Hi @rawoofar,

Welcome to the Quicksight Community and thank you for posting your question.

I would recommend you to refer these post from which you can get lot of insights to create a calendar.

  1. Calendar visual
  2. Calendar Heat Map
  3. Creating a Calendar-Style Line Graph with Color Shading in Quicksight

I have created the below visuals by using heatmap.

  • Calculated fields created -
    • DayOfWeek (ifelse(extract(‘WD’, {order date}) = 1, ‘Sunday’,
      extract(‘WD’, {order date}) = 2, ‘Monday’,
      extract(‘WD’, {order date}) = 3, ‘Tuesday’,
      extract(‘WD’, {order date}) = 4, ‘Wednesday’,
      extract(‘WD’, {order date}) = 5, ‘Thursday’,
      extract(‘WD’, {order date}) = 6, ‘Friday’,
      extract(‘WD’, {order date}) = 7, ‘Saturday’,
      ‘Unknown’)
      )
  • DayOfMonth extract(‘MM’, {order date}) or you can also extract days using (extract(‘DD’, {order date}))

image
image1379×662 57.6 KB

image
image1139×760 29.5 KB

I hope that helps

Thank you,
Shravya

2 Likes