i need to calculate overall %

[nvijay5757]

Hi

i need to calculate overall %(i have tried but not reached) like below table   measure(slno)

x	y	z
CHAS	OTHER	FRAME

Count({1} slno)/Count(total slno)

=Num(Count(distinct slno)/Count(total distinct slno),'#,##0.00%')

(Count(distinct slno)/Count(total slno))

help me for each dimension to display the %

#calculate overall %

[abhijitnalekar]

Hi @nvijay5757 ,

As I can see you have applied the correct expression.

Can you please share the sample data, so that i can also test at my level too 

[nvijay5757]

Hi Abhijit,

WC	WCC	WCC1	Condition
CHAS	OTHE	FRAME	FLA
CHAS	STEERING	STEERIN	LOOSE
CHAS	OTHER	POWERTRAIN	BROKEN
CHAS	OTHER	STANDARD	DOES NOT
CHAS	FRONT	FRONT	FLA
CHAS	SHOCK	FRONT	FLA
CHAS	SHOC	FRONT	LOOSE
CHAS	FRONT	FRONT	CHAFED
CHAS	SHOC	FRONT	CONTAMINATED
CHAS	SHOC	FRONT	LOOSE
CHAS	SHOC	REAR	SURFAC
CHAS	DISC	FRONT	SURFAC

sample data

i have taken measure rowno() as slno (measure).

[abhijitnalekar]

Hi @nvijay5757 ,

Are you looking for something like below.

[nvijay5757]

Hi Abhijit,

Exactly it can apply entire chart in (Sankey)

when i apply in chart its not working

[abhijitnalekar]

Hi @nvijay5757 ,

Check the below snap.

[nvijay5757]

Hi Abhijit,

can you please send the expression

[abhijitnalekar]

Count(WC)/Count(total WC)

[nvijay5757]

Hi Abhijit, Thank you

Actually i tried the same it is working fine

i am using cyclic dimension (7 Dimensions) when i select on cyclic dimension it is working

if cyclic dimension not selecting then it is not working

4 dimensions (using cyclic 3 dimensions)

Note: my question is without selecting cyclic dimension to display overall % is it possible or not.