Forum Discussion

Mokegubshook's avatar
Mokegubshook
Icon for Helper I rankHelper I
1 year ago
Solved

Scatter Plot by each dot with each extraction

Hi, I can not find a way to make each dot in scatter plot to be separated by extraction. My desire is I want each dot to be separated by extraction, but each dot sum by day. Any way I can add each do...
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi Mokegubshook,

     

    If you would like each dot to represent a different extraction while still coloring only by company, please follow below approach:

    Create a new calculated column:

    Date_Extraction = [Date] & " - " & [Extraction]

    Then use this Date_Extraction column on the x-axis instead of plain date. This ensures that each extraction appears as a separate dot per day.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa