Count occurrences higher than

Question

Hi all,&nbsp;&nbsp;I'm having trouble with a visualization I'd like to create.&nbsp;&nbsp;Here's my data&nbsp;ID_Product&nbsp; &nbsp; &nbsp; rounded_%_acceptationa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10%b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10%c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20%d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20%e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50%&nbsp;What I'm trying to have is a scatter plot where the x axis would be the "rounded_%_acceptation" and the y axis would be the number of ID_Product having a rounded_%_acceptation higher than on x axis.I can't find a way to create this as this is comparing a column to itself.&nbsp;&nbsp;Thanks in advance!&nbsp;

v-yuta-msft · Accepted Answer

Anonymous&nbsp;,
&nbsp;
I'm afraid this can't be achieved, the text format data can't be placed to Y-axis because text format data can't be aggregated and Y-axis can't be multiple values.
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Count occurrences higher than

1 Reply

Related content

Count occurrence

Count each occurrence

Count occurrence of specific string

Count occurrences of specific values in a column

Counting nulls