Calculate count of degree

[#1]

Hello Everybody

How can i calculate count of degree for A,B,C?

Degree expression =>  if([Exclusive Percentage]<=.8,'A',if([Exclusive Percentage]<=.9,'B','C'))

Store	Sales	Accumulated Sales	Inclusive Percentage	Exclusive Percentage	Degree
1703	22,030,000	22,030,000	2.096%	0.000%	A
708	21,821,000	43,851,000	4.172%	2.096%	A
706	19,766,000	63,617,000	6.053%	4.172%	A
1912	14,876,000	78,493,000	7.468%	6.053%	A
1610	4,045,000	837,245,000	79.661%	79.276%	A
1510	4,005,000	841,250,000	80.042%	79.661%	A
1568	3,944,000	845,194,000	80.417%	80.042%	B
1220	3,920,000	849,114,000	80.790%	80.417%	B
1906	3,902,000	853,016,000	81.161%	80.790%	B
1561	3,747,000	856,763,000	81.518%	81.161%	B
1218	2,730,000	949,728,000	90.363%	90.103%	C
1402	2,695,000	952,423,000	90.619%	90.363%	C
1709	2,690,000	955,113,000	90.875%	90.619%	C
1934	2,682,000	957,795,000	91.130%	90.875%	C
1567	2,665,000	960,460,000	91.384%	91.130%	C

[its_anandrjs]

Please elaborate more you want to calculate individual for A,B and C or weather need total count.

You can try also in any straight chart

Dim:- Store

Expre:- Count(Store)

Regards

Anand

[Gysbert_Wassenaar]

Which columns are fields from the source data and which columns are the result of chart expressions?

[#4]

Store and Sales fields are from source data.

[#5]

I want to calculate count individual for A,B and C.

[Gysbert_Wassenaar]

Then what are the expressions for Inclusive Percentage and Exclusive Percentage?

[its_anandrjs]

Hi,

For individually counting for A,B and C try this expressions

For A

=Count(if([Exclusive Percentage] <= .8 ,Store))

For B

=Count( if([Exclusive Percentage] >.8 and [Exclusive Percentage] <=.9 ,Store))

For C

=Count( if([Exclusive Percentage] > .9,Store))

For [Exclusive Percentage] field you can include the logic here in place of the [Exclusive Percentage] field and rest of the expression is same.

Other wise you can create this logic into the load script then you can use the [Exclusive Percentage] field into count expression.

Regard

Anand

[#8]

Accumulated Sales => rangesum(above(Sum (TOTAL_SALES_AMOUNT),0,rowno()))

Inclusive Percentage =>  rangesum(above(Sum (TOTAL_SALES_AMOUNT),0,rowno()))/(sum(total(TOTAL_SALES_AMOUNT)))

Exclusive Percentage => rangesum(above(Sum (TOTAL_SALES_AMOUNT),1,rowno()))/(sum(total(TOTAL_SALES_AMOUNT)))

[#9]

Thanks Dear Anand for your reply.

but [Exclusive Percentage] is not a field.

is there any script for create "pareto" logic?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.