Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date on x-axis - scatter plot

 Hi guys,    Having an issue with Scatter Plots and adding Date to X-Axis, my dataset is fairly simple.      So just wanting to use the CycleTimeDays for the y-axis, CompletedDate on the x...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    “So if they were distinct (i.e. if i changed the data format back to have the timestamp) then it wouldn't be an issue?”

    No.

    In scatter chart, when you add non-numerical columns to the X axis, the Y axis is required to be aggregated (This is true even if your data does not contain duplicate rows.). 

    If you add a numeric column to the X axis, you don't have to aggregate.( even if there are duplicate rows ).

     

     

    It may be because the Y-axis can only be numeric data and represent the size of the value in the chart, it is meaningless if it is not aggregated.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

The workaround would be to explore some custom visuals, see if you can find one that meets your requirement.

Or refer to the error message and adjust four fields as suggested.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn