Basic Calendar

Question & Answer
,
1

I would like to create a basic month view calendar where it shows current month and their corresponding days and dates. Similar to calendar in our phones.

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
3

Hi @rawoofar,
It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @rawoofar,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!