Need help using Scatter Chart - ERROR: Remove details to display x and y pairs

[FrossiREAL]

Hey guys!

I'm trying to replicate the idea of this website but get the error "Remove Details to display x and y pairs" in the scatter chart.

The idea is to replicate a calendar.

In the Y-Axis I have the week days (1 to 6)

In the X-Axis i have the Week og the month (1 to 4 in some cases).

The blobs (SIZE) should be the the count of events in each day.

The problem is: I'm unable to SHOW the day number (ex: 1, 2, 3 until 30 days) on each blob.

When I drag my Day Of Month to TOOLTIP it works, but when i drag to Details it shows the Error: Remove details to display x and y pairs

Anyone knows?

I've already tried to change all the data types to whole numbers or string, but didn't worked...Working without day of monthdata tablewith day of month, error

[FrossiREAL · Accepted solution]

Hey guys, found an workaround.

Had to set "AVERAGE" on X an Y axis an then worked!

[Greg_Deckler]

@FrossiREAL - Try moving your Details column to Legend.

[amitchandak]

@FrossiREAL , are you using categorical value on X-axis with lots of values

[FrossiREAL]

I don't get it.

You mean that I can have multiple events on same day and because of that i wouldnt work?

Why it works when i set o Tooltip and dont work when set to "details"?