Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count Data Points in a Quadrant of a scatter plot

Dear Ashish,

Hello All

Hope some one could help me please. I really need some help to count the # of points in each of the quardrants in the visual below. I have attached 2 visuals , the 2nd one is the data that is the tabular version of the data in the scatter plot. All are calculated measures  except the store list. Please if you could respond.

 

A store in Quadrant 1 ( red zone) is a store if its productivity index is lower than Target productivity Index ( 113% ) and lower than Last Year Productivity Index ( 111%). I was able to create the quadrant and visualize it in scatter plot but I now need to identify those stores separately and do calculations based on that.

 

No Replies