Color setting on Scatter Plot

Hi, fellow Domosapiens,

 

I have a scatter plot of many points

 

Is it possible to group them by colours according to countries? (e.g. Australia points are blue, Hong Kong are red, etc)

I have tried the colour setting on the country column and it doesn't seem to work

  

Screen Shot 2018-02-21 at 3.00.38 PM.png

 

Comments

  • Hi

     

    Is the country the only series in your chart?

     

    Regards,

  • Hi @RGranada,

     

    Thanks for helping!

    The series used in the card are the different posts from facebook

    Each post belongs to a country

     

    Regards,

    mylee

  • Ok,

     

    So you have multiple series... Each Serie corresponds to posts from a determined country, is that it?

     

    Regards,

  • @RGranada, yes that is right, the data structure looks like the table below

    Currently, it is displaying all points as a different colour, was wondering if we can 'group' the colours, to display all 'Australia' as one colour, all 'Singapore' as another, etc

    Post / SeriesX-AxisY-AxisCountry
    A10115Singapore
    B11116Malaysia
    C12117Australia
    D13118New Zealand
    E14119Singapore
    F15120Singapore
    G16121Malaysia
    H17122Australia
    I18123New Zealand
    J19124Singapore

     

    ...

  • Can you please show me your card setup, just the columns section?

     

    Regards.

This discussion has been closed.