SET ANALYSIS

[ajsjoshua]

hi all,

I have the consultant revenue and patient id .I want to find

1.the consultant who attended less patient and earned more revenue.

2.the consultant who attended more patient and earned more revenue.

3.the consultant who attended less patient and earned less revenue.

4.the consultant who attended more patient and earned less revenue.

PFA

ptid is patient id and bill net amount is the revenue.

Regards,

Joshua.

[Anil_Babu_Samineni]

How you want in layout orient?

[ajsjoshua]

Dear Anil,

I want display it in bar chart.

[Anil_Babu_Samineni]

Can you explain the logic behind for 1 sentence atleast

[Sergey_Shuklin]

Hello, Joshua!

Such tasks can be easily solved with scatter chart:

I used randomly generated data so there is a diagonal. But dimension and expressions are suits for you.

PFA

[Sergey_Shuklin · Accepted solution]

On your data it will be like this:

Gray lines is 66-percentile.