Count of items lying in each quadrant in a scatter plot

[ronman10]

Hi Guys,

I have created a scatter plot based on Stores and the sales by the each store. I would like to know the count of stores that lie in each quadrant. Is this possible? Please let me know.

Best Regards,

Rony

[Yoshidaqlik]

Hi

I suppose you put right reference lines

you can use set analysis filters on measures

A
Count({<Agrupamento={"=sum(Valor)<=17000"}>*<Agrupamento={"=count(Valor)<=32"}>} distinct Agrupamento)

B
Count({<Agrupamento={"=sum(Valor)<=17000"}>*<Agrupamento={"=count(Valor)>32"}>} distinct Agrupamento)

C
Count({<Agrupamento={"=sum(Valor)>17000"}>*<Agrupamento={"=count(Valor)<=32"}>} distinct Agrupamento)

D
Count({<Agrupamento={"=sum(Valor)>17000"}>*<Agrupamento={"=count(Valor)>32"}>} distinct Agrupamento)

Regards

[ronman10]

Hi Yoshida,

What do you mean by Agrupamento? Could you explain this expression to me?

Best Regards,

Rony

[anseglko]

Could you post a screenshot of your scatter graph?

What are the axes? Sales and what?

[Yoshidaqlik]

Hi,

In fact, I had forgotten to translate the formula,

Agrupamento would be your Stores

Valor would be the sales or whatever measure you want to put in the chart

Regards

[ronman10]

Yes. X axis is the growth in Average Selling Price and Y axis is the Volume growth. Attached is the screenshot.

[anseglko]

Okay, then use Yoshidaqlik's solution but change the values to your corresponding values

Count({<Store={"=avg(sellingprice)<=0"}>*<Store={"=avg(volumegrowth)<=0"}>} distinct Store)

I don't know what expressions you used to calculate the selling prices and volume growths, but put them in the above expressions.

[ronman10]

ok. Thanks Anseg and Yoshida. I'll try this and get back.

Rony

[ronman10]

Hi Guys,

The horizontal line represents ASP growth and vertical line represent Volume growth. I have taken store name as dimension. Formula for ASP growth used is, ((Sum({$<Year={"2019"}>}ASP))/(Sum({$<Year={"2018"}>}ASP)))-1 and volume growth is ((Sum({$<Year={"2019"}>}Volume))/Sum({$<Year={"2018"}>}Volume)))-1. Please guide me with respect to the complete expression.

Best Regards,

Rony

[anseglko]

Hi,

Does this work?

Count({<Store=
{"=$(((avg({$<Year={'2019'}>}ASP))/(avg({$<Year={'2018'}>}ASP)))-1)<=0"}
>*<Store=
{"=$(((avg({$<Year={'2019'}>}Volume))/(avg({$<Year={'2018'}>}Volume)))-1)<=0"}
distinct Store)