Count occurrences higher than

[Anonymous]

Hi all, 

I'm having trouble with a visualization I'd like to create. 

Here's my data

ID_Product      rounded_%_acceptation

a                                   10%

b                                   10%

c                                    20%

d                                   20%

e                                   50%

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. 

Thanks in advance!

[v-yuta-msft · Accepted solution]

@Anonymous ,

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.

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.