Scatterplot Chart with dual axis

Question & Answer
,
1

I am trying to create a heatmap chart with day vs. month for a year. Is this possible?

Expected:

image
image1006×500 16.5 KB

I have the order date as a date field, I duplicated the order date as ‘day of the week’ and I managed to bring this view. However, I would like to show the day name instead of day numbers (1,2,3)

I managed to bring the view using the calc field.

extract(‘WD’, {Date})

Trying month and day view

3

I managed to figure this out using the following calculation.

ifelse(extract(‘WD’, {Order Date})=1, ‘Sun’, extract(‘WD’, {Order Date})=2, ‘Mon’, extract(‘WD’, {Order Date})=3, ‘Tue’, extract(‘WD’, {Order Date})=4, ‘Wed’, extract(‘WD’, {Order Date})=5, ‘Thu’, extract(‘WD’, {Order Date})=6, ‘Fri’, ‘Sat’)