Customize Data Label in Scatter plot

Question & Answer
,
1

Can we enable Top N Date labels in Scatter plot?

2

Hi @mahalakshmi_18 ,

Could you please clarify your question in more detail?

A screenshot of your scatter plot would be very helpful. This will help me better understand exactly where you need assistance and give you more targeted support.

Thank you in advance!

Best regards,
Nico

3

HI @mahalakshmi_18 ,

I am not sure, do you want help in a specific case or is this a feature request?

If you wish this feature and your visual looks like:

image
image1674×615 108 KB

For the Top N Date labes in this view you have to decide if you want the Top N Dates depending on the x axis or the y axis or a combination of both. The combination is more difficult if the scales of x and y axis do not match (image comparing temperature with distances).

Best regards,
Nico

4

Hi @Nico ,

For my usecase, I need to display the data labels only for top 1 order date year based on Sales as in the image

image
image526×486 10.5 KB

But in QuickSight there is no option to customize the data labels in Scatter plot as per my requirement, either we can enable the data labels for all or none

image
image830×567 17.1 KB

Regards,
Mahalakshmi

5

Hi @mahalakshmi_18 ,
there is a workaround on this, but let me know if it can work for you.

Calculate the sales rank per year in this way (:

denseRank(
  [YourSalesField DESC],
  [truncDate('YYYY', {YourDateField})]
)

This will give a rank to your sales (summed up) per year, so you can now apply a filter like where rank = 1.

So, in your scatter plot:

image
image1157×547 51.1 KB

And you have to apply a filter on the visual like (given that SalesRankPerYear is the name of your calculated field):

image
image229×500 15.1 KB

Let us know if this works for you :slight_smile:

Andrea

6

Hi @andrepgn,

This actually doesn’t work for this use case as I need to display all the data points in the scatter plot, but the data label should be enabled only for the top 1 Order Date year based on sales as in the first image attached above

7

Yeah sorry, completely misread the issue :dotted_line_face:

I don’t think it’s possible directly with QuickSight “normal” configurations, but maybe something is feasible using HighCharts, which are more customizable.

Have you ever worked with HighCharts?

Andrea

8

Yes, will try with HighCharts
Thanks @andrepgn